1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
--
-- Licensed to the Apache Software Foundation (ASF) under one or more
-- contributor license agreements. See the NOTICE file distributed with
-- this work for additional information regarding copyright ownership.
-- The ASF licenses this file to You under the Apache License, Version 2.0
-- (the "License"); you may not use this file except in compliance with
-- the License. You may obtain a copy of the License at
--
-- http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
driver 'org.apache.derby.jdbc.ClientDriver';
--Bug 4632 Make the db italian to make sure string selects are working
connect 'testij;create=true;territory=it' USER 'dbadmin' PASSWORD 'dbadmin';
connect 'testij' USER 'dbadmin' PASSWORD 'dbadbmin';
-- this is a comment, a comment in front of a select should not cause an error
select * from sys.systables where 1=0;
-- this is a comment, a comment in front of a values clauses should not cause an error
values(1);
-- Try some URL attributes
disconnect all;
connect 'testij2;create=true' USER 'dbadmin' PASSWORD 'dbadbmin';
select * from APP.notthere;
-- examples from the docs
connect 'testij2;create=true;user=judy;password=judy';
connect './testij2;user=judy;password=judy';
connect 'toursDB';
connect 'toursDB' USER 'dbadmin' PASSWORD 'dbadbmin';
connect 'wombat' USER 'APP' PASSWORD 'APP';
connect 'testij2;create=true;user=usr;password=pwd';
connect 'testij2;upgrade=true;user=usr;password=pwd';
connect 'testij2;shutdown=true;user=usr;password=pwd';
connect './testij2;create=true;user=usr;password=pwd';
connect './testij2;create=true;user=usr;password=pwd';
connect 'testij2;create=true;user=usr;password=pwd';
connect 'testij2;upgrade=true;user=usr;password=pwd';
connect 'testij2;shutdown=true;user=usr;password=pwd';
-- retrieveMessageText Testing
connect 'testij2;create=true;user=usr;password=pwd;retrieveMessageText=false';
-- Should not get message text
select * from APP.notthere;
connect 'testij2;create=true;user=usr;password=pwd;retrieveMessageText=true';
-- Should see message text
select * from APP.notthere;
-- just user security mechanism
connect 'testij2;create=true;user=usr;retrieveMessageText=true';
connect 'wombat' USER 'APP';
disconnect all;
|
