Generating report for RunSuite derbyall null null null true ------------------ Java Information ------------------ Java Version: 1.5.0_01 Java Vendor: Sun Microsystems Inc. Java home: /usr/jdk/instances/jdk1.5.0/jre Java classpath: /export/home/kh160127/derby/trunk/jars/sane/derbyTesting.jar:/export/home/kh160127/derby/trunk/jars/sane/derby.jar:/export/home/kh160127/derby/trunk/jars/sane/derbytools.jar:/export/home/kh160127/derby/trunk/jars/sane/derbynet.jar:/export/home/kh160127/derby/trunk/jars/sane/derbyclient.jar:/export/home/kh160127/derby/trunk/jars/sane/derbyLocale_de_DE.jar:/export/home/kh160127/derby/trunk/jars/sane/derbyLocale_es.jar:/export/home/kh160127/derby/trunk/jars/sane/derbyLocale_fr.jar:/export/home/kh160127/derby/trunk/jars/sane/derbyLocale_it.jar:/export/home/kh160127/derby/trunk/jars/sane/derbyLocale_ja_JP.jar:/export/home/kh160127/derby/trunk/jars/sane/derbyLocale_ko_KR.jar:/export/home/kh160127/derby/trunk/jars/sane/derbyLocale_pt_BR.jar:/export/home/kh160127/derby/trunk/jars/sane/derbyLocale_zh_CN.jar:/export/home/kh160127/derby/trunk/jars/sane/derbyLocale_zh_TW.jar:/export/home/kh160127/derby/trunk/tools/java/jakarta-oro-2.0.8.jar:/export/home/kh160127/derby/trunk/tools/java/jce1_2_2.jar OS name: SunOS OS architecture: x86 OS version: 5.10 Java user name: kh160127 Java user home: /home/kh160127 Java user dir: /export/home/kh160127/tmp/derbyall-2005-09-12 java.specification.name: Java Platform API Specification java.specification.version: 1.5 --------- Derby Information -------- JRE - JDBC: J2SE 5.0 - JDBC 3.0 [/export/home/kh160127/derby/trunk/jars/sane/derby.jar] 10.2.0.0 alpha - (280169M) [/export/home/kh160127/derby/trunk/jars/sane/derbytools.jar] 10.2.0.0 alpha - (280169M) [/export/home/kh160127/derby/trunk/jars/sane/derbynet.jar] 10.2.0.0 alpha - (280169M) [/export/home/kh160127/derby/trunk/jars/sane/derbyclient.jar] 10.2.0.0 alpha - (280169M) ------------------------------------------------------ ----------------- Locale Information ----------------- Current Locale : [English/United States [en_US]] Found support for locale: [de_DE] version: 10.2.0.0 alpha - (280169M) Found support for locale: [es] version: 10.2.0.0 alpha - (280169M) Found support for locale: [fr] version: 10.2.0.0 alpha - (280169M) Found support for locale: [it] version: 10.2.0.0 alpha - (280169M) Found support for locale: [ja_JP] version: 10.2.0.0 alpha - (280169M) Found support for locale: [ko_KR] version: 10.2.0.0 alpha - (280169M) Found support for locale: [pt_BR] version: 10.2.0.0 alpha - (280169M) Found support for locale: [zh_CN] version: 10.2.0.0 alpha - (280169M) Found support for locale: [zh_TW] version: 10.2.0.0 alpha - (280169M) ------------------------------------------------------ Test environment information: COMMAND LINE STYLE: jdk13 TEST CANONS: master ------------------------------------------------------ ------------------------------------------------------ Summary results: Test Run Started: 2005-09-12 08:33:54.0 Test Run Duration: 01:47:08 531 Tests Run 100% Pass (530 tests passed) 0% Fail (1 tests failed) 4 Suites skipped ------------------------------------------------------ Failed tests in: derbyall_fail.txt ------------------------------------------------------ Passed tests in: derbyall_pass.txt ------------------------------------------------------ Skipped suites in: derbyall_skip.txt ------------------------------------------------------ System properties in: derbyall_prop.txt ------------------------------------------------------ ------------------------------------------------------ Failure Details: ********* Diff file derbyall/derbynetclientmats/DerbyNetClient/derbynetmats/jdbcapi/resultsetStream.diff *** Start: resultsetStream jdk1.5.0_01 DerbyNetClient derbynetmats:jdbcapi 2005-09-12 09:28:56 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbcapi/resultsetStream.java *** End: resultsetStream jdk1.5.0_01 DerbyNetClient derbynetmats:jdbcapi 2005-09-12 09:28:56 *** ********* Diff file derbyall/derbynetclientmats/DerbyNetClient/derbynetmats/jdbcapi/testRelative.diff *** Start: testRelative jdk1.5.0_01 DerbyNetClient derbynetmats:jdbcapi 2005-09-12 09:31:30 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbcapi/testRelative.java *** End: testRelative jdk1.5.0_01 DerbyNetClient derbynetmats:jdbcapi 2005-09-12 09:31:30 *** ********* Diff file derbyall/derbynetclientmats/DerbyNetClient/derbynetmats/jdbcapi/SetQueryTimeoutTest.diff *** Start: SetQueryTimeoutTest jdk1.5.0_01 DerbyNetClient derbynetmats:jdbcapi 2005-09-12 09:31:24 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbcapi/SetQueryTimeoutTest.java *** End: SetQueryTimeoutTest jdk1.5.0_01 DerbyNetClient derbynetmats:jdbcapi 2005-09-12 09:31:24 *** ********* Diff file derbyall/derbynetclientmats/DerbyNetClient/derbynetmats/jdbc20/scrollCursors2.diff *** Start: scrollCursors2 jdk1.5.0_01 DerbyNetClient derbynetmats:jdbc20 2005-09-12 09:31:42 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: lang/scrollCursors2.java *** End: scrollCursors2 jdk1.5.0_01 DerbyNetClient derbynetmats:jdbc20 2005-09-12 09:31:42 *** ********* Diff file derbyall/derbynetclientmats/DerbyNetClient/derbynetmats/jdbc20/batchUpdate.diff *** Start: batchUpdate jdk1.5.0_01 DerbyNetClient derbynetmats:jdbc20 2005-09-12 09:31:49 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbcapi/batchUpdate.java *** End: batchUpdate jdk1.5.0_01 DerbyNetClient derbynetmats:jdbc20 2005-09-12 09:31:49 *** ********* Diff file derbyall/derbynetclientmats/DerbyNetClient/derbynetmats/jdbc20/statementJdbc20.diff *** Start: statementJdbc20 jdk1.5.0_01 DerbyNetClient derbynetmats:jdbc20 2005-09-12 09:32:00 *** Test skipped: listed in DerbyNetClient.exclude file, skipping test: jdbcapi/statementJdbc20.java *** End: statementJdbc20 jdk1.5.0_01 DerbyNetClient derbynetmats:jdbc20 2005-09-12 09:32:00 *** ********* Diff file derbyall/encryptionAll/encryptionAll/encryptionKey.diff *** Start: encryptionKey jdk1.5.0_01 encryptionAll:encryptionAll 2005-09-12 09:42:41 *** 20a21,24 > ERROR XJ041: Failed to create database 'encdbcbc_key', see the next exception for details. > ERROR XBM01: Startup failed due to an exception. See next exception for details. > ERROR XBCX0: Exception from Cryptography provider. See next exception for details. > ERROR XJ001: Java exception: 'DES key length must be 8 bytes: java.security.InvalidKeyException'. 22 del < 0 rows inserted/updated/deleted 22a26 > IJ ERROR: Unable to establish connection 24 del < 1 row inserted/updated/deleted 24a28 > IJ ERROR: Unable to establish connection 26 del < I1 27 del < ----------- 28 del < 1 28a30 > IJ ERROR: Unable to establish connection 29a32 > IJ ERROR: Unable to establish connection 31 del < ERROR 08006: Database 'encdbcbc_key' shutdown. 31a34 > ERROR XJ004: Database 'encdbcbc_key' not found. 34 del < WARNING 01J01: Database 'encdbcbc_key' not created, connection made to existing database instead. 35 del < ij(CONNECTION1)> select * from t1; 36 del < I1 37 del < ----------- 38 del < 1 39 del < ij(CONNECTION1)> connect 'jdbc:derby:encdbcbc_key;shutdown=true'; 40 del < ERROR 08006: Database 'encdbcbc_key' shutdown. 41 del < ij(CONNECTION1)> -- (-ve case) connect without the encryptionKey 41a37,45 > ERROR XJ041: Failed to create database 'encdbcbc_key', see the next exception for details. > ERROR XBM01: Startup failed due to an exception. See next exception for details. > ERROR XBCX0: Exception from Cryptography provider. See next exception for details. > ERROR XJ001: Java exception: 'DES key length must be 8 bytes: java.security.InvalidKeyException'. > ij> select * from t1; > IJ ERROR: Unable to establish connection > ij> connect 'jdbc:derby:encdbcbc_key;shutdown=true'; > ERROR XJ004: Database 'encdbcbc_key' not found. > ij> -- (-ve case) connect without the encryptionKey 45 del < ERROR XJ040: Failed to start database 'encdbcbc_key', see the next exception for details. 46 del < ERROR XBCXK: The given encryption key does not match the encryption key used when creating the database. Please ensure that you are using the correct encryption key and try again. 47 del < ij(CONNECTION1)> -- wrong key 47a49,53 > ERROR XJ041: Failed to create database 'encdbcbc_key', see the next exception for details. > ERROR XBM01: Startup failed due to an exception. See next exception for details. > ERROR XBCX0: Exception from Cryptography provider. See next exception for details. > ERROR XJ001: Java exception: 'DES key length must be 8 bytes: java.security.InvalidKeyException'. > ij> -- wrong key 49 del < ERROR XJ040: Failed to start database 'encdbcbc_key', see the next exception for details. 50 del < ERROR XBCXK: The given encryption key does not match the encryption key used when creating the database. Please ensure that you are using the correct encryption key and try again. 51 del < ij(CONNECTION1)> select * from t1; 52 del < ERROR 08003: No current connection. 53 del < ij(CONNECTION1)> -- correct key 53a55,61 > ERROR XJ041: Failed to create database 'encdbcbc_key', see the next exception for details. > ERROR XBM01: Startup failed due to an exception. See next exception for details. > ERROR XBCX0: Exception from Cryptography provider. See next exception for details. > ERROR XJ001: Java exception: 'DES key length must be 8 bytes: java.security.InvalidKeyException'. > ij> select * from t1; > IJ ERROR: Unable to establish connection > ij> -- correct key 55 del < WARNING 01J01: Database 'encdbcbc_key' not created, connection made to existing database instead. 56 del < ij(CONNECTION2)> select * from t1; 57 del < I1 58 del < ----------- 59 del < 1 60 del < ij(CONNECTION2)> -- case 2 backup 60a63,69 > ERROR XJ041: Failed to create database 'encdbcbc_key', see the next exception for details. > ERROR XBM01: Startup failed due to an exception. See next exception for details. > ERROR XBCX0: Exception from Cryptography provider. See next exception for details. > ERROR XJ001: Java exception: 'DES key length must be 8 bytes: java.security.InvalidKeyException'. > ij> select * from t1; > IJ ERROR: Unable to establish connection > ij> -- case 2 backup 62 del < 0 rows inserted/updated/deleted 63 del < ij(CONNECTION2)> connect 'jdbc:derby:encdbcbc_key;shutdown=true'; 64 del < ERROR 08006: Database 'encdbcbc_key' shutdown. 65 del < ij(CONNECTION2)> -- connect to original db after backup 65a71,74 > IJ ERROR: Unable to establish connection > ij> connect 'jdbc:derby:encdbcbc_key;shutdown=true'; > ERROR XJ004: Database 'encdbcbc_key' not found. > ij> -- connect to original db after backup 67 del < WARNING 01J01: Database 'encdbcbc_key' not created, connection made to existing database instead. 68 del < ij(CONNECTION3)> select * from t1; 69 del < I1 70 del < ----------- 71 del < 1 72 del < ij(CONNECTION3)> -- case 3 :create db from backup using correct key 72a76,82 > ERROR XJ041: Failed to create database 'encdbcbc_key', see the next exception for details. > ERROR XBM01: Startup failed due to an exception. See next exception for details. > ERROR XBCX0: Exception from Cryptography provider. See next exception for details. > ERROR XJ001: Java exception: 'DES key length must be 8 bytes: java.security.InvalidKeyException'. > ij> select * from t1; > IJ ERROR: Unable to establish connection > ij> -- case 3 :create db from backup using correct key 74 del < ij(CONNECTION4)> select * from t1; 75 del < I1 76 del < ----------- 77 del < 1 78 del < ij(CONNECTION4)> connect 'jdbc:derby:encdbcbc_key2;shutdown=true'; 79 del < ERROR 08006: Database 'encdbcbc_key2' shutdown. 80 del < ij(CONNECTION4)> -- create db from backup using wrong key 80a84,90 > ERROR XJ040: Failed to start database 'encdbcbc_key2', see the next exception for details. > ERROR XBM0Y: Backup database directory extinout/bkup1/encdbcbc_key not found. Please make sure that the specified backup path is right. > ij> select * from t1; > IJ ERROR: Unable to establish connection > ij> connect 'jdbc:derby:encdbcbc_key2;shutdown=true'; > ERROR XJ004: Database 'encdbcbc_key2' not found. > ij> -- create db from backup using wrong key 83 del < ERROR XBCXK: The given encryption key does not match the encryption key used when creating the database. Please ensure that you are using the correct encryption key and try again. 84 del < ij(CONNECTION4)> select * from t1; 85 del < ERROR 08003: No current connection. 86 del < ij(CONNECTION4)> connect 'jdbc:derby:encdbcbc_key3;shutdown=true'; 86a93,96 > ERROR XBM0Y: Backup database directory extinout/bkup1/encdbcbc_key not found. Please make sure that the specified backup path is right. > ij> select * from t1; > IJ ERROR: Unable to establish connection > ij> connect 'jdbc:derby:encdbcbc_key3;shutdown=true'; 88 del < ij(CONNECTION4)> -- create db from backup using correct key 88a98 > ij> -- create db from backup using correct key 90 del < ij(CONNECTION5)> select * from t1; 91 del < I1 92 del < ----------- 93 del < 1 94 del < ij(CONNECTION5)> connect 'jdbc:derby:encdbcbc_key12;shutdown=true'; 94a100,104 > ERROR XJ040: Failed to start database 'encdbcbc_12', see the next exception for details. > ERROR XBM0Y: Backup database directory extinout/bkup1/encdbcbc_key not found. Please make sure that the specified backup path is right. > ij> select * from t1; > IJ ERROR: Unable to establish connection > ij> connect 'jdbc:derby:encdbcbc_key12;shutdown=true'; 96 del < ij(CONNECTION5)> connect 'jdbc:derby:encdb;create=true;dataEncryption=true;encryptionAlgorithm=DES/CBC/NoPadding;encryptionKey=61626364656667686961626364656568'; 97 del < ij(CONNECTION6)> create table t1(i1 int ,c2 char(20)); 98 del < 0 rows inserted/updated/deleted 99 del < ij(CONNECTION6)> insert into t1 values(1,'a'); 100 del < 1 row inserted/updated/deleted 101 del < ij(CONNECTION6)> select * from t1; 102 del < I1 |C2 103 del < -------------------------------- 104 del < 1 |a 105 del < ij(CONNECTION6)> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE('extinout/mybackup2'); 106 del < 0 rows inserted/updated/deleted 107 del < ij(CONNECTION6)> connect 'jdbc:derby:encdb;shutdown=true'; 108 del < ERROR 08006: Database 'encdb' shutdown. 109 del < ij(CONNECTION6)> disconnect; 109a106,122 > ij> connect 'jdbc:derby:encdb;create=true;dataEncryption=true;encryptionAlgorithm=DES/CBC/NoPadding;encryptionKey=61626364656667686961626364656568'; > ERROR XJ041: Failed to create database 'encdb', see the next exception for details. > ERROR XBM01: Startup failed due to an exception. See next exception for details. > ERROR XBCX0: Exception from Cryptography provider. See next exception for details. > ERROR XJ001: Java exception: 'DES key length must be 8 bytes: java.security.InvalidKeyException'. > ij> create table t1(i1 int ,c2 char(20)); > IJ ERROR: Unable to establish connection > ij> insert into t1 values(1,'a'); > IJ ERROR: Unable to establish connection > ij> select * from t1; > IJ ERROR: Unable to establish connection > ij> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE('extinout/mybackup2'); > IJ ERROR: Unable to establish connection > ij> connect 'jdbc:derby:encdb;shutdown=true'; > ERROR XJ004: Database 'encdb' not found. > ij> disconnect; > IJ ERROR: Unable to establish connection 111 del < ij(CONNECTION6)> select * from t1; 112 del < I1 |C2 113 del < -------------------------------- 114 del < 1 |a 115 del < ij(CONNECTION6)> disconnect; 115a124,129 > ERROR XJ040: Failed to start database 'encdb', see the next exception for details. > ERROR XBM0Y: Backup database directory extinout/mybackup2/encdb not found. Please make sure that the specified backup path is right. > ij> select * from t1; > IJ ERROR: Unable to establish connection > ij> disconnect; > IJ ERROR: Unable to establish connection Test Failed. *** End: encryptionKey jdk1.5.0_01 encryptionAll:encryptionAll 2005-09-12 09:42:43 *** ------------------------------------------------------