db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Myrna van Lunteren <m.v.lunte...@gmail.com>
Subject Re: Need some help with setting up my Derby development testing environment
Date Tue, 01 Nov 2005 18:36:43 GMT
I think your problem is indeed with db2jcc. Your sysinfo reports it's
version 1.0:
 "[/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc.jar] 1.0 - (581)"
I think we only support 2.4 and up with derby 10 and up. Try to download a
later version if you need jcc.
(Unless of course sysinfo doesn't report it correctly...)
 Myrna

 On 11/1/05, Bryan Pendleton <bpendleton@amberpoint.com> wrote:
>
> Thanks for the quick help, everybody!
>
> I am working with trunk as of a few weeks ago. I am building
> all the code from scratch, including building derbyTesting.jar.
> The builds were completely uneventful. I am running with the
> insane jars built by "ant buildjars".
>
> Running store/access.sql was fine.
> Running lang/supersimple.sql was fine.
> Running -Dframework=DerbyNetClient lang/supersimple.sql was fine.
>
> Running -Dframework=DerbyNet lang/supersimple.sql blew up badly.
>
> Attached are a few of the files in the resulting "DerbyNet" subdirectory.
> (I would have sent the whole thing, but this list doesn't accept
> zips :) ).
>
> Do you see the problem from any of the files here?
>
> thanks,
>
> bryan
>
>
> ------------------ Java Information ------------------
> Java Version: 1.4.2_06
> Java Vendor: Sun Microsystems Inc.
> Java home: /usr/local/lib/j2sdk1.4.2_06/jre
> Java classpath:
> /home/bpendleton/src/derby-subversion/trunk/tools/java/jakarta-
> oro-2.0.8.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyTesting.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derby.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbytools.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbynet.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyclient.jar:/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc.jar:/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc_license_c.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_de_DE.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_es.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_fr.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_it.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_ja_JP.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_ko_KR.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_pt_BR.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_zh_CN.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_zh_TW.jar
> OS name: Linux
> OS architecture: i386
> OS version: 2.4.21-27.0.2.ELsmp
> Java user name: bpendleton
> Java user home: /home/bpendleton
> Java user dir: /home/bpendleton/src/derby-subversion/tests2
> java.specification.name <http://java.specification.name>: Java Platform
> API Specification
> java.specification.version: 1.4
> --------- Derby Information --------
> JRE - JDBC: J2SE 1.4.2 - JDBC 3.0
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derby.jar]
> 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbytools.jar]
> 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbynet.jar]
> 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyclient.jar]
> 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> [/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc.jar] 1.0 - (581)
> [/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc_license_c.jar] 1.0 -
> (581)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> Current Locale : [English/United States [en_US]]
> Found support for locale: [de_DE]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [es]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [fr]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [it]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [ja_JP]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [ko_KR]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [pt_BR]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [zh_CN]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [zh_TW]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> ------------------------------------------------------
> Framework: DerbyNet
> *** Start: supersimple jdk1.4.2_06 DerbyNet 2005-11-01 10:17:02 ***
> 0a1
> > ERROR 08001: No suitable driver
> 2a4
> > IJ ERROR: Unable to establish connection
> 4 del
> < 0 rows inserted/updated/deleted
> 4a6
> > IJ ERROR: Unable to establish connection
> 6 del
> < 1 row inserted/updated/deleted
> 6a8
> > IJ ERROR: Unable to establish connection
> 8 del
> < A
> 9 del
> < -----
> 10 del
> < 1
> 10a10
> > IJ ERROR: Unable to establish connection
> 12 del
> < 0 rows inserted/updated/deleted
> 12a12
> > IJ ERROR: Unable to establish connection
> 14 del
> < 0 rows inserted/updated/deleted
> 14a14
> > IJ ERROR: Unable to establish connection
> 16 del
> < 1 row inserted/updated/deleted
> 16a16
> > IJ ERROR: Unable to establish connection
> 18 del
> < 1 row inserted/updated/deleted
> 18a18
> > IJ ERROR: Unable to establish connection
> 20 del
> < 1 row inserted/updated/deleted
> 20a20
> > IJ ERROR: Unable to establish connection
> 22 del
> < 1 row inserted/updated/deleted
> 22a22
> > IJ ERROR: Unable to establish connection
> 24 del
> < SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
> 25 del
> < -----
> 26 del
> < 2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
> 27 del
> < -----32768 |-2147483648 |-9223372036854775808 |1.2E-37 |2.225E-307
> |2.225E-307 |-56.12 |-123456.123 |one |one |one |01abcd |one
> 28 del
> < NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL
> |NULL
> 29 del
> < 32767 |2147483647 |9223372036854775807 |1.4 |3.4028235E38 |3.4028235E38
> |999.99 |9999999.999 |one |one |one |01abcd |one
> 29a24
> > IJ ERROR: Unable to establish connection
> 31 del
> < 0 rows inserted/updated/deleted
> 31a26
> > IJ ERROR: Unable to establish connection
> 33 del
> < 0 rows inserted/updated/deleted
> 33a28
> > IJ ERROR: Unable to establish connection
> 35 del
> < 1 row inserted/updated/deleted
> 35a30
> > IJ ERROR: Unable to establish connection
> 37 del
> < 1 row inserted/updated/deleted
> 37a32
> > IJ ERROR: Unable to establish connection
> 39 del
> < SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
> 40 del
> < -----
> 41 del
> < 2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
> 42 del
> < -----32768 |-2147483648 |-9223372036854775808 |1.2E-37 |2.225E-307
> |2.225E-307 |-56.12 |-123456.123 |one |one |one |01abcd |one
> 42a34
> > IJ ERROR: Unable to establish connection
> 44 del
> < 1
> 45 del
> < -----
> 46 del
> < 10
> 46a36
> > IJ ERROR: Unable to establish connection
> 48 del
> < 1
> 49 del
> < -----
> 50 del
> < hello
> 50a38
> > IJ ERROR: Unable to establish connection
> 52 del
> < 1
> 53 del
> < -----
> 54 del
> < 1.2
> 54a40
> > IJ ERROR: Unable to establish connection
> 56 del
> < 0 rows inserted/updated/deleted
> 56a42
> > IJ ERROR: Unable to establish connection
> 59 del
> < ALIASINFO
> 60 del
> < -----
> 60a45
> > IJ ERROR: Unable to establish connection
> 62a48
> > IJ ERROR: Unable to establish connection
> 64 del
> < 0 rows inserted/updated/deleted
> 64a50
> > IJ ERROR: Unable to establish connection
> 66 del
> < 1 row inserted/updated/deleted
> 66a52
> > IJ ERROR: Unable to establish connection
> 68 del
> < A
> 69 del
> < -----
> 70 del
> < 1
> 70a54
> > IJ ERROR: Unable to establish connection
> 71a56
> > IJ ERROR: Unable to establish connection
> 73 del
> < 0 rows inserted/updated/deleted
> 73a58
> > IJ ERROR: Unable to establish connection
> 74a60
> > IJ ERROR: Unable to establish connection
> 76 del
> < A
> 77 del
> < -----
> 78 del
> < 1
> 78a62
> > IJ ERROR: Unable to establish connection
> 80 del
> < 0 rows inserted/updated/deleted
> 80a64
> > IJ ERROR: Unable to establish connection
> 81a66
> > IJ ERROR: Unable to establish connection
> 82a68
> > IJ ERROR: Unable to establish connection
> 94 del
> < 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
> |78 |79 |80 |81 |82 |83 |84
> 95 del
> < -----
> 96 del
> < 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
> |78 |79 |80 |81 |82 |83 |84
> 96a80
> > IJ ERROR: Unable to establish connection
> 107 del
> < 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
> |78 |79 |80 |81 |82 |83 |84 |85 |86
> 108 del
> < -----
> 109 del
> < 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
> |78 |79 |80 |81 |82 |83 |84 |85 |86 |87 |88 |89 |90 |91 |92 |93 |94 |95 |96
> |97 |98 |99 |100
> 109a91
> > IJ ERROR: Unable to establish connection
> 113 del
> < 0 rows inserted/updated/deleted
> 113a95
> > IJ ERROR: Unable to establish connection
> 115 del
> < ERROR 22003: The resulting value is outside the range for the data type
> INTEGER.
> 115a97
> > IJ ERROR: Unable to establish connection
> 117 del
> < 1 row inserted/updated/deleted
> 117a99
> > IJ ERROR: Unable to establish connection
> 119 del
> < A
> 120 del
> < -----
> 121 del
> < 1
> 121a101
> > IJ ERROR: Unable to establish connection
> 123 del
> < 0 rows inserted/updated/deleted
> 123a103
> > IJ ERROR: Unable to establish connection
> 126a107
> > IJ ERROR: Unable to establish connection
> 128 del
> < 0 rows inserted/updated/deleted
> 128a109
> > IJ ERROR: Unable to establish connection
> 130a112
> > IJ ERROR: Unable to establish connection
> 132 del
> < 0 rows inserted/updated/deleted
> 132a114
> > IJ ERROR: Unable to establish connection
> 134 del
> < 1 row inserted/updated/deleted
> 134a116
> > IJ ERROR: Unable to establish connection
> 135a118
> > IJ ERROR: Unable to establish connection
> 137 del
> < 1 row inserted/updated/deleted
> 137a120
> > IJ ERROR: Unable to establish connection
> 139 del
> < ij(CONNECTION1)> -- by default, holdability of ResultSet objects created
> using this Connection object is true. Following will set it to false for
> this connection.
> 139a122,123
> > ERROR 08001: No suitable driver
> > ij> -- by default, holdability of ResultSet objects created using this
> Connection object is true. Following will set it to false for this
> connection.
> 141 del
> < ij(CONNECTION1)> prepare s1 as 'select * from t';
> 142 del
> < ij(CONNECTION1)> execute s1;
> 143 del
> < I
> 144 del
> < -----
> 145 del
> < ERROR 40XL1: A lock could not be obtained within the time requested
> 146 del
> < ij(CONNECTION1)> execute s1;
> 147 del
> < I
> 148 del
> < -----
> 149 del
> < ERROR 40XL1: A lock could not be obtained within the time requested
> 150 del
> < ij(CONNECTION1)> -- Bug 5967 - Selecting from 2 lob columns w/ the first
> one having data of length 0
> 150a125,132
> > IJ ERROR: Unable to establish connection
> > ij> prepare s1 as 'select * from t';
> > IJ ERROR: Unable to establish connection
> > ij> execute s1;
> > IJ ERROR: Unable to establish connection
> > ij> execute s1;
> > IJ ERROR: Unable to establish connection
> > ij> -- Bug 5967 - Selecting from 2 lob columns w/ the first one having
> data of length 0
> 152 del
> < 0 rows inserted/updated/deleted
> 153 del
> < ij(CONNECTION1)> insert into t1 values ('', 'some clob');
> 154 del
> < 1 row inserted/updated/deleted
> 155 del
> < ij(CONNECTION1)> select * from t1;
> 156 del
> < C1 |C2
> 157 del
> < -----
> 158 del
> < |some clob
> 159 del
> < ij(CONNECTION1)> select c2 from t1;
> 160 del
> < C2
> 161 del
> < -----
> 162 del
> < some clob
> 163 del
> < ij(CONNECTION1)> insert into t1 values ('', '');
> 164 del
> < 1 row inserted/updated/deleted
> 165 del
> < ij(CONNECTION1)> insert into t1 values ('some clob', '');
> 166 del
> < 1 row inserted/updated/deleted
> 167 del
> < ij(CONNECTION1)> select * from t1;
> 168 del
> < C1 |C2
> 169 del
> < -----
> 170 del
> < |some clob
> 171 del
> < |
> 172 del
> < some clob |
> 173 del
> < ij(CONNECTION1)> select c2 from t1;
> 174 del
> < C2
> 175 del
> < -----
> 176 del
> < some clob
> 177 del
> < ij(CONNECTION1)> drop table t1;
> 178 del
> < 0 rows inserted/updated/deleted
> 179 del
> < ij(CONNECTION1)>
> 179 add
> > IJ ERROR: Unable to establish connection
> > ij> insert into t1 values ('', 'some clob');
> > IJ ERROR: Unable to establish connection
> > ij> select * from t1;
> > IJ ERROR: Unable to establish connection
> > ij> select c2 from t1;
> > IJ ERROR: Unable to establish connection
> > ij> insert into t1 values ('', '');
> > IJ ERROR: Unable to establish connection
> > ij> insert into t1 values ('some clob', '');
> > IJ ERROR: Unable to establish connection
> > ij> select * from t1;
> > IJ ERROR: Unable to establish connection
> > ij> select c2 from t1;
> > IJ ERROR: Unable to establish connection
> > ij> drop table t1;
> > IJ ERROR: Unable to establish connection
> > ij>
> Test Failed.
> *** End: supersimple jdk1.4.2_06 DerbyNet 2005-11-01 10:17:05 ***
>
>
> ERROR 08001: No suitable driver
> ij> -- by default, holdability of ResultSet objects created using this
> Connection object is true. Following will set it to false for this
> connection.
> NoHoldForConnection;
> IJ ERROR: Unable to establish connection
> ij> create table a (a int);
> IJ ERROR: Unable to establish connection
> ij> insert into a values (1);
> IJ ERROR: Unable to establish connection
> ij> select * from a;
> IJ ERROR: Unable to establish connection
> ij> drop table a;
> IJ ERROR: Unable to establish connection
> ij> create table b (si smallint,i int, bi bigint, r real, f float, d
> double precision, n5_2 numeric(5,2), dec10_3 decimal(10,3), ch20 char(20),vc
> varchar(20), lvc long varchar, blobCol blob(1000), clobCol clob(1000));
> IJ ERROR: Unable to establish connection
> ij> insert into b values(2,3,4,5.3,5.3,5.3,31.13,123456.123,
> 'one','one','one',cast(X'01ABCD' as blob(1000)),'one');
> IJ ERROR: Unable to establish connection
> ij> insert into b values(-32768,-2147483648, -9223372036854775808 ,1.2E-37,
> 2.225E-307, +2.225E-307,-56.12, -123456.123,'one','one','one',
> cast(X'01ABCD' as blob(1000)),'one');
> IJ ERROR: Unable to establish connection
> ij> insert into b
> values(null,null,null,null,null,null,null,null,null,null,null,null,null);
> IJ ERROR: Unable to establish connection
> ij> insert into b values(32767,2147483647, 9223372036854775807 ,1.4 ,
> 3.4028235E38 ,3.4028235E38 ,999.99, 9999999.999,'one','one','one',cast(X'01ABCD'
> as blob(1000)), 'one');
> IJ ERROR: Unable to establish connection
> ij> select * from b;
> IJ ERROR: Unable to establish connection
> ij> drop table b;
> IJ ERROR: Unable to establish connection
> ij> create table c (si smallint not null,i int not null , bi bigint not
> null, r real not null, f float not null, d double precision not null, n5_2
> numeric(5,2) not null , dec10_3 decimal(10,3) not null, ch20 char(20) not
> null ,vc varchar(20) not null, lvc long varchar not null, blobCol blob(1000)
> not null, clobCol clob(1000) not null);
> IJ ERROR: Unable to establish connection
> ij> insert into c values(2,3,4,5.3,5.3,5.3,31.13,123456.123,
> 'one','one','one', cast(X'01ABCD' as blob(1000)), 'one');
> IJ ERROR: Unable to establish connection
> ij> insert into c values(-32768,-2147483648, -9223372036854775808 ,1.2E-37,
> 2.225E-307, +2.225E-307,-56.12, -123456.123,'one','one','one',
> cast(X'01ABCD' as blob(1000)),'one');
> IJ ERROR: Unable to establish connection
> ij> select * from c;
> IJ ERROR: Unable to establish connection
> ij> values(10);
> IJ ERROR: Unable to establish connection
> ij> values('hello');
> IJ ERROR: Unable to establish connection
> ij> values(1.2);
> IJ ERROR: Unable to establish connection
> ij> drop table c;
> IJ ERROR: Unable to establish connection
> ij> -- bug 4430 aliasinfo nullability problem
> select aliasinfo from sys.sysaliases where aliasinfo is null;
> IJ ERROR: Unable to establish connection
> ij> -- test commit and rollback
> autocommit off;
> IJ ERROR: Unable to establish connection
> ij> create table a(a int);
> IJ ERROR: Unable to establish connection
> ij> insert into a values (1);
> IJ ERROR: Unable to establish connection
> ij> select * from a;
> IJ ERROR: Unable to establish connection
> ij> commit;
> IJ ERROR: Unable to establish connection
> ij> drop table a;
> IJ ERROR: Unable to establish connection
> ij> rollback;
> IJ ERROR: Unable to establish connection
> ij> select * from a;
> IJ ERROR: Unable to establish connection
> ij> drop table a;
> IJ ERROR: Unable to establish connection
> ij> commit;
> IJ ERROR: Unable to establish connection
> ij> autocommit on;
> IJ ERROR: Unable to establish connection
> ij> maximumdisplaywidth 5000;
> ij> --test 84 columns
> values(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, 78, 79, 80,
> 81, 82, 83, 84);
> IJ ERROR: Unable to establish connection
> ij> values(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, 78, 79, 80,
> 81, 82, 83, 84, 85, 86, 87, 88, 89, 90,
> 91, 92, 93, 94, 95, 96, 97, 98, 99, 100);
> IJ ERROR: Unable to establish connection
> ij> -- test SQL Error with non-string arguments
> ----- Make sure connection still ok (Bug 4657)
> create table a (a int);
> IJ ERROR: Unable to establish connection
> ij> insert into a values(2342323423) ;
> IJ ERROR: Unable to establish connection
> ij> insert into a values(1);
> IJ ERROR: Unable to establish connection
> ij> select * from a;
> IJ ERROR: Unable to establish connection
> ij> drop table a;
> IJ ERROR: Unable to establish connection
> ij> -- Bug 4694 Test automatic rollback with close of connection
> ----- in ij
> autocommit off;
> IJ ERROR: Unable to establish connection
> ij> create table a (a int);
> IJ ERROR: Unable to establish connection
> ij> -- Bug 4758 - Store error does not return properly to client
> autocommit off;
> IJ ERROR: Unable to establish connection
> ij> create table t (i int);
> IJ ERROR: Unable to establish connection
> ij> insert into t values(1);
> IJ ERROR: Unable to establish connection
> ij> commit;
> IJ ERROR: Unable to establish connection
> ij> insert into t values(2);
> IJ ERROR: Unable to establish connection
> ij> connect 'wombat';
> ERROR 08001: No suitable driver
> ij> -- by default, holdability of ResultSet objects created using this
> Connection object is true. Following will set it to false for this
> connection.
> NoHoldForConnection;
> IJ ERROR: Unable to establish connection
> ij> prepare s1 as 'select * from t';
> IJ ERROR: Unable to establish connection
> ij> execute s1;
> IJ ERROR: Unable to establish connection
> ij> execute s1;
> IJ ERROR: Unable to establish connection
> ij> -- Bug 5967 - Selecting from 2 lob columns w/ the first one having
> data of length 0
> create table t1 (c1 clob(10), c2 clob(10));
> IJ ERROR: Unable to establish connection
> ij> insert into t1 values ('', 'some clob');
> IJ ERROR: Unable to establish connection
> ij> select * from t1;
> IJ ERROR: Unable to establish connection
> ij> select c2 from t1;
> IJ ERROR: Unable to establish connection
> ij> insert into t1 values ('', '');
> IJ ERROR: Unable to establish connection
> ij> insert into t1 values ('some clob', '');
> IJ ERROR: Unable to establish connection
> ij> select * from t1;
> IJ ERROR: Unable to establish connection
> ij> select c2 from t1;
> IJ ERROR: Unable to establish connection
> ij> drop table t1;
> IJ ERROR: Unable to establish connection
> ij>
>
>
> #Derby Properties
> #Tue Nov 01 10:17:00 PST 2005
> derby.locks.deadlockTimeout=3
> derby.locks.waitTimeout=3
>
>
> #Test Properties
> #Tue Nov 01 10:17:00 PST 2005
> ij.showNoConnectionsAtStart=true
> ij.dataSource.createDatabase=create
>
> ij.defaultResourcePackage=/org/apache/derbyTesting/functionTests/tests/lang/
> ij.driver=com.ibm.db2.jcc.DB2Driver
> usedefaults=true
> runwithfoundation=false
> ij.user=APP
> ij.showNoCountForSelect=true
> ij.dataSource.databaseName=wombat
> ij.password=APP
> ij.database=jdbc\:derby\:net\://localhost\:1527/wombat;create\=true
> ij.retrieveMessagesFromServerOnGetMessage=true
> ij.protocol=jdbc\:derby\:net\://localhost\:1527/
>
>
> Server is ready to accept connections on port 1527.
> Shutdown successful.
>
>
>

Mime
View raw message