Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 76404 invoked from network); 13 Jan 2006 19:23:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 13 Jan 2006 19:23:18 -0000 Received: (qmail 55239 invoked by uid 500); 13 Jan 2006 19:23:16 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 55198 invoked by uid 500); 13 Jan 2006 19:23:16 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 55185 invoked by uid 99); 13 Jan 2006 19:23:16 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jan 2006 11:23:16 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of ramandhindsa@gmail.com designates 64.233.184.201 as permitted sender) Received: from [64.233.184.201] (HELO wproxy.gmail.com) (64.233.184.201) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jan 2006 11:23:11 -0800 Received: by wproxy.gmail.com with SMTP id i24so695615wra for ; Fri, 13 Jan 2006 11:22:51 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=WyzmI+lMxxB4uHIVkj1y6Hq/Ft9UFCCA+e/puv5r576idJ1c30EIsYU7++LZVf/viOftMysWOWMY6Do4/IR6HhmmNZtIeK7LHqFu75PE705/E9vE41nkwpe3701oM7FsoeZ+4yb7yc63doaWAEbkz77QD3JtHbeTRpz5I9ltx4k= Received: by 10.65.177.10 with SMTP id e10mr2065032qbp; Fri, 13 Jan 2006 11:22:50 -0800 (PST) Received: by 10.65.116.9 with HTTP; Fri, 13 Jan 2006 11:22:50 -0800 (PST) Message-ID: <836ae9af0601131122j3d525aeci88154af3d7a01560@mail.gmail.com> Date: Fri, 13 Jan 2006 11:22:50 -0800 From: Ramandeep Kaur To: derby-dev@db.apache.org Subject: Server and client compatibility test for 10.2 and 10.1 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_25165_19401027.1137180170825" X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_25165_19401027.1137180170825 Content-Type: multipart/alternative; boundary="----=_Part_25166_24650449.1137180170825" ------=_Part_25166_24650449.1137180170825 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi, I ran suite derbynetclientmats to test Server and Client compatibility for the following combinations:- Server: 10.2 (svn 368249), Client: 10.1 (svn 368246), derbyTesting.jar: 10.1(svn 368246) Server: 10.1 (svn 368246), Client: 10.2 (svn 367899), derbyTesting.jar: 10.1 (svn 368246) Server: 10.2, Client: 10.1, derbyTesting.jar: 10.1 --------------------------------------------------------------------- jvms: jdk15, ibm142 Test failures: derbynetclientmats/derbynetmats/derbynetmats.fail:derbynet/NSinSameJVM.java derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/autoGeneratedJdbc= 30.java derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/dbMetaDataJdbc30.= java derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/metadata.java derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/odbc_metadata.jav= a derbynetclientmats/derbynetmats/derbynetmats.fail:lang/procedure.java derbynetclientmats/derbynetmats/derbynetmats.fail:lang/updatableResultSet.j= ava derbynetclientmats/derbynetmats/derbynetmats.fail:lang/syscat.sql Server: 10.1, Client: 10.2, derbyTesting.jar: 10.1 --------------------------------------------------------------------- jvms: jdk15, ibm142 Test failures: derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/dbMetaDataJdbc30.= java derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/metadata.java derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/odbc_metadata.jav= a derbynetclientmats/derbynetmats/derbynetmats.fail:lang/forupdate.sql derbynetclientmats/derbynetmats/derbynetmats.fail:lang/updatableResultSet.j= ava derbynetclientmats/derbynetmats/derbynetmats.fail:store/holdCursorJDBC30.sq= l derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/LOBTest.java derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/metadataJdbc20.ja= va derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/connectionJdbc20.= java After looking at the failures, I have found that failures could be due to: - Error message changes from one version to another. Hence creating diff. - Messages with version number which is different. hence creating diff. - Changes due to bug fixes. I will look into the failures more. I am attaching the report files for results ran with jdk15 only. If you get a chance, please look at the failures and provide me your feedback. Thanks, Ramandeep Kaur (ramandhindsa@gmail.com) ------=_Part_25166_24650449.1137180170825 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Hi,
 
I ran suite derbynetclientmats to test Server and Client compatibility=  for the following combinations:-
 
Server: 10.2 (svn 368249), Client: 10.1 (svn 368246), derbyTesting.jar= : 10.1 (svn 368246)
Server: 10.1 (svn 368246), Client: 10.2 (svn 367899), derbyTesting.jar= : 10.1 (svn 368246)
 
 
Server: 10.2, Client: 10.1, derbyTesting.jar: 10.1
---------------------------------------------------------------------<= /div>
jvms: jdk15, ibm142
 
Test failures:
derbynetclientmats/derbynetmats/derbynetmats.fail:derbynet/NSinSameJVM= .java
derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/autoGene= ratedJdbc30.java
derbynetclientmats/derbynetmats/derbynetmats.fail:jdbca= pi/dbMetaDataJdbc30.java
derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/metadata.java=
derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/odbc_metadata= .java
derbynetclientmats/derbynetmats/derbynetmats.fail:lang/procedure.j= ava
derbynetclientmats/derbynetmats/derbynetmats.fail:lang/updatableResultS= et.java
derbynetclientmats/derbynetmats/derbynetmats.fail:lang/syscat.sq= l
 
Server: 10.1, Client: 10.2, derbyTesting.jar: 10.1
---------------------------------------------------------------------<= /div>
jvms: jdk15, ibm142
 
Test failures:
derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/dbMetaDataJd= bc30.java
derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/meta= data.java
derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/odbc= _metadata.java
derbynetclientmats/derbynetmats/derbynetmats.fail:lang/forupdate.sqlderbynetclientmats/derbynetmats/derbynetmats.fail:lang/updatableResultSet.= java
derbynetclientmats/derbynetmats/derbynetmats.fail:store/holdCursorJ= DBC30.sql
derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/LOBTest.java<= br>derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/metadataJdbc20= .java
derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/connecti= onJdbc20.java
 
After looking at the failures, I have found that failures&nb= sp;could be due to:
- Error message changes from one versio= n to another. Hence creating diff.
- Messages with version number which is= different. hence creating diff.
- Changes due to bug fixes.
 
I will look into the failures more. I a= m attaching the report files for results ran with jdk15 only. If you get a = chance, please look at the failures and provide me your feedback.
 
Thanks,
Ramandeep Kaur (ramandhindsa@gmail.com)
 
 
 
------=_Part_25166_24650449.1137180170825-- ------=_Part_25165_19401027.1137180170825 Content-Type: text/plain; name=server10.1_client10.2_derbynetclientmats_report.txt; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="server10.1_client10.2_derbynetclientmats_report.txt" --------- Derby Information -------- JRE - JDBC: J2SE 5.0 - JDBC 3.0 [D:\jartest\classes\derby.jar] 10.1.2.2 - (368246) [D:\jartest\classes\derbytools.jar] 10.1.2.2 - (368246) [D:\jartest\classes\derbynet.jar] 10.1.2.2 - (368246) [D:\jartest\classes\v10_2_client\derbyclient.jar] 10.2.0.0 alpha - (367899) ------------------------------------------------------ ----------------- Locale Information ----------------- Current Locale : [English/United States [en_US]] Found support for locale: [de_DE] version: 10.1.2.2 - (368246) Found support for locale: [es] version: 10.1.2.2 - (368246) Found support for locale: [fr] version: 10.1.2.2 - (368246) Found support for locale: [it] version: 10.1.2.2 - (368246) Found support for locale: [ja_JP] version: 10.1.2.2 - (368246) Found support for locale: [ko_KR] version: 10.1.2.2 - (368246) Found support for locale: [pt_BR] version: 10.1.2.2 - (368246) Found support for locale: [zh_CN] version: 10.1.2.2 - (368246) Found support for locale: [zh_TW] version: 10.1.2.2 - (368246) ------------------------------------------------------ Framework: DerbyNetClient Test environment information: COMMAND LINE STYLE: jdk13 TEST CANONS: master ------------------------------------------------------ ------------------------------------------------------ Summary results: Test Run Started: 2006-01-11 23:53:36.0 Test Run Duration: 00:32:54 71 Tests Run 88% Pass (62 tests passed) 12% Fail (9 tests failed) 0 Suites skipped ------------------------------------------------------ Failed tests in: derbynetclientmats_fail.txt ------------------------------------------------------ Passed tests in: derbynetclientmats_pass.txt ------------------------------------------------------ System properties in: derbynetclientmats_prop.txt ------------------------------------------------------ ------------------------------------------------------ Failure Details: ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/dbMetaDataJdbc30.diff *** Start: dbMetaDataJdbc30 jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 00:00:30 *** 2 del < JDBC Driver 'Apache Derby Network Client JDBC Driver', version 10.1 (10.1.2.2) 2a2 > JDBC Driver 'Apache Derby Network Client JDBC Driver', version 10.2 (10.2.0.0 alpha) Test Failed. *** End: dbMetaDataJdbc30 jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 00:00:43 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/forupdate.diff *** Start: forupdate jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 00:03:08 *** 23 del < ERROR 42X01: Syntax error: Encountered "" at line 1, column 23. 23a23 > ERROR 42X01: Syntax error: Encountered "" at line 3, column 23. 59,64d58 < ERROR (no SQLState): Invalid cursor name "C1" in the Update/Delete statement. < ij> close c1; < ij> -- . read only for read only cursor spec < ----- we know because the delete is refused with a 'cursor not updatable' message < get cursor c2 as 'select i, v from t1, t2 for read only'; < ij> delete from t1 where current of c2; 65a60,65 > ij> close c1; > ij> -- . read only for read only cursor spec > ----- we know because the delete is refused with a 'cursor not updatable' message > get cursor c2 as 'select i, v from t1, t2 for read only'; > ij> delete from t1 where current of c2; > ERROR 42X23: Cursor SQL_CURLH000C1 is not updatable. 132 del < ERROR (no SQLState): Invalid cursor name "C4" in the Update/Delete statement. 132a132 > ERROR 42X28: Delete table 'S1' is not target of cursor 'SQL_CURLH000C1'. 135 del < ERROR (no SQLState): Invalid cursor name "C4" in the Update/Delete statement. 135a135 > ERROR XCL08: Cursor 'SQL_CURLH000C1' is not on a row. 180 del < ERROR 42X01: Syntax error: Encountered "." at line 1, column 34. 180a180 > ERROR 42X01: Syntax error: Encountered "." at line 3, column 34. Test Failed. *** End: forupdate jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 00:03:24 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/holdCursorJDBC30.diff *** Start: holdCursorJDBC30 jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 00:07:02 *** 61,67d60 < ERROR (no SQLState): Invalid operation: result set closed < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as 'select * from foo for update'; < ij> next test1; 68a62,68 > ij> close test1; > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as 'select * from foo for update'; > ij> next test1; > No current row 71,78d70 < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as 'select * from foo for update'; < ij> next test1; 80a73,77 > ij> close test1; > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as 'select * from foo for update'; 82,96d78 < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as 'select * from foo for update'; < ij> next test1; 100,116d81 < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as 'select * from foo for update'; < ij> next test1; 120 del < ERROR (no SQLState): Invalid operation: result set closed 120a85,89 > No current row > ij> next test1; > No current row > ij> next test1; > No current row 121a91,95 > ij> close test1; > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as 'select * from foo for update'; 123 del < ERROR (no SQLState): Invalid operation: result set closed 123a97,98 > No current row > ij> commit; 125 del < ERROR (no SQLState): Invalid operation: result set closed 125a100,101 > No current row > ij> commit; 127 del < ERROR (no SQLState): Invalid operation: result set closed 127a103 > No current row 129 del < ERROR (no SQLState): Invalid operation: result set closed 129a105,110 > No current row > ij> next test1; > No current row > ij> next test1; > No current row > ij> commit; 130a112,117 > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as 'select * from foo for update'; > ij> next test1; > No current row 131a119,131 > ij> next test1; > No current row > ij> commit; > ij> next test1; > No current row > ij> next test1; > No current row > ij> next test1; > No current row > ij> next test1; > No current row > ij> close test1; > ij> commit; 340,347d339 < ERROR (no SQLState): Invalid operation: result set closed < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as < 'select * from foo for update of data'; < ij> next test1; 348a341,348 > ij> close test1; > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as > 'select * from foo for update of data'; > ij> next test1; > No current row 351,359d350 < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as < 'select * from foo for update of data'; < ij> next test1; 361a353,358 > ij> close test1; > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as > 'select * from foo for update of data'; 363,378d359 < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as < 'select * from foo for update of data'; < ij> next test1; 382,399d362 < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as < 'select * from foo for update of data'; < ij> next test1; 403 del < ERROR (no SQLState): Invalid operation: result set closed 403a366,370 > No current row > ij> next test1; > No current row > ij> next test1; > No current row 404a372,377 > ij> close test1; > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as > 'select * from foo for update of data'; 406 del < ERROR (no SQLState): Invalid operation: result set closed 406a379,380 > No current row > ij> commit; 408 del < ERROR (no SQLState): Invalid operation: result set closed 408a382,383 > No current row > ij> commit; 410 del < ERROR (no SQLState): Invalid operation: result set closed 410a385 > No current row 412 del < ERROR (no SQLState): Invalid operation: result set closed 412a387,392 > No current row > ij> next test1; > No current row > ij> next test1; > No current row > ij> commit; 413a394,400 > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as > 'select * from foo for update of data'; > ij> next test1; > No current row 414a402,414 > ij> next test1; > No current row > ij> commit; > ij> next test1; > No current row > ij> next test1; > No current row > ij> next test1; > No current row > ij> next test1; > No current row > ij> close test1; > ij> commit; 681 del < ERROR (no SQLState): Invalid operation: result set closed 681a681 > No current row 735,742d734 < ERROR (no SQLState): Invalid operation: result set closed < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as < 'select * from foo '; < ij> next test1; 743a736,743 > ij> close test1; > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as > 'select * from foo '; > ij> next test1; > No current row 746,754d745 < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as < 'select * from foo '; < ij> next test1; 756a748,753 > ij> close test1; > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as > 'select * from foo '; 758,773d754 < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as < 'select * from foo '; < ij> next test1; 777,794d757 < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as < 'select * from foo '; < ij> next test1; 798 del < ERROR (no SQLState): Invalid operation: result set closed 798a761,765 > No current row > ij> next test1; > No current row > ij> next test1; > No current row 799a767,772 > ij> close test1; > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as > 'select * from foo '; 801 del < ERROR (no SQLState): Invalid operation: result set closed 801a774,775 > No current row > ij> commit; 803 del < ERROR (no SQLState): Invalid operation: result set closed 803a777,778 > No current row > ij> commit; 805 del < ERROR (no SQLState): Invalid operation: result set closed 805a780 > No current row 807 del < ERROR (no SQLState): Invalid operation: result set closed 807a782,787 > No current row > ij> next test1; > No current row > ij> next test1; > No current row > ij> commit; 808a789,795 > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as > 'select * from foo '; > ij> next test1; > No current row 809a797,809 > ij> next test1; > No current row > ij> commit; > ij> next test1; > No current row > ij> next test1; > No current row > ij> next test1; > No current row > ij> next test1; > No current row > ij> close test1; > ij> commit; 1029,1036d1028 < ERROR (no SQLState): Invalid operation: result set closed < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as < 'select a,data from foo order by data desc'; < ij> next test1; 1037a1030,1037 > ij> close test1; > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as > 'select a,data from foo order by data desc'; > ij> next test1; > No current row 1040,1048d1039 < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as < 'select a,data from foo order by data desc'; < ij> next test1; 1050a1042,1047 > ij> close test1; > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as > 'select a,data from foo order by data desc'; 1052,1067d1048 < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as < 'select a,data from foo order by data desc'; < ij> next test1; 1071,1088d1051 < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> next test1; < ERROR (no SQLState): Invalid operation: result set closed < ij> commit; < ij> close test1; < ij> -- should fail < next test1; < IJ ERROR: Unable to establish cursor < ij> get with hold cursor test1 as < 'select a,data from foo order by data desc'; < ij> next test1; 1092 del < ERROR (no SQLState): Invalid operation: result set closed 1092a1055,1059 > No current row > ij> next test1; > No current row > ij> next test1; > No current row 1093a1061,1066 > ij> close test1; > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as > 'select a,data from foo order by data desc'; 1095 del < ERROR (no SQLState): Invalid operation: result set closed 1095a1068,1069 > No current row > ij> commit; 1097 del < ERROR (no SQLState): Invalid operation: result set closed 1097a1071,1072 > No current row > ij> commit; 1099 del < ERROR (no SQLState): Invalid operation: result set closed 1099a1074 > No current row 1101 del < ERROR (no SQLState): Invalid operation: result set closed 1101a1076,1081 > No current row > ij> next test1; > No current row > ij> next test1; > No current row > ij> commit; 1102a1083,1089 > ij> -- should fail > next test1; > IJ ERROR: Unable to establish cursor > ij> get with hold cursor test1 as > 'select a,data from foo order by data desc'; > ij> next test1; > No current row 1103a1091,1103 > ij> next test1; > No current row > ij> commit; > ij> next test1; > No current row > ij> next test1; > No current row > ij> next test1; > No current row > ij> next test1; > No current row > ij> close test1; > ij> commit; Test Failed. *** End: holdCursorJDBC30 jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 00:07:20 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/metadata.diff *** Start: metadata jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 00:00:43 *** 12 del < JDBC Driver 'Apache Derby Network Client JDBC Driver', version 10.1 (10.1.2.2) 12a12 > JDBC Driver 'Apache Derby Network Client JDBC Driver', version 10.2 (10.2.0.0 alpha) 52 del < getDriverVersion(): 10.1.2.2 52a52 > getDriverVersion(): 10.2.0.0 alpha Test Failed. *** End: metadata jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 00:01:06 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/odbc_metadata.diff *** Start: odbc_metadata jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 00:01:21 *** 42 del < JDBC Driver 'Apache Derby Network Client JDBC Driver', version 10.1 (10.1.2.2) 42a42 > JDBC Driver 'Apache Derby Network Client JDBC Driver', version 10.2 (10.2.0.0 alpha) 82 del < getDriverVersion(): 10.1.2.2 82a82 > getDriverVersion(): 10.2.0.0 alpha Test Failed. *** End: odbc_metadata jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 00:01:44 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/updatableResultSet.diff *** Start: updatableResultSet jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 00:04:51 *** 72a73,75 > SQL State : XCL08 > Got expected exception Cursor '' is not on a row. > ResultSet is positioned after the last row. attempt to updateRow at this point should fail! 73a77,80 > Got expected exception Invalid operation to update at current cursor position > Negative Test8 - attempt deleteRow & updateRow on updatable resultset after closing the resultset > Make sure that we got CONCUR_UPDATABLE? true > SQL State : null 75d81 < ResultSet is positioned after the last row. attempt to updateRow at this point should fail! 78,83d83 < Negative Test8 - attempt deleteRow & updateRow on updatable resultset after closing the resultset < Make sure that we got CONCUR_UPDATABLE? true < SQL State : null < Got expected exception Invalid operation: result set closed < SQL State : null < Got expected exception Invalid operation: result set closed 132 del < SQL State : 24000 133 del < Got expected exception Invalid cursor state - no current row. 133a132,133 > SQL State : XCL08 > Got expected exception Cursor '' is not on a row. 172 del < SQL State : 24000 173 del < Got expected exception Invalid cursor state - no current row. 173a172,173 > SQL State : XCL08 > Got expected exception Cursor '' is not on a row. 203 del < SQL State : 24000 204 del < Got expected exception Invalid cursor state - no current row. 204a203,204 > SQL State : XCL08 > Got expected exception Cursor '' is not on a row. 376a377,392 > SQL State : XCL08 > Got expected exception Cursor '' is not on a row. > Verify that delete trigger got fired by verifying the row count to be 0 in table1WithTriggers > 1 > - > {0} > Positive Test13b - Another test case for update trigger > Look at the current contents of table2WithTriggers > C1,C2 > -- -- > {1,1} > {2,2} > {3,3} > {4,4} > column 1 on this row is 2 > this update row will fire the update trigger which will update all the rows in the table to have c1=1 and hence no more rows will qualify for the resultset 378 del < Got expected exception Invalid operation: result set closed 379 del < Verify that delete trigger got fired by verifying the row count to be 0 in table1WithTriggers 380 del < 1 381 del < - 382 del < {0} 383 del < Positive Test13b - Another test case for update trigger 384 del < Look at the current contents of table2WithTriggers 384a394,395 > Got expected exception Invalid operation to update at current cursor position > Verify that update trigger got fired by verifying that all column c1s have value 1 in table2WithTriggers 388,398d398 < {2,2} < {3,3} < {4,4} < column 1 on this row is 2 < this update row will fire the update trigger which will update all the rows in the table to have c1=1 and hence no more rows will qualify for the resultset < SQL State : null < Got expected exception Invalid operation: result set closed < Verify that update trigger got fired by verifying that all column c1s have value 1 in table2WithTriggers < C1,C2 < -- -- < {1,1} 411 del < SQL State : null 412 del < Got expected exception Invalid operation: result set closed 412a411,412 > SQL State : XCL08 > Got expected exception Cursor '' is not on a row. Test Failed. *** End: updatableResultSet jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 00:05:24 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/jdbc20/batchUpdate.diff *** Start: batchUpdate jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 00:15:05 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbcapi/batchUpdate.java *** End: batchUpdate jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 00:15:05 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/jdbc20/connectionJdbc20.diff *** Start: connectionJdbc20 jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 00:15:32 *** 21 del < x43x31x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 22 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 23 del < x58x58x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 24 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 25 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 26 del < getBytes(1) 27 del < x43x31x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 28 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 29 del < x58x58x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 30 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 31 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 32 del < getObject(2) 33 del < as byte[] length 43 34 del < x43x32x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 35 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 36 del < x58x58 37 del < getString(2) length 86 38 del < 43325858585858585858585858585858585858585858585858585858585858585858585858585858585858 39 del < getAsciiStream(2) 40 del < x43x32x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 41 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 42 del < x58x58 43 del < getBinaryStream(2) 44 del < x43x32x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 45 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 46 del < x58x58 47 del < getBytes(2) 48 del < x43x32x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 49 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 50 del < x58x58 51 del < getObject(3) 52 del < as byte[] length 43 53 del < x43x33x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 54 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 55 del < x58x58 56 del < getString(3) length 86 57 del < 43335858585858585858585858585858585858585858585858585858585858585858585858585858585858 58 del < getAsciiStream(3) 59 del < x43x33x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 60 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 61 del < x58x58 62 del < getBinaryStream(3) 63 del < x43x33x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 64 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 65 del < x58x58 66 del < getBytes(3) 67 del < x43x33x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 68 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 69 del < x58x58 70 del < getObject(4) 71 del < as String 72 del < C4XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 73 del < getString(4) length 100 74 del < C4XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 75 del < getAsciiStream(4) 76 del < x43x34x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 77 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 78 del < x58x58x58x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 79 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 80 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 81 del < getObject(5) 82 del < as String 83 del < C5XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 84 del < getString(5) length 45 85 del < C5XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 86 del < getAsciiStream(5) 87 del < x43x35x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 88 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 89 del < x58x58x58x58 90 del < getObject(6) 91 del < as String 92 del < C6XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 93 del < getString(6) length 46 94 del < C6XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 95 del < getAsciiStream(6) 96 del < x43x36x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 97 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 98 del < x58x58x58x58x58 99 del < Got Same Statement Object 100 del < getObject(1) 101 del < as byte[] length 100 102 del < x43x31x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 103 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 104 del < x58x58x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 105 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 106 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 107 del < getString(1) length 200 108 del < 43315858585858585858585858585858585858585858585858585858585858585858585858585858585858202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020 109 del < getAsciiStream(1) 110 del < x43x31x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 111 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 112 del < x58x58x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 113 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 114 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 115 del < getBinaryStream(1) 116 del < x43x31x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 117 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 118 del < x58x58x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 119 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 120 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 121 del < getBytes(1) 122 del < x43x31x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 123 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 124 del < x58x58x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 125 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 126 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 127 del < getObject(2) 128 del < as byte[] length 43 129 del < x43x32x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 130 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 131 del < x58x58 132 del < getString(2) length 86 133 del < 43325858585858585858585858585858585858585858585858585858585858585858585858585858585858 134 del < getAsciiStream(2) 135 del < x43x32x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 136 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 137 del < x58x58 138 del < getBinaryStream(2) 139 del < x43x32x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 140 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 141 del < x58x58 142 del < getBytes(2) 143 del < x43x32x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 144 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 145 del < x58x58 146 del < getObject(3) 147 del < as byte[] length 43 148 del < x43x33x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 149 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 150 del < x58x58 151 del < getString(3) length 86 152 del < 43335858585858585858585858585858585858585858585858585858585858585858585858585858585858 153 del < getAsciiStream(3) 154 del < x43x33x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 155 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 156 del < x58x58 157 del < getBinaryStream(3) 158 del < x43x33x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 159 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 160 del < x58x58 161 del < getBytes(3) 162 del < x43x33x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 163 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 164 del < x58x58 165 del < getObject(4) 166 del < as String 167 del < C4XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 168 del < getString(4) length 100 169 del < C4XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 170 del < getAsciiStream(4) 171 del < x43x34x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 172 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 173 del < x58x58x58x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 174 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 175 del < x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20 176 del < getObject(5) 177 del < as String 178 del < C5XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 179 del < getString(5) length 45 180 del < C5XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 181 del < getAsciiStream(5) 182 del < x43x35x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 183 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 184 del < x58x58x58x58 185 del < getObject(6) 186 del < as String 187 del < C6XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 188 del < getString(6) length 46 189 del < C6XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 190 del < getAsciiStream(6) 191 del < x43x36x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 192 del < x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58 193 del < x58x58x58x58x58 194 del < Got Same Statement Object 195 del < BIGINT 196 del < LONG VARCHAR FOR BIT DATA 197 del < VARCHAR () FOR BIT DATA 198 del < CHAR () FOR BIT DATA 199 del < LONG VARCHAR 200 del < LONG NVARCHAR 201 del < CHAR 202 del < NATIONAL CHAR 203 del < NUMERIC 204 del < DECIMAL 205 del < INTEGER 206 del < SMALLINT 207 del < FLOAT 208 del < REAL 209 del < DOUBLE 210 del < VARCHAR 211 del < NATIONAL CHAR VARYING 212 del < DATE 213 del < TIME 214 del < TIMESTAMP 215 del < BLOB 216 del < CLOB 217 del < Try to Get the connection back from metadata 218 del < Got Same Connection Object 219 del < Try to get the connection back from a callable stmt 220 del < Got Same Connection Object 220a21,23 > FAIL -- unexpected exception > SQLSTATE(null): org.apache.derby.client.am.SqlException: Stream of column value in result cannot be retrieved twice > org.apache.derby.client.am.SqlException: Stream of column value in result cannot be retrieved twice Test Failed. *** End: connectionJdbc20 jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 00:15:45 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/jdbc20/metadataJdbc20.diff *** Start: metadataJdbc20 jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 00:15:05 *** 2 del < JDBC Driver 'Apache Derby Network Client JDBC Driver', version 10.1 (10.1.2.2) 2a2 > JDBC Driver 'Apache Derby Network Client JDBC Driver', version 10.2 (10.2.0.0 alpha) Test Failed. *** End: metadataJdbc20 jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 00:15:18 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/jdbc20/scrollCursors2.diff *** Start: scrollCursors2 jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 00:14:50 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: lang/scrollCursors2.java *** End: scrollCursors2 jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 00:14:50 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/jdbc20/statementJdbc20.diff *** Start: statementJdbc20 jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 00:15:32 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbcapi/statementJdbc20.java *** End: statementJdbc20 jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 00:15:32 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/jdbcapi/LOBTest.diff *** Start: LOBTest jdk1.5.0_02 DerbyNetClient derbynetmats:jdbcapi 2006-01-12 00:11:43 *** 18 del < 0 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 18a18 > 0 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 23 del < 0 getCharacterStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 23a23 > 0 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 41 del < 1 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 41a41 > 1 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 46 del < 1 getCharacterStream ->Object' : java.io.Reader 46a46 > 1 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 64 del < 2 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 64a64 > 2 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 69 del < 2 getCharacterStream ->Object' : java.io.Reader 69a69 > 2 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 87 del < 3 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 87a87 > 3 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 92 del < 3 getCharacterStream ->Object' : java.io.Reader 92a92 > 3 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 110 del < 4 getBinaryStream ->Object' : java.io.InputStream 110a110 > 4 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 115 del < 4 getCharacterStream ->Object' : java.io.Reader 115a115 > 4 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 133 del < 5 getBinaryStream ->Object' : java.io.InputStream 133a133 > 5 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 138 del < 5 getCharacterStream ->Object' : java.io.Reader 138a138 > 5 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 156 del < 6 getBinaryStream ->Object' : java.io.InputStream 156a156 > 6 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 161 del < 6 getCharacterStream ->Object' : java.io.Reader 161a161 > 6 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 179 del < 7 getBinaryStream ->Object' : java.io.InputStream 179a179 > 7 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 184 del < 7 getCharacterStream ->Object' : java.io.Reader 184a184 > 7 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 580 del < 0 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 580a580 > 0 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 585 del < 0 getCharacterStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 585a585 > 0 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 603 del < 1 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 603a603 > 1 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 608 del < 1 getCharacterStream ->Object' : java.io.Reader 608a608 > 1 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 626 del < 2 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 626a626 > 2 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 631 del < 2 getCharacterStream ->Object' : java.io.Reader 631a631 > 2 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 649 del < 3 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 649a649 > 3 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 654 del < 3 getCharacterStream ->Object' : java.io.Reader 654a654 > 3 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 672 del < 4 getBinaryStream ->Object' : java.io.InputStream 672a672 > 4 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 677 del < 4 getCharacterStream ->Object' : java.io.Reader 677a677 > 4 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 695 del < 5 getBinaryStream ->Object' : java.io.InputStream 695a695 > 5 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 700 del < 5 getCharacterStream ->Object' : java.io.Reader 700a700 > 5 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 718 del < 6 getBinaryStream ->Object' : java.io.InputStream 718a718 > 6 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 723 del < 6 getCharacterStream ->Object' : java.io.Reader 723a723 > 6 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 741 del < 7 getBinaryStream ->Object' : java.io.InputStream 741a741 > 7 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 746 del < 7 getCharacterStream ->Object' : java.io.Reader 746a746 > 7 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1142 del < 0 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 1142a1142 > 0 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1147 del < 0 getCharacterStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 1147a1147 > 0 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1165 del < 1 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 1165a1165 > 1 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1170 del < 1 getCharacterStream ->Object' : java.io.Reader 1170a1170 > 1 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1188 del < 2 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 1188a1188 > 2 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1193 del < 2 getCharacterStream ->Object' : java.io.Reader 1193a1193 > 2 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1211 del < 3 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 1211a1211 > 3 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1216 del < 3 getCharacterStream ->Object' : java.io.Reader 1216a1216 > 3 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1234 del < 4 getBinaryStream ->Object' : java.io.InputStream 1234a1234 > 4 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1239 del < 4 getCharacterStream ->Object' : java.io.Reader 1239a1239 > 4 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1257 del < 5 getBinaryStream ->Object' : java.io.InputStream 1257a1257 > 5 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1262 del < 5 getCharacterStream ->Object' : java.io.Reader 1262a1262 > 5 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1280 del < 6 getBinaryStream ->Object' : java.io.InputStream 1280a1280 > 6 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1285 del < 6 getCharacterStream ->Object' : java.io.Reader 1285a1285 > 6 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1303 del < 7 getBinaryStream ->Object' : java.io.InputStream 1303a1303 > 7 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1308 del < 7 getCharacterStream ->Object' : java.io.Reader 1308a1308 > 7 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1683 del < 0 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 1683a1683 > 0 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1688 del < 0 getCharacterStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 1688a1688 > 0 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1706 del < 1 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 1706a1706 > 1 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1711 del < 1 getCharacterStream ->Object' : java.io.Reader 1711a1711 > 1 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1729 del < 2 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 1729a1729 > 2 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1734 del < 2 getCharacterStream ->Object' : java.io.Reader 1734a1734 > 2 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1752 del < 3 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 1752a1752 > 3 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1757 del < 3 getCharacterStream ->Object' : java.io.Reader 1757a1757 > 3 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1775 del < 4 getBinaryStream ->Object' : java.io.InputStream 1775a1775 > 4 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1780 del < 4 getCharacterStream ->Object' : java.io.Reader 1780a1780 > 4 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1798 del < 5 getBinaryStream ->Object' : java.io.InputStream 1798a1798 > 5 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1803 del < 5 getCharacterStream ->Object' : java.io.Reader 1803a1803 > 5 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1821 del < 6 getBinaryStream ->Object' : java.io.InputStream 1821a1821 > 6 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1826 del < 6 getCharacterStream ->Object' : java.io.Reader 1826a1826 > 6 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1844 del < 7 getBinaryStream ->Object' : java.io.InputStream 1844a1844 > 7 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 1849 del < 7 getCharacterStream ->Object' : java.io.Reader 1849a1849 > 7 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2224 del < 0 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 2224a2224 > 0 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2229 del < 0 getCharacterStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 2229a2229 > 0 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2247 del < 1 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 2247a2247 > 1 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2252 del < 1 getCharacterStream ->Object' : java.io.Reader 2252a2252 > 1 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2270 del < 2 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 2270a2270 > 2 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2275 del < 2 getCharacterStream ->Object' : java.io.Reader 2275a2275 > 2 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2293 del < 3 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 2293a2293 > 3 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2298 del < 3 getCharacterStream ->Object' : java.io.Reader 2298a2298 > 3 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2316 del < 4 getBinaryStream ->Object' : java.io.InputStream 2316a2316 > 4 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2321 del < 4 getCharacterStream ->Object' : java.io.Reader 2321a2321 > 4 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2339 del < 5 getBinaryStream ->Object' : java.io.InputStream 2339a2339 > 5 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2344 del < 5 getCharacterStream ->Object' : java.io.Reader 2344a2344 > 5 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2362 del < 6 getBinaryStream ->Object' : java.io.InputStream 2362a2362 > 6 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2367 del < 6 getCharacterStream ->Object' : java.io.Reader 2367a2367 > 6 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2385 del < 7 getBinaryStream ->Object' : java.io.InputStream 2385a2385 > 7 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2390 del < 7 getCharacterStream ->Object' : java.io.Reader 2390a2390 > 7 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2767 del < 0 getBinaryStream -> EXCEPTION (null) 2767a2767 > 0 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2772 del < 0 getCharacterStream -> EXCEPTION (null) 2772a2772 > 0 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2790 del < 1 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 2790a2790 > 1 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2795 del < 1 getCharacterStream ->Object' : java.io.Reader 2795a2795 > 1 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2813 del < 2 getBinaryStream -> EXCEPTION (null) 2813a2813 > 2 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2818 del < 2 getCharacterStream -> EXCEPTION (null) 2818a2818 > 2 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2836 del < 3 getBinaryStream -> EXCEPTION (null) 2836a2836 > 3 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2841 del < 3 getCharacterStream -> EXCEPTION (null) 2841a2841 > 3 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2859 del < 4 getBinaryStream -> EXCEPTION (null) 2859a2859 > 4 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2864 del < 4 getCharacterStream -> EXCEPTION (null) 2864a2864 > 4 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2882 del < 5 getBinaryStream -> EXCEPTION (null) 2882a2882 > 5 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2887 del < 5 getCharacterStream -> EXCEPTION (null) 2887a2887 > 5 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2905 del < 6 getBinaryStream -> EXCEPTION (null) 2905a2905 > 6 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2910 del < 6 getCharacterStream -> EXCEPTION (null) 2910a2910 > 6 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2928 del < 7 getBinaryStream -> EXCEPTION (null) 2928a2928 > 7 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 2933 del < 7 getCharacterStream -> EXCEPTION (null) 2933a2933 > 7 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3320 del < 0 getBinaryStream -> EXCEPTION (null) 3320a3320 > 0 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3325 del < 0 getCharacterStream -> EXCEPTION (null) 3325a3325 > 0 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3343 del < 1 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) 3343a3343 > 1 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3348 del < 1 getCharacterStream ->Object' : java.io.Reader 3348a3348 > 1 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3366 del < 2 getBinaryStream -> EXCEPTION (null) 3366a3366 > 2 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3371 del < 2 getCharacterStream -> EXCEPTION (null) 3371a3371 > 2 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3389 del < 3 getBinaryStream -> EXCEPTION (null) 3389a3389 > 3 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3394 del < 3 getCharacterStream -> EXCEPTION (null) 3394a3394 > 3 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3412 del < 4 getBinaryStream -> EXCEPTION (null) 3412a3412 > 4 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3417 del < 4 getCharacterStream -> EXCEPTION (null) 3417a3417 > 4 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3435 del < 5 getBinaryStream -> EXCEPTION (null) 3435a3435 > 5 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3440 del < 5 getCharacterStream -> EXCEPTION (null) 3440a3440 > 5 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3458 del < 6 getBinaryStream -> EXCEPTION (null) 3458a3458 > 6 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3463 del < 6 getCharacterStream -> EXCEPTION (null) 3463a3463 > 6 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3481 del < 7 getBinaryStream -> EXCEPTION (null) 3481a3481 > 7 getBinaryStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) 3486 del < 7 getCharacterStream -> EXCEPTION (null) 3486a3486 > 7 getCharacterStream -> EXCEPTION (Stream of column value in result cannot be retrieved twice) Test Failed. *** End: LOBTest jdk1.5.0_02 DerbyNetClient derbynetmats:jdbcapi 2006-01-12 00:12:01 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/jdbcapi/resultsetStream.diff *** Start: resultsetStream jdk1.5.0_02 DerbyNetClient derbynetmats:jdbcapi 2006-01-12 00:09:41 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbcapi/resultsetStream.java *** End: resultsetStream jdk1.5.0_02 DerbyNetClient derbynetmats:jdbcapi 2006-01-12 00:09:41 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/jdbcapi/testRelative.diff *** Start: testRelative jdk1.5.0_02 DerbyNetClient derbynetmats:jdbcapi 2006-01-12 00:14:21 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbcapi/testRelative.java *** End: testRelative jdk1.5.0_02 DerbyNetClient derbynetmats:jdbcapi 2006-01-12 00:14:21 *** ------------------------------------------------------ ------=_Part_25165_19401027.1137180170825 Content-Type: text/plain; name=server10.2_client10.1_derbynetclientmats_report.txt; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="server10.2_client10.1_derbynetclientmats_report.txt" --------- Derby Information -------- JRE - JDBC: J2SE 5.0 - JDBC 3.0 [E:\jartest\classes\derby.jar] 10.2.0.0 alpha - (368249) [E:\jartest\classes\derbytools.jar] 10.2.0.0 alpha - (368249) [E:\jartest\classes\derbynet.jar] 10.2.0.0 alpha - (368249) [E:\jartest\classes\v10_1_client\derbyclient.jar] 10.1.2.2 - (368246) ------------------------------------------------------ ----------------- Locale Information ----------------- Current Locale : [English/United States [en_US]] Found support for locale: [de_DE] version: 10.2.0.0 alpha - (368249) Found support for locale: [es] version: 10.2.0.0 alpha - (368249) Found support for locale: [fr] version: 10.2.0.0 alpha - (368249) Found support for locale: [it] version: 10.2.0.0 alpha - (368249) Found support for locale: [ja_JP] version: 10.2.0.0 alpha - (368249) Found support for locale: [ko_KR] version: 10.2.0.0 alpha - (368249) Found support for locale: [pt_BR] version: 10.2.0.0 alpha - (368249) Found support for locale: [zh_CN] version: 10.2.0.0 alpha - (368249) Found support for locale: [zh_TW] version: 10.2.0.0 alpha - (368249) ------------------------------------------------------ Framework: DerbyNetClient Test environment information: COMMAND LINE STYLE: jdk13 TEST CANONS: master ------------------------------------------------------ ------------------------------------------------------ Summary results: Test Run Started: 2006-01-12 10:33:31.0 Test Run Duration: 01:31:27 71 Tests Run 89% Pass (63 tests passed) 11% Fail (8 tests failed) 0 Suites skipped ------------------------------------------------------ Failed tests in: derbynetclientmats_fail.txt ------------------------------------------------------ Passed tests in: derbynetclientmats_pass.txt ------------------------------------------------------ System properties in: derbynetclientmats_prop.txt ------------------------------------------------------ ------------------------------------------------------ Failure Details: ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/autoGeneratedJdbc30.diff *** Start: autoGeneratedJdbc30 jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 10:55:25 *** 15 del < {null} 15a15 > {3} 19 del < {null} 19a19 > {6} 23 del < {null} 23a23 > {9} 27 del < {null} 27a27 > {12} 33 del < {null} 33a33 > {12} 37 del < {null} 37a37 > {12} 41 del < {null} 41a41 > {12} 45 del < {null} 45a45 > {12} 50 del < {null} 50a50 > {6} 54 del < {null} 54a54 > {12} 58 del < {null} 58a58 > {18} 62 del < {null} 62a62 > {24} 67 del < {null} 67a67 > {0} 71 del < {null} 71a71 > {0} 75 del < {null} 75a75 > {0} 79 del < {null} 79a79 > {0} 84 del < {null} 84a84 > {25} 88 del < {null} 88a88 > {26} 92 del < {null} 92a92 > {27} 96 del < {null} 96a96 > {28} 118 del < {32} 118a118 > {15} 122 del < {32} 122a122 > {18} 126 del < {32} 126a126 > {21} 130 del < {32} 130a130 > {24} 136 del < {32} 136a136 > {24} 140 del < {32} 140a140 > {24} 144 del < {32} 144a144 > {24} 148 del < {32} 148a148 > {24} 172 del < {32} 172a172 > {24} 176 del < {32} 176a176 > {24} 180 del < {32} 180a180 > {24} 184 del < {32} 184a184 > {24} 190 del < {32} 190a190 > {24} 194 del < {32} 194a194 > {24} 198 del < {32} 198a198 > {24} 202 del < {32} 202a202 > {24} Test Failed. *** End: autoGeneratedJdbc30 jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 10:56:50 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/dbMetaDataJdbc30.diff *** Start: dbMetaDataJdbc30 jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 10:56:52 *** 15 del < getDatabaseMinorVersion() : 1 15a15 > getDatabaseMinorVersion() : 2 Test Failed. *** End: dbMetaDataJdbc30 jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 10:57:38 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/metadata.diff *** Start: metadata jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 10:57:40 *** 51 del < getDatabaseProductVersion(): 10.1.2.2 51a51 > getDatabaseProductVersion(): 10.2.0.0 alpha 64 del < getNumericFunctions(): ABS,SQRT 65 del < getStringFunctions(): LENGTH,LOWER,LTRIM,RTRIM,SUBSTR,SUBSTRING,UPPER 66 del < getSystemFunctions(): CURRENT_USER,getCurrentConnection,runTimeStatistics,SESSION_USER,USER,CURRENT SCHEMA 67 del < getTimeDateFunctions(): CURDATE,CURTIME,CURRENT_DATE,CURRENT_TIME,CURRENT_TIMESTAMP,EXTRACT 67a64,67 > getNumericFunctions(): ABS,MOD,SQRT > getStringFunctions(): CONCAT,LENGTH,LCASE,LOCATE,LTRIM,RTRIM,SUBSTRING,UCASE > getSystemFunctions(): USER > getTimeDateFunctions(): CURDATE,CURTIME,HOUR,MINUTE,MONTH,SECOND,TIMESTAMPADD,TIMESTAMPDIFF,YEAR 179a180 > ,SYS,SYSCOLPERMS,SYSTEM TABLE, 186a188,189 > ,SYS,SYSREQUIREDPERM,SYSTEM TABLE, > ,SYS,SYSROUTINEPERMS,SYSTEM TABLE, 189a193 > ,SYS,SYSTABLEPERMS,SYSTEM TABLE, 197a202 > ,SYS,SYSCOLPERMS,SYSTEM TABLE, 204a210,211 > ,SYS,SYSREQUIREDPERM,SYSTEM TABLE, > ,SYS,SYSROUTINEPERMS,SYSTEM TABLE, 207a215 > ,SYS,SYSTABLEPERMS,SYSTEM TABLE, Test Failed. *** End: metadata jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 10:59:05 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/NSinSameJVM.diff *** Start: NSinSameJVM jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 10:35:36 *** 3d2 < Connection number: 1. 5d3 < Connection number: 2. 8d5 < Connection number: 3. Test Failed. *** End: NSinSameJVM jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 10:36:04 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/odbc_metadata.diff *** Start: odbc_metadata jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 11:00:03 *** 81 del < getDatabaseProductVersion(): 10.1.2.2 81a81 > getDatabaseProductVersion(): 10.2.0.0 alpha 94 del < getNumericFunctions(): ABS,SQRT 95 del < getStringFunctions(): LENGTH,LOWER,LTRIM,RTRIM,SUBSTR,SUBSTRING,UPPER 96 del < getSystemFunctions(): CURRENT_USER,getCurrentConnection,runTimeStatistics,SESSION_USER,USER,CURRENT SCHEMA 97 del < getTimeDateFunctions(): CURDATE,CURTIME,CURRENT_DATE,CURRENT_TIME,CURRENT_TIMESTAMP,EXTRACT 97a94,97 > getNumericFunctions(): ABS,MOD,SQRT > getStringFunctions(): CONCAT,LENGTH,LCASE,LOCATE,LTRIM,RTRIM,SUBSTRING,UCASE > getSystemFunctions(): USER > getTimeDateFunctions(): CURDATE,CURTIME,HOUR,MINUTE,MONTH,SECOND,TIMESTAMPADD,TIMESTAMPDIFF,YEAR 209a210 > ,SYS,SYSCOLPERMS,SYSTEM TABLE, 216a218,219 > ,SYS,SYSREQUIREDPERM,SYSTEM TABLE, > ,SYS,SYSROUTINEPERMS,SYSTEM TABLE, 219a223 > ,SYS,SYSTABLEPERMS,SYSTEM TABLE, 227a232 > ,SYS,SYSCOLPERMS,SYSTEM TABLE, 234a240,241 > ,SYS,SYSREQUIREDPERM,SYSTEM TABLE, > ,SYS,SYSROUTINEPERMS,SYSTEM TABLE, 237a245 > ,SYS,SYSTABLEPERMS,SYSTEM TABLE, Test Failed. *** End: odbc_metadata jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 11:01:28 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/procedure.diff *** Start: procedure jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 11:09:06 *** 25 del < EXPECTED SQL Exception: (42X01) Syntax error: MISSING ELEMENT. 25a25 > EXPECTED SQL Exception: (42X01) Syntax error: EXTERNAL NAME. 27 del < EXPECTED SQL Exception: (42X01) Syntax error: MISSING ELEMENT. 27a27 > EXPECTED SQL Exception: (42X01) Syntax error: EXTERNAL NAME. 29 del < EXPECTED SQL Exception: (42X01) Syntax error: MISSING ELEMENT. 29a29 > EXPECTED SQL Exception: (42X01) Syntax error: PARAMETER STYLE. 31 del < EXPECTED SQL Exception: (42X01) Syntax error: MISSING ELEMENT. 31a31 > EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE. 33 del < EXPECTED SQL Exception: (42X01) Syntax error: MISSING ELEMENT. 33a33 > EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE. 35 del < EXPECTED SQL Exception: (42X01) Syntax error: MISSING ELEMENT. 35a35 > EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE. 37 del < EXPECTED SQL Exception: (42X01) Syntax error: MISSING ELEMENT. 37a37 > EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE. Test Failed. *** End: procedure jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 11:10:31 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/syscat.diff *** Start: syscat jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 11:19:34 *** 53a54 > SYSCOLPERMS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } 61a63,64 > SYSREQUIREDPERM |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } > SYSROUTINEPERMS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } 64a68 > SYSTABLEPERMS |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=12, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=false } 78a83 > SYSCOLPERMS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } 93a99,100 > SYSREQUIREDPERM_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } > SYSROUTINEPERMS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } 98a106 > SYSTABLEPERMS_INDEX1 |{ derby.storage.initialPages=1, derby.storage.minimumRecordSize=1, derby.storage.pageReservedSpace=0, derby.storage.pageSize=4096, derby.storage.reusableRecordId=true } 123a132,135 > SYSTABLEPERMS |S > SYSCOLPERMS |S > SYSROUTINEPERMS |S > SYSREQUIREDPERM |S 143a156,160 > SYSCOLPERMS |COLUMNS |5 |org.apache.derby.iapi.services.io.FormatableBitSet NOT NULL > SYSCOLPERMS |GRANTEE |1 |VARCHAR(30) NOT NULL > SYSCOLPERMS |GRANTOR |2 |VARCHAR(30) NOT NULL > SYSCOLPERMS |TABLEID |3 |CHAR(36) NOT NULL > SYSCOLPERMS |TYPE |4 |CHAR(1) NOT NULL 183a201,209 > SYSREQUIREDPERM |COLUMNS |5 |org.apache.derby.iapi.services.io.FormatableBitSet NOT NULL > SYSREQUIREDPERM |OBJECT |4 |CHAR(36) NOT NULL > SYSREQUIREDPERM |OPERATOR |1 |CHAR(36) NOT NULL > SYSREQUIREDPERM |OPERATORTYPE |2 |CHAR(1) NOT NULL > SYSREQUIREDPERM |PERMTYPE |3 |CHAR(1) NOT NULL > SYSROUTINEPERMS |ALIASID |3 |CHAR(36) NOT NULL > SYSROUTINEPERMS |GRANTEE |1 |VARCHAR(30) NOT NULL > SYSROUTINEPERMS |GRANTOPTION |4 |CHAR(1) NOT NULL > SYSROUTINEPERMS |GRANTOR |2 |VARCHAR(30) NOT NULL 203a230,238 > SYSTABLEPERMS |DELETEPRIV |5 |CHAR(1) NOT NULL > SYSTABLEPERMS |GRANTEE |1 |VARCHAR(30) NOT NULL > SYSTABLEPERMS |GRANTOR |2 |VARCHAR(30) NOT NULL > SYSTABLEPERMS |INSERTPRIV |6 |CHAR(1) NOT NULL > SYSTABLEPERMS |REFERENCESPRIV |8 |CHAR(1) NOT NULL > SYSTABLEPERMS |SELECTPRIV |4 |CHAR(1) NOT NULL > SYSTABLEPERMS |TABLEID |3 |CHAR(36) NOT NULL > SYSTABLEPERMS |TRIGGERPRIV |9 |CHAR(1) NOT NULL > SYSTABLEPERMS |UPDATEPRIV |7 |CHAR(1) NOT NULL 241a277,278 > SYSCOLPERMS |0 > SYSCOLPERMS |1 264a302,305 > SYSREQUIREDPERM |0 > SYSREQUIREDPERM |1 > SYSROUTINEPERMS |0 > SYSROUTINEPERMS |1 272a314,315 > SYSTABLEPERMS |0 > SYSTABLEPERMS |1 302a346,349 > SYSTABLEPERMS |S > SYSCOLPERMS |S > SYSROUTINEPERMS |S > SYSREQUIREDPERM |S 323a371,375 > SYSCOLPERMS |COLUMNS |5 |org.apache.derby.iapi.services.io.FormatableBitSet NOT NULL > SYSCOLPERMS |GRANTEE |1 |VARCHAR(30) NOT NULL > SYSCOLPERMS |GRANTOR |2 |VARCHAR(30) NOT NULL > SYSCOLPERMS |TABLEID |3 |CHAR(36) NOT NULL > SYSCOLPERMS |TYPE |4 |CHAR(1) NOT NULL 363a416,424 > SYSREQUIREDPERM |COLUMNS |5 |org.apache.derby.iapi.services.io.FormatableBitSet NOT NULL > SYSREQUIREDPERM |OBJECT |4 |CHAR(36) NOT NULL > SYSREQUIREDPERM |OPERATOR |1 |CHAR(36) NOT NULL > SYSREQUIREDPERM |OPERATORTYPE |2 |CHAR(1) NOT NULL > SYSREQUIREDPERM |PERMTYPE |3 |CHAR(1) NOT NULL > SYSROUTINEPERMS |ALIASID |3 |CHAR(36) NOT NULL > SYSROUTINEPERMS |GRANTEE |1 |VARCHAR(30) NOT NULL > SYSROUTINEPERMS |GRANTOPTION |4 |CHAR(1) NOT NULL > SYSROUTINEPERMS |GRANTOR |2 |VARCHAR(30) NOT NULL 383a445,453 > SYSTABLEPERMS |DELETEPRIV |5 |CHAR(1) NOT NULL > SYSTABLEPERMS |GRANTEE |1 |VARCHAR(30) NOT NULL > SYSTABLEPERMS |GRANTOR |2 |VARCHAR(30) NOT NULL > SYSTABLEPERMS |INSERTPRIV |6 |CHAR(1) NOT NULL > SYSTABLEPERMS |REFERENCESPRIV |8 |CHAR(1) NOT NULL > SYSTABLEPERMS |SELECTPRIV |4 |CHAR(1) NOT NULL > SYSTABLEPERMS |TABLEID |3 |CHAR(36) NOT NULL > SYSTABLEPERMS |TRIGGERPRIV |9 |CHAR(1) NOT NULL > SYSTABLEPERMS |UPDATEPRIV |7 |CHAR(1) NOT NULL 423a494,495 > SYSCOLPERMS |0 > SYSCOLPERMS |1 446a519,522 > SYSREQUIREDPERM |0 > SYSREQUIREDPERM |1 > SYSROUTINEPERMS |0 > SYSROUTINEPERMS |1 454a531,532 > SYSTABLEPERMS |0 > SYSTABLEPERMS |1 555a634,637 > SYSTABLEPERMS |1 > SYSCOLPERMS |1 > SYSROUTINEPERMS |1 > SYSREQUIREDPERM |1 634a717,720 > SYSTABLEPERMS |1 > SYSCOLPERMS |1 > SYSROUTINEPERMS |1 > SYSREQUIREDPERM |1 Test Failed. *** End: syscat jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 11:20:44 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/updatableResultSet.diff *** Start: updatableResultSet jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 11:12:32 *** 43a44,52 > Make sure that we got CONCUR_READ_ONLY? false > Jira issue Derby-159 : Warnings raised by Derby are not getting passed to the Client in Network Server Mode > Will see the warnings in embedded mode only > Now attempting to send a delete on a sql with no FOR UPDATE clause. > FAIL!!! deleteRow should have failed on sql with no FOR UPDATE clause > Now attempting to send a updateRow on a sql with no FOR UPDATE clause. > SQL State : null > Got expected exception Invalid operation to update at current cursor position > Negative Test6 - request updatable resultset for sql with FOR READ ONLY clause 47,56d55 < Now attempting to send a delete on a sql with no FOR UPDATE clause. < SQL State : null < Got expected exception This method cannot be invoked while the cursor is on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY. < Now attempting to send a updateRow on a sql with no FOR UPDATE clause. < SQL State : null < Got expected exception This method cannot be invoked while the cursor is on the insert row or if the concurrency of this ResultSet object is CONCUR_READ_ONLY. < Negative Test6 - request updatable resultset for sql with FOR READ ONLY clause < Make sure that we got CONCUR_READ_ONLY? true < Jira issue Derby-159 : Warnings raised by Derby are not getting passed to the Client in Network Server Mode < Will see the warnings in embedded mode only 126 del < column 1 on this row before deleteRow is 1 127 del < column 2 on this row before deleteRow is aa 127a125,126 > column 1 on this row before deleteRow is 2 > column 2 on this row before deleteRow is bb Test Failed. *** End: updatableResultSet jdk1.5.0_02 DerbyNetClient derbynetmats:derbynetmats 2006-01-12 11:14:49 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/jdbc20/batchUpdate.diff *** Start: batchUpdate jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 11:49:53 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbcapi/batchUpdate.java *** End: batchUpdate jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 11:49:53 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/jdbc20/scrollCursors2.diff *** Start: scrollCursors2 jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 11:49:03 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: lang/scrollCursors2.java *** End: scrollCursors2 jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 11:49:03 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/jdbc20/statementJdbc20.diff *** Start: statementJdbc20 jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 11:51:32 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbcapi/statementJdbc20.java *** End: statementJdbc20 jdk1.5.0_02 DerbyNetClient derbynetmats:jdbc20 2006-01-12 11:51:32 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/jdbcapi/resultsetStream.diff *** Start: resultsetStream jdk1.5.0_02 DerbyNetClient derbynetmats:jdbcapi 2006-01-12 11:31:03 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbcapi/resultsetStream.java *** End: resultsetStream jdk1.5.0_02 DerbyNetClient derbynetmats:jdbcapi 2006-01-12 11:31:03 *** ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/jdbcapi/testRelative.diff *** Start: testRelative jdk1.5.0_02 DerbyNetClient derbynetmats:jdbcapi 2006-01-12 11:47:19 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbcapi/testRelative.java *** End: testRelative jdk1.5.0_02 DerbyNetClient derbynetmats:jdbcapi 2006-01-12 11:47:19 *** ------------------------------------------------------ ------=_Part_25165_19401027.1137180170825--