Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 38628 invoked from network); 9 Dec 2005 23:31:44 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 9 Dec 2005 23:31:44 -0000 Received: (qmail 957 invoked by uid 500); 9 Dec 2005 23:31:43 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 937 invoked by uid 500); 9 Dec 2005 23:31:42 -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 928 invoked by uid 99); 9 Dec 2005 23:31:42 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Dec 2005 15:31:42 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of dremesh@gmail.com designates 66.249.82.200 as permitted sender) Received: from [66.249.82.200] (HELO xproxy.gmail.com) (66.249.82.200) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Dec 2005 15:31:37 -0800 Received: by xproxy.gmail.com with SMTP id s14so704964wxc for ; Fri, 09 Dec 2005 15:31:16 -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=WtrMb/Zf884oSbspdgSL4Nte2+n5nfmEhyzGKq43rQK70h0/OPdYUIO+lfGJiNYWtbY3DLfXQNEPWbsFD+molqvKMrq2eGXkMvyxp7UcU4ctYHyJMZf95w1A9Dqkkt+kFGW20P2k592StJAsZ7xIXaDmskWMipsDb8Fq4iDWe3A= Received: by 10.70.33.1 with SMTP id g1mr6137369wxg; Fri, 09 Dec 2005 15:31:16 -0800 (PST) Received: by 10.70.30.16 with HTTP; Fri, 9 Dec 2005 15:31:16 -0800 (PST) Message-ID: <58ed70f50512091531x5509e838m714e368073c176f9@mail.gmail.com> Date: Fri, 9 Dec 2005 15:31:16 -0800 From: Deepa Remesh To: derby-dev@db.apache.org Subject: Patch for jdk13 and j9 tests MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_4242_17625109.1134171076186" X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_4242_17625109.1134171076186 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi, I am attaching a patch with test and master changes for tests which are failing with jdk13 and j9_13 jvm. * updatableResultSet.out - updated masters for jdk13. * derby_tests.policy - added security permission "insertProvider.IBMJCE" which is required by encryption tests to run with IBM jdk13. * store\TestDurabilityProperty.java, store\backupRestore1.java - Added a condition to use DataSource to get connection when jsr169 is used. This condition is needed because j9_13 uses EmbeddedDataSource which implements javax.naming.Referenceable. This is not available in j9. I have run the changed tests using jdk14 and jdk13/j9_13 successfully. Please review/commit this patch. Thanks, Deepa ------=_Part_4242_17625109.1134171076186 Content-Type: text/x-patch; name=jdk13tests.diff; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jdk13tests.diff" Index: java/testing/org/apache/derbyTesting/functionTests/tests/store/TestDurabilityProperty.java =================================================================== --- java/testing/org/apache/derbyTesting/functionTests/tests/store/TestDurabilityProperty.java (revision 355621) +++ java/testing/org/apache/derbyTesting/functionTests/tests/store/TestDurabilityProperty.java (working copy) @@ -23,12 +23,12 @@ import java.sql.Connection; import java.sql.Statement; import java.sql.PreparedStatement; +import java.sql.DriverManager; import java.sql.SQLException; import java.io.*; import org.apache.derbyTesting.functionTests.util.TestUtil; import java.util.Properties; - /** * This program tests the system when the derby.system.durability property is * set to 'test'. @@ -124,7 +124,11 @@ try { conn.close(); - TestUtil.shutdownUsingDataSource(""); + if(TestUtil.HAVE_DRIVER_CLASS) { + DriverManager.getConnection("jdbc:derby:;shutdown=true"); + } else { + TestUtil.shutdownUsingDataSource(""); + } } catch (SQLException sqle) { if ("XJ015".equals(sqle.getSQLState())) { }// ok database shutdown Index: java/testing/org/apache/derbyTesting/functionTests/tests/store/backupRestore1.java =================================================================== --- java/testing/org/apache/derbyTesting/functionTests/tests/store/backupRestore1.java (revision 355621) +++ java/testing/org/apache/derbyTesting/functionTests/tests/store/backupRestore1.java (working copy) @@ -27,6 +27,7 @@ import java.sql.CallableStatement; import java.sql.Connection; +import java.sql.DriverManager; import java.sql.SQLException; import java.sql.PreparedStatement; import java.sql.ResultSet; @@ -121,8 +122,14 @@ //shutdown the database .. try{ - //shutdown - TestUtil.shutdownUsingDataSource("wombat"); + //shutdown + //Need to use if loop because DataSource does not work with j9_13. + //javax.naming.Referenceable class is not available in j9_13 + if(TestUtil.HAVE_DRIVER_CLASS) { + Connection conn = DriverManager.getConnection("jdbc:derby:wombat;shutdown=true"); + } else { + TestUtil.shutdownUsingDataSource("wombat"); + } }catch(SQLException se){ if (se.getSQLState() != null && se.getSQLState().equals("08006")) System.out.println("database shutdown properly"); @@ -134,11 +141,17 @@ System.out.println("testing rollforward recovery"); try{ + Connection conn; //perform rollforward recovery and do some inserts again - Properties prop = new Properties(); - prop.setProperty("databaseName","wombat"); - prop.setProperty("connectionAttributes", "rollForwardRecoveryFrom=extinout/mybackup/wombat"); - Connection conn = TestUtil.getDataSourceConnection(prop); + if(TestUtil.HAVE_DRIVER_CLASS) { + conn = DriverManager.getConnection( + "jdbc:derby:wombat;rollForwardRecoveryFrom=extinout/mybackup/wombat"); + } else { + Properties prop = new Properties(); + prop.setProperty("databaseName","wombat"); + prop.setProperty("connectionAttributes", "rollForwardRecoveryFrom=extinout/mybackup/wombat"); + conn = TestUtil.getDataSourceConnection(prop); + } //run consistenct checker Statement stmt = conn.createStatement(); stmt.execute("VALUES (ConsistencyChecker())"); @@ -152,7 +165,12 @@ conn.commit(); conn.close(); - TestUtil.shutdownUsingDataSource("wombat"); + + if(TestUtil.HAVE_DRIVER_CLASS) { + conn = DriverManager.getConnection("jdbc:derby:wombat;shutdown=true"); + } else { + TestUtil.shutdownUsingDataSource("wombat"); + } } catch( SQLException se) { @@ -170,9 +188,14 @@ RandomAccessFile rfs = null; boolean alreadyShutdown = false; try{ - Properties prop = new Properties(); - prop.setProperty("databaseName","wombat"); - Connection conn = TestUtil.getDataSourceConnection(prop); + Connection conn; + if(TestUtil.HAVE_DRIVER_CLASS) { + conn = DriverManager.getConnection("jdbc:derby:wombat"); + } else { + Properties prop = new Properties(); + prop.setProperty("databaseName","wombat"); + conn = TestUtil.getDataSourceConnection(prop); + } //just open to a file in existing backup, so that rename will fail on //next backup @@ -186,7 +209,11 @@ backupStmt.execute(); backupStmt.close(); conn.close(); - TestUtil.shutdownUsingDataSource("wombat"); + if(TestUtil.HAVE_DRIVER_CLASS) { + conn = DriverManager.getConnection("jdbc:derby:wombat;shutdown=true"); + } else { + TestUtil.shutdownUsingDataSource("wombat"); + } }catch(SQLException se) { if (se.getSQLState() != null && se.getSQLState().equals("XSRS4")) @@ -211,7 +238,11 @@ { try{ //shutdown - TestUtil.shutdownUsingDataSource("wombat"); + if(TestUtil.HAVE_DRIVER_CLASS) { + Connection conn = DriverManager.getConnection("jdbc:derby:wombat;shutdown=true"); + } else { + TestUtil.shutdownUsingDataSource("wombat"); + } }catch(SQLException se){ if (se.getSQLState() != null && se.getSQLState().equals("08006")) System.out.println("database shutdown properly"); @@ -228,17 +259,26 @@ if(rfs != null ) rfs.close(); - Properties prop = new Properties(); - prop.setProperty("databaseName","wombat"); - prop.setProperty("connectionAttributes","restoreFrom=extinout/mybackup/wombat"); - Connection conn = TestUtil.getDataSourceConnection(prop); + Connection conn; + if(TestUtil.HAVE_DRIVER_CLASS) { + conn = DriverManager.getConnection("jdbc:derby:wombat;restoreFrom=extinout/mybackup/wombat"); + } else { + Properties prop = new Properties(); + prop.setProperty("databaseName","wombat"); + prop.setProperty("connectionAttributes","restoreFrom=extinout/mybackup/wombat"); + conn = TestUtil.getDataSourceConnection(prop); + } //run consistenct checker Statement stmt = conn.createStatement(); stmt.execute("VALUES (ConsistencyChecker())"); conn.close(); //shutdown the backup db; - TestUtil.shutdownUsingDataSource("wombat"); + if(TestUtil.HAVE_DRIVER_CLASS) { + conn = DriverManager.getConnection("jdbc:derby:wombat;shutdown=true"); + } else { + TestUtil.shutdownUsingDataSource("wombat"); + } }catch(SQLException se) { if (se.getSQLState() != null && se.getSQLState().equals("08006")) @@ -251,9 +291,14 @@ //now take a backup again , just to make all is well in the system. try{ - Properties prop = new Properties(); - prop.setProperty("databaseName","wombat"); - Connection conn = TestUtil.getDataSourceConnection(prop); + Connection conn; + if(TestUtil.HAVE_DRIVER_CLASS) { + conn = DriverManager.getConnection("jdbc:derby:wombat"); + } else { + Properties prop = new Properties(); + prop.setProperty("databaseName","wombat"); + conn = TestUtil.getDataSourceConnection(prop); + } CallableStatement backupStmt = conn.prepareCall( "CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)"); @@ -264,7 +309,11 @@ Statement stmt = conn.createStatement(); stmt.execute("VALUES (ConsistencyChecker())"); conn.close(); - TestUtil.shutdownUsingDataSource("wombat"); + if(TestUtil.HAVE_DRIVER_CLASS) { + conn = DriverManager.getConnection("jdbc:derby:wombat;shutdown=true"); + } else { + TestUtil.shutdownUsingDataSource("wombat"); + } }catch(SQLException se) { if (se.getSQLState() != null && se.getSQLState().equals("08006")) Index: java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out =================================================================== --- java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out (revision 355621) +++ java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out (working copy) @@ -588,9 +588,7 @@ Got expected exception : ResultSet is not updatable. Test updateClob on a readonly resultset Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Test updateDate on a readonly resultset Using column position as first parameter to updateDate Got expected exception : ResultSet is not updatable. @@ -608,9 +606,7 @@ Got expected exception : ResultSet is not updatable. Test updateBlob on a readonly resultset Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Test updateBoolean on a readonly resultset Using column position as first parameter to updateBoolean Got expected exception : ResultSet is not updatable. @@ -623,14 +619,10 @@ Got expected exception : ResultSet is not updatable. Test updateArray on a readonly resultset Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Test updateRef on a readonly resultset Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Positive Test21 - Test all updateXXX(excluding updateObject) methods on all the supported sql datatypes Next datatype to test is SMALLINT Testing updateShort on SQL type SMALLINT @@ -681,9 +673,7 @@ Got expected exception : Illegal Conversion Testing updateClob on SQL type SMALLINT Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type SMALLINT Using column position as first parameter to updateDate Got expected exception : Illegal Conversion @@ -701,9 +691,7 @@ Got expected exception : Illegal Conversion Testing updateBlob on SQL type SMALLINT Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type SMALLINT Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -712,14 +700,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type SMALLINT Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type SMALLINT Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is INTEGER Testing updateShort on SQL type INTEGER Using column position as first parameter to updateShort @@ -769,9 +753,7 @@ Got expected exception : Illegal Conversion Testing updateClob on SQL type INTEGER Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type INTEGER Using column position as first parameter to updateDate Got expected exception : Illegal Conversion @@ -789,9 +771,7 @@ Got expected exception : Illegal Conversion Testing updateBlob on SQL type INTEGER Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type INTEGER Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -800,14 +780,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type INTEGER Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type INTEGER Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is BIGINT Testing updateShort on SQL type BIGINT Using column position as first parameter to updateShort @@ -857,9 +833,7 @@ Got expected exception : Illegal Conversion Testing updateClob on SQL type BIGINT Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type BIGINT Using column position as first parameter to updateDate Got expected exception : Illegal Conversion @@ -877,9 +851,7 @@ Got expected exception : Illegal Conversion Testing updateBlob on SQL type BIGINT Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type BIGINT Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -888,14 +860,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type BIGINT Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type BIGINT Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is DECIMAL(10,5) Testing updateShort on SQL type DECIMAL(10,5) Using column position as first parameter to updateShort @@ -945,9 +913,7 @@ Got expected exception : Illegal Conversion Testing updateClob on SQL type DECIMAL(10,5) Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type DECIMAL(10,5) Using column position as first parameter to updateDate Got expected exception : Illegal Conversion @@ -965,9 +931,7 @@ Got expected exception : Illegal Conversion Testing updateBlob on SQL type DECIMAL(10,5) Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type DECIMAL(10,5) Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -976,14 +940,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type DECIMAL(10,5) Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type DECIMAL(10,5) Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is REAL Testing updateShort on SQL type REAL Using column position as first parameter to updateShort @@ -1031,9 +991,7 @@ Got expected exception : Illegal Conversion Testing updateClob on SQL type REAL Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type REAL Using column position as first parameter to updateDate Got expected exception : Illegal Conversion @@ -1051,9 +1009,7 @@ Got expected exception : Illegal Conversion Testing updateBlob on SQL type REAL Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type REAL Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -1062,14 +1018,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type REAL Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type REAL Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is DOUBLE Testing updateShort on SQL type DOUBLE Using column position as first parameter to updateShort @@ -1117,9 +1069,7 @@ Got expected exception : Illegal Conversion Testing updateClob on SQL type DOUBLE Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type DOUBLE Using column position as first parameter to updateDate Got expected exception : Illegal Conversion @@ -1137,9 +1087,7 @@ Got expected exception : Illegal Conversion Testing updateBlob on SQL type DOUBLE Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type DOUBLE Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -1148,14 +1096,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type DOUBLE Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type DOUBLE Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is CHAR(60) Testing updateShort on SQL type CHAR(60) Using column position as first parameter to updateShort @@ -1199,9 +1143,7 @@ Got expected exception : Illegal Conversion Testing updateClob on SQL type CHAR(60) Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type CHAR(60) Using column position as first parameter to updateDate Using column name as first parameter to updateDate @@ -1213,9 +1155,7 @@ Using column name as first parameter to updateTimestamp Testing updateBlob on SQL type CHAR(60) Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type CHAR(60) Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -1224,14 +1164,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type CHAR(60) Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type CHAR(60) Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is VARCHAR(60) Testing updateShort on SQL type VARCHAR(60) Using column position as first parameter to updateShort @@ -1275,9 +1211,7 @@ Got expected exception : Illegal Conversion Testing updateClob on SQL type VARCHAR(60) Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type VARCHAR(60) Using column position as first parameter to updateDate Using column name as first parameter to updateDate @@ -1289,9 +1223,7 @@ Using column name as first parameter to updateTimestamp Testing updateBlob on SQL type VARCHAR(60) Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type VARCHAR(60) Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -1300,14 +1232,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type VARCHAR(60) Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type VARCHAR(60) Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is LONG VARCHAR Testing updateShort on SQL type LONG VARCHAR Using column position as first parameter to updateShort @@ -1351,9 +1279,7 @@ Got expected exception : Illegal Conversion Testing updateClob on SQL type LONG VARCHAR Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type LONG VARCHAR Using column position as first parameter to updateDate Using column name as first parameter to updateDate @@ -1365,9 +1291,7 @@ Using column name as first parameter to updateTimestamp Testing updateBlob on SQL type LONG VARCHAR Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type LONG VARCHAR Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -1376,14 +1300,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type LONG VARCHAR Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type LONG VARCHAR Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is CHAR(2) FOR BIT DATA Testing updateShort on SQL type CHAR(2) FOR BIT DATA Using column position as first parameter to updateShort @@ -1443,9 +1363,7 @@ Using column name as first parameter to updateBinaryStream Testing updateClob on SQL type CHAR(2) FOR BIT DATA Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type CHAR(2) FOR BIT DATA Using column position as first parameter to updateDate Got expected exception : Illegal Conversion @@ -1463,9 +1381,7 @@ Got expected exception : Illegal Conversion Testing updateBlob on SQL type CHAR(2) FOR BIT DATA Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type CHAR(2) FOR BIT DATA Using column position as first parameter to updateBoolean Got expected exception : Illegal Conversion @@ -1476,14 +1392,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type CHAR(2) FOR BIT DATA Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type CHAR(2) FOR BIT DATA Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is VARCHAR(2) FOR BIT DATA Testing updateShort on SQL type VARCHAR(2) FOR BIT DATA Using column position as first parameter to updateShort @@ -1543,9 +1455,7 @@ Using column name as first parameter to updateBinaryStream Testing updateClob on SQL type VARCHAR(2) FOR BIT DATA Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type VARCHAR(2) FOR BIT DATA Using column position as first parameter to updateDate Got expected exception : Illegal Conversion @@ -1563,9 +1473,7 @@ Got expected exception : Illegal Conversion Testing updateBlob on SQL type VARCHAR(2) FOR BIT DATA Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type VARCHAR(2) FOR BIT DATA Using column position as first parameter to updateBoolean Got expected exception : Illegal Conversion @@ -1576,14 +1484,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type VARCHAR(2) FOR BIT DATA Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type VARCHAR(2) FOR BIT DATA Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is LONG VARCHAR FOR BIT DATA Testing updateShort on SQL type LONG VARCHAR FOR BIT DATA Using column position as first parameter to updateShort @@ -1643,9 +1547,7 @@ Using column name as first parameter to updateBinaryStream Testing updateClob on SQL type LONG VARCHAR FOR BIT DATA Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type LONG VARCHAR FOR BIT DATA Using column position as first parameter to updateDate Got expected exception : Illegal Conversion @@ -1663,9 +1565,7 @@ Got expected exception : Illegal Conversion Testing updateBlob on SQL type LONG VARCHAR FOR BIT DATA Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type LONG VARCHAR FOR BIT DATA Using column position as first parameter to updateBoolean Got expected exception : Illegal Conversion @@ -1676,14 +1576,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type LONG VARCHAR FOR BIT DATA Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type LONG VARCHAR FOR BIT DATA Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is CLOB(1k) Testing updateShort on SQL type CLOB(1k) Using column position as first parameter to updateShort @@ -1741,9 +1637,7 @@ Got expected exception : Illegal Conversion Testing updateClob on SQL type CLOB(1k) Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type CLOB(1k) Using column position as first parameter to updateDate Got expected exception : Illegal Conversion @@ -1761,9 +1655,7 @@ Got expected exception : Illegal Conversion Testing updateBlob on SQL type CLOB(1k) Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type CLOB(1k) Using column position as first parameter to updateBoolean Got expected exception : Illegal Conversion @@ -1774,14 +1666,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type CLOB(1k) Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type CLOB(1k) Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is DATE Testing updateShort on SQL type DATE Using column position as first parameter to updateShort @@ -1845,9 +1733,7 @@ Got expected exception : Illegal Conversion Testing updateClob on SQL type DATE Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type DATE Using column position as first parameter to updateDate Using column name as first parameter to updateDate @@ -1861,9 +1747,7 @@ Using column name as first parameter to updateTimestamp Testing updateBlob on SQL type DATE Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type DATE Using column position as first parameter to updateBoolean Got expected exception : Illegal Conversion @@ -1874,14 +1758,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type DATE Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type DATE Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is TIME Testing updateShort on SQL type TIME Using column position as first parameter to updateShort @@ -1945,9 +1825,7 @@ Got expected exception : Illegal Conversion Testing updateClob on SQL type TIME Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type TIME Using column position as first parameter to updateDate Got expected exception : Illegal Conversion @@ -1961,9 +1839,7 @@ Using column name as first parameter to updateTimestamp Testing updateBlob on SQL type TIME Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type TIME Using column position as first parameter to updateBoolean Got expected exception : Illegal Conversion @@ -1974,14 +1850,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type TIME Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type TIME Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is TIMESTAMP Testing updateShort on SQL type TIMESTAMP Using column position as first parameter to updateShort @@ -2045,9 +1917,7 @@ Got expected exception : Illegal Conversion Testing updateClob on SQL type TIMESTAMP Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type TIMESTAMP Using column position as first parameter to updateDate Using column name as first parameter to updateDate @@ -2061,9 +1931,7 @@ Using column name as first parameter to updateTimestamp Testing updateBlob on SQL type TIMESTAMP Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type TIMESTAMP Using column position as first parameter to updateBoolean Got expected exception : Illegal Conversion @@ -2074,14 +1942,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type TIMESTAMP Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type TIMESTAMP Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Next datatype to test is BLOB(1k) Testing updateShort on SQL type BLOB(1k) Using column position as first parameter to updateShort @@ -2141,9 +2005,7 @@ Using column name as first parameter to updateBinaryStream Testing updateClob on SQL type BLOB(1k) Using column position as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateClob - Got expected exception : JDBC 3 method called - not yet supported Testing updateDate on SQL type BLOB(1k) Using column position as first parameter to updateDate Got expected exception : Illegal Conversion @@ -2161,9 +2023,7 @@ Got expected exception : Illegal Conversion Testing updateBlob on SQL type BLOB(1k) Using column position as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateBlob - Got expected exception : JDBC 3 method called - not yet supported Testing updateBoolean on SQL type BLOB(1k) Using column position as first parameter to updateBoolean Got expected exception : Illegal Conversion @@ -2174,14 +2034,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type BLOB(1k) Using column position as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateArray - Got expected exception : JDBC 3 method called - not yet supported Testing updateRef on SQL type BLOB(1k) Using column position as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Using column name as first parameter to updateRef - Got expected exception : JDBC 3 method called - not yet supported Positive Test22 - Test updateObject method Next datatype to test is SMALLINT updateObject with column position & Short object as parameters @@ -2204,10 +2060,6 @@ Got expected exception : Illegal Conversion updateObject with column name & bytes[] array as parameters Got expected exception : Illegal Conversion - updateObject with column position & Clob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Clob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Date object as parameters Got expected exception : Illegal Conversion updateObject with column name & Date object as parameters @@ -2220,10 +2072,6 @@ Got expected exception : Illegal Conversion updateObject with column name & TimeStamp object as parameters Got expected exception : Illegal Conversion - updateObject with column position & Blob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Blob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2251,10 +2099,6 @@ Got expected exception : Illegal Conversion updateObject with column name & bytes[] array as parameters Got expected exception : Illegal Conversion - updateObject with column position & Clob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Clob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Date object as parameters Got expected exception : Illegal Conversion updateObject with column name & Date object as parameters @@ -2267,10 +2111,6 @@ Got expected exception : Illegal Conversion updateObject with column name & TimeStamp object as parameters Got expected exception : Illegal Conversion - updateObject with column position & Blob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Blob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2298,10 +2138,6 @@ Got expected exception : Illegal Conversion updateObject with column name & bytes[] array as parameters Got expected exception : Illegal Conversion - updateObject with column position & Clob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Clob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Date object as parameters Got expected exception : Illegal Conversion updateObject with column name & Date object as parameters @@ -2314,10 +2150,6 @@ Got expected exception : Illegal Conversion updateObject with column name & TimeStamp object as parameters Got expected exception : Illegal Conversion - updateObject with column position & Blob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Blob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2345,10 +2177,6 @@ Got expected exception : Illegal Conversion updateObject with column name & bytes[] array as parameters Got expected exception : Illegal Conversion - updateObject with column position & Clob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Clob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Date object as parameters Got expected exception : Illegal Conversion updateObject with column name & Date object as parameters @@ -2361,10 +2189,6 @@ Got expected exception : Illegal Conversion updateObject with column name & TimeStamp object as parameters Got expected exception : Illegal Conversion - updateObject with column position & Blob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Blob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2390,10 +2214,6 @@ Got expected exception : Illegal Conversion updateObject with column name & bytes[] array as parameters Got expected exception : Illegal Conversion - updateObject with column position & Clob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Clob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Date object as parameters Got expected exception : Illegal Conversion updateObject with column name & Date object as parameters @@ -2406,10 +2226,6 @@ Got expected exception : Illegal Conversion updateObject with column name & TimeStamp object as parameters Got expected exception : Illegal Conversion - updateObject with column position & Blob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Blob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2435,10 +2251,6 @@ Got expected exception : Illegal Conversion updateObject with column name & bytes[] array as parameters Got expected exception : Illegal Conversion - updateObject with column position & Clob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Clob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Date object as parameters Got expected exception : Illegal Conversion updateObject with column name & Date object as parameters @@ -2451,10 +2263,6 @@ Got expected exception : Illegal Conversion updateObject with column name & TimeStamp object as parameters Got expected exception : Illegal Conversion - updateObject with column position & Blob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Blob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2480,18 +2288,12 @@ Got expected exception : Illegal Conversion updateObject with column name & bytes[] array as parameters Got expected exception : Illegal Conversion - updateObject with column position & Clob object as parameters - updateObject with column name & Clob object as parameters updateObject with column position & Date object as parameters updateObject with column name & Date object as parameters updateObject with column position & Time object as parameters updateObject with column name & Time object as parameters updateObject with column position & TimeStamp object as parameters updateObject with column name & TimeStamp object as parameters - updateObject with column position & Blob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Blob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2517,18 +2319,12 @@ Got expected exception : Illegal Conversion updateObject with column name & bytes[] array as parameters Got expected exception : Illegal Conversion - updateObject with column position & Clob object as parameters - updateObject with column name & Clob object as parameters updateObject with column position & Date object as parameters updateObject with column name & Date object as parameters updateObject with column position & Time object as parameters updateObject with column name & Time object as parameters updateObject with column position & TimeStamp object as parameters updateObject with column name & TimeStamp object as parameters - updateObject with column position & Blob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Blob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2554,18 +2350,12 @@ Got expected exception : Illegal Conversion updateObject with column name & bytes[] array as parameters Got expected exception : Illegal Conversion - updateObject with column position & Clob object as parameters - updateObject with column name & Clob object as parameters updateObject with column position & Date object as parameters updateObject with column name & Date object as parameters updateObject with column position & Time object as parameters updateObject with column name & Time object as parameters updateObject with column position & TimeStamp object as parameters updateObject with column name & TimeStamp object as parameters - updateObject with column position & Blob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Blob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2603,10 +2393,6 @@ Got expected exception : Illegal Conversion updateObject with column position & bytes[] array as parameters updateObject with column name & bytes[] array as parameters - updateObject with column position & Clob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Clob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Date object as parameters Got expected exception : Illegal Conversion updateObject with column name & Date object as parameters @@ -2619,10 +2405,6 @@ Got expected exception : Illegal Conversion updateObject with column name & TimeStamp object as parameters Got expected exception : Illegal Conversion - updateObject with column position & Blob object as parameters - Got expected exception : A truncation error was encountered trying to shrink CHAR () FOR BIT DATA 'XX-RESOLVE-XX' to length 2. - updateObject with column name & Blob object as parameters - Got expected exception : A truncation error was encountered trying to shrink CHAR () FOR BIT DATA 'XX-RESOLVE-XX' to length 2. updateObject with column position & Boolean object as parameters Got expected exception : Illegal Conversion updateObject with column name & Boolean object as parameters @@ -2662,10 +2444,6 @@ Got expected exception : Illegal Conversion updateObject with column position & bytes[] array as parameters updateObject with column name & bytes[] array as parameters - updateObject with column position & Clob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Clob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Date object as parameters Got expected exception : Illegal Conversion updateObject with column name & Date object as parameters @@ -2678,10 +2456,6 @@ Got expected exception : Illegal Conversion updateObject with column name & TimeStamp object as parameters Got expected exception : Illegal Conversion - updateObject with column position & Blob object as parameters - Got expected exception : A truncation error was encountered trying to shrink VARCHAR () FOR BIT DATA 'XX-RESOLVE-XX' to length 2. - updateObject with column name & Blob object as parameters - Got expected exception : A truncation error was encountered trying to shrink VARCHAR () FOR BIT DATA 'XX-RESOLVE-XX' to length 2. updateObject with column position & Boolean object as parameters Got expected exception : Illegal Conversion updateObject with column name & Boolean object as parameters @@ -2721,10 +2495,6 @@ Got expected exception : Illegal Conversion updateObject with column position & bytes[] array as parameters updateObject with column name & bytes[] array as parameters - updateObject with column position & Clob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Clob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Date object as parameters Got expected exception : Illegal Conversion updateObject with column name & Date object as parameters @@ -2737,8 +2507,6 @@ Got expected exception : Illegal Conversion updateObject with column name & TimeStamp object as parameters Got expected exception : Illegal Conversion - updateObject with column position & Blob object as parameters - updateObject with column name & Blob object as parameters updateObject with column position & Boolean object as parameters Got expected exception : Illegal Conversion updateObject with column name & Boolean object as parameters @@ -2778,8 +2546,6 @@ Got expected exception : Illegal Conversion updateObject with column name & bytes[] array as parameters Got expected exception : Illegal Conversion - updateObject with column position & Clob object as parameters - updateObject with column name & Clob object as parameters updateObject with column position & Date object as parameters Got expected exception : Illegal Conversion updateObject with column name & Date object as parameters @@ -2792,10 +2558,6 @@ Got expected exception : Illegal Conversion updateObject with column name & TimeStamp object as parameters Got expected exception : Illegal Conversion - updateObject with column position & Blob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Blob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Boolean object as parameters Got expected exception : Illegal Conversion updateObject with column name & Boolean object as parameters @@ -2837,10 +2599,6 @@ Got expected exception : Illegal Conversion updateObject with column name & bytes[] array as parameters Got expected exception : Illegal Conversion - updateObject with column position & Clob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Clob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Date object as parameters updateObject with column name & Date object as parameters updateObject with column position & Time object as parameters @@ -2849,10 +2607,6 @@ Got expected exception : Illegal Conversion updateObject with column position & TimeStamp object as parameters updateObject with column name & TimeStamp object as parameters - updateObject with column position & Blob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Blob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Boolean object as parameters Got expected exception : Illegal Conversion updateObject with column name & Boolean object as parameters @@ -2894,10 +2648,6 @@ Got expected exception : Illegal Conversion updateObject with column name & bytes[] array as parameters Got expected exception : Illegal Conversion - updateObject with column position & Clob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Clob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Date object as parameters Got expected exception : Illegal Conversion updateObject with column name & Date object as parameters @@ -2906,10 +2656,6 @@ updateObject with column name & Time object as parameters updateObject with column position & TimeStamp object as parameters updateObject with column name & TimeStamp object as parameters - updateObject with column position & Blob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Blob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Boolean object as parameters Got expected exception : Illegal Conversion updateObject with column name & Boolean object as parameters @@ -2951,10 +2697,6 @@ Got expected exception : Illegal Conversion updateObject with column name & bytes[] array as parameters Got expected exception : Illegal Conversion - updateObject with column position & Clob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Clob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Date object as parameters updateObject with column name & Date object as parameters updateObject with column position & Time object as parameters @@ -2963,10 +2705,6 @@ Got expected exception : Illegal Conversion updateObject with column position & TimeStamp object as parameters updateObject with column name & TimeStamp object as parameters - updateObject with column position & Blob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Blob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Boolean object as parameters Got expected exception : Illegal Conversion updateObject with column name & Boolean object as parameters @@ -3006,10 +2744,6 @@ Got expected exception : Illegal Conversion updateObject with column position & bytes[] array as parameters updateObject with column name & bytes[] array as parameters - updateObject with column position & Clob object as parameters - Got expected exception : Illegal Conversion - updateObject with column name & Clob object as parameters - Got expected exception : Illegal Conversion updateObject with column position & Date object as parameters Got expected exception : Illegal Conversion updateObject with column name & Date object as parameters @@ -3022,8 +2756,6 @@ Got expected exception : Illegal Conversion updateObject with column name & TimeStamp object as parameters Got expected exception : Illegal Conversion - updateObject with column position & Blob object as parameters - updateObject with column name & Blob object as parameters updateObject with column position & Boolean object as parameters Got expected exception : Illegal Conversion updateObject with column name & Boolean object as parameters Index: java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out =================================================================== --- java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out (revision 355621) +++ java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out (working copy) @@ -586,9 +586,7 @@ Got expected exception : 'updateBinaryStream' not allowed because the ResultSet is not an updatable ResultSet. Test updateClob on a readonly resultset Using column position as first parameter to updateClob - Got expected exception : 'updateClob' not allowed because the ResultSet is not an updatable ResultSet. Using column name as first parameter to updateClob - Got expected exception : 'updateClob' not allowed because the ResultSet is not an updatable ResultSet. Test updateDate on a readonly resultset Using column position as first parameter to updateDate Got expected exception : 'updateDate' not allowed because the ResultSet is not an updatable ResultSet. @@ -606,9 +604,7 @@ Got expected exception : 'updateTimestamp' not allowed because the ResultSet is not an updatable ResultSet. Test updateBlob on a readonly resultset Using column position as first parameter to updateBlob - Got expected exception : 'updateBlob' not allowed because the ResultSet is not an updatable ResultSet. Using column name as first parameter to updateBlob - Got expected exception : 'updateBlob' not allowed because the ResultSet is not an updatable ResultSet. Test updateBoolean on a readonly resultset Using column position as first parameter to updateBoolean Got expected exception : 'updateBoolean' not allowed because the ResultSet is not an updatable ResultSet. @@ -621,14 +617,10 @@ Got expected exception : 'updateNull' not allowed because the ResultSet is not an updatable ResultSet. Test updateArray on a readonly resultset Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Test updateRef on a readonly resultset Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Positive Test21 - Test all updateXXX(excluding updateObject) methods on all the supported sql datatypes Next datatype to test is SMALLINT Testing updateShort on SQL type SMALLINT @@ -677,9 +669,7 @@ Got expected exception : An attempt was made to get a data value of type 'SMALLINT' from a data value of type 'java.io.InputStream'. Testing updateClob on SQL type SMALLINT Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'SMALLINT' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'SMALLINT' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type SMALLINT Using column position as first parameter to updateDate Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'SMALLINT'. @@ -697,9 +687,7 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'SMALLINT'. Testing updateBlob on SQL type SMALLINT Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'SMALLINT' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'SMALLINT' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type SMALLINT Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -708,14 +696,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type SMALLINT Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type SMALLINT Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is INTEGER Testing updateShort on SQL type INTEGER Using column position as first parameter to updateShort @@ -763,9 +747,7 @@ Got expected exception : An attempt was made to get a data value of type 'INTEGER' from a data value of type 'java.io.InputStream'. Testing updateClob on SQL type INTEGER Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'INTEGER' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'INTEGER' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type INTEGER Using column position as first parameter to updateDate Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'INTEGER'. @@ -783,9 +765,7 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'INTEGER'. Testing updateBlob on SQL type INTEGER Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'INTEGER' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'INTEGER' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type INTEGER Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -794,14 +774,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type INTEGER Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type INTEGER Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is BIGINT Testing updateShort on SQL type BIGINT Using column position as first parameter to updateShort @@ -849,9 +825,7 @@ Got expected exception : An attempt was made to get a data value of type 'BIGINT' from a data value of type 'java.io.InputStream'. Testing updateClob on SQL type BIGINT Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'BIGINT' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'BIGINT' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type BIGINT Using column position as first parameter to updateDate Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'BIGINT'. @@ -869,9 +843,7 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'BIGINT'. Testing updateBlob on SQL type BIGINT Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'BIGINT' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'BIGINT' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type BIGINT Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -880,14 +852,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type BIGINT Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type BIGINT Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is DECIMAL(10,5) Testing updateShort on SQL type DECIMAL(10,5) Using column position as first parameter to updateShort @@ -935,9 +903,7 @@ Got expected exception : An attempt was made to get a data value of type 'DECIMAL' from a data value of type 'java.io.InputStream'. Testing updateClob on SQL type DECIMAL(10,5) Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'DECIMAL' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'DECIMAL' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type DECIMAL(10,5) Using column position as first parameter to updateDate Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'DECIMAL'. @@ -955,9 +921,7 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'DECIMAL'. Testing updateBlob on SQL type DECIMAL(10,5) Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'DECIMAL' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'DECIMAL' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type DECIMAL(10,5) Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -966,14 +930,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type DECIMAL(10,5) Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type DECIMAL(10,5) Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is REAL Testing updateShort on SQL type REAL Using column position as first parameter to updateShort @@ -1021,9 +981,7 @@ Got expected exception : An attempt was made to get a data value of type 'REAL' from a data value of type 'java.io.InputStream'. Testing updateClob on SQL type REAL Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'REAL' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'REAL' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type REAL Using column position as first parameter to updateDate Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'REAL'. @@ -1041,9 +999,7 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'REAL'. Testing updateBlob on SQL type REAL Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'REAL' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'REAL' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type REAL Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -1052,14 +1008,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type REAL Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type REAL Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is DOUBLE Testing updateShort on SQL type DOUBLE Using column position as first parameter to updateShort @@ -1107,9 +1059,7 @@ Got expected exception : An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'java.io.InputStream'. Testing updateClob on SQL type DOUBLE Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type DOUBLE Using column position as first parameter to updateDate Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'DOUBLE'. @@ -1127,9 +1077,7 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'DOUBLE'. Testing updateBlob on SQL type DOUBLE Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type DOUBLE Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -1138,14 +1086,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type DOUBLE Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type DOUBLE Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is CHAR(60) Testing updateShort on SQL type CHAR(60) Using column position as first parameter to updateShort @@ -1187,9 +1131,7 @@ Got expected exception : An attempt was made to get a data value of type 'CHAR' from a data value of type 'java.io.InputStream'. Testing updateClob on SQL type CHAR(60) Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'CHAR' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'CHAR' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type CHAR(60) Using column position as first parameter to updateDate Using column name as first parameter to updateDate @@ -1201,9 +1143,7 @@ Using column name as first parameter to updateTimestamp Testing updateBlob on SQL type CHAR(60) Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'CHAR' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'CHAR' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type CHAR(60) Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -1212,14 +1152,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type CHAR(60) Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type CHAR(60) Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is VARCHAR(60) Testing updateShort on SQL type VARCHAR(60) Using column position as first parameter to updateShort @@ -1261,9 +1197,7 @@ Got expected exception : An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.io.InputStream'. Testing updateClob on SQL type VARCHAR(60) Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type VARCHAR(60) Using column position as first parameter to updateDate Using column name as first parameter to updateDate @@ -1275,9 +1209,7 @@ Using column name as first parameter to updateTimestamp Testing updateBlob on SQL type VARCHAR(60) Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type VARCHAR(60) Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -1286,14 +1218,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type VARCHAR(60) Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type VARCHAR(60) Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is LONG VARCHAR Testing updateShort on SQL type LONG VARCHAR Using column position as first parameter to updateShort @@ -1335,9 +1263,7 @@ Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR' from a data value of type 'java.io.InputStream'. Testing updateClob on SQL type LONG VARCHAR Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type LONG VARCHAR Using column position as first parameter to updateDate Using column name as first parameter to updateDate @@ -1349,9 +1275,7 @@ Using column name as first parameter to updateTimestamp Testing updateBlob on SQL type LONG VARCHAR Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type LONG VARCHAR Using column position as first parameter to updateBoolean Using column name as first parameter to updateBoolean @@ -1360,14 +1284,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type LONG VARCHAR Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type LONG VARCHAR Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is CHAR(2) FOR BIT DATA Testing updateShort on SQL type CHAR(2) FOR BIT DATA Using column position as first parameter to updateShort @@ -1427,9 +1347,7 @@ Using column name as first parameter to updateBinaryStream Testing updateClob on SQL type CHAR(2) FOR BIT DATA Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'CHAR () FOR BIT DATA' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'CHAR () FOR BIT DATA' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type CHAR(2) FOR BIT DATA Using column position as first parameter to updateDate Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'CHAR () FOR BIT DATA'. @@ -1447,9 +1365,7 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'CHAR () FOR BIT DATA'. Testing updateBlob on SQL type CHAR(2) FOR BIT DATA Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'CHAR () FOR BIT DATA' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'CHAR () FOR BIT DATA' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type CHAR(2) FOR BIT DATA Using column position as first parameter to updateBoolean Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'CHAR () FOR BIT DATA'. @@ -1460,14 +1376,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type CHAR(2) FOR BIT DATA Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type CHAR(2) FOR BIT DATA Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is VARCHAR(2) FOR BIT DATA Testing updateShort on SQL type VARCHAR(2) FOR BIT DATA Using column position as first parameter to updateShort @@ -1527,9 +1439,7 @@ Using column name as first parameter to updateBinaryStream Testing updateClob on SQL type VARCHAR(2) FOR BIT DATA Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'VARCHAR () FOR BIT DATA' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'VARCHAR () FOR BIT DATA' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type VARCHAR(2) FOR BIT DATA Using column position as first parameter to updateDate Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'VARCHAR () FOR BIT DATA'. @@ -1547,9 +1457,7 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'VARCHAR () FOR BIT DATA'. Testing updateBlob on SQL type VARCHAR(2) FOR BIT DATA Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'VARCHAR () FOR BIT DATA' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'VARCHAR () FOR BIT DATA' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type VARCHAR(2) FOR BIT DATA Using column position as first parameter to updateBoolean Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'VARCHAR () FOR BIT DATA'. @@ -1560,14 +1468,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type VARCHAR(2) FOR BIT DATA Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type VARCHAR(2) FOR BIT DATA Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is LONG VARCHAR FOR BIT DATA Testing updateShort on SQL type LONG VARCHAR FOR BIT DATA Using column position as first parameter to updateShort @@ -1627,9 +1531,7 @@ Using column name as first parameter to updateBinaryStream Testing updateClob on SQL type LONG VARCHAR FOR BIT DATA Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR FOR BIT DATA' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR FOR BIT DATA' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type LONG VARCHAR FOR BIT DATA Using column position as first parameter to updateDate Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'LONG VARCHAR FOR BIT DATA'. @@ -1647,9 +1549,7 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'LONG VARCHAR FOR BIT DATA'. Testing updateBlob on SQL type LONG VARCHAR FOR BIT DATA Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR FOR BIT DATA' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR FOR BIT DATA' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type LONG VARCHAR FOR BIT DATA Using column position as first parameter to updateBoolean Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'LONG VARCHAR FOR BIT DATA'. @@ -1660,14 +1560,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type LONG VARCHAR FOR BIT DATA Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type LONG VARCHAR FOR BIT DATA Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is CLOB(1k) Testing updateShort on SQL type CLOB(1k) Using column position as first parameter to updateShort @@ -1743,9 +1639,7 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'CLOB'. Testing updateBlob on SQL type CLOB(1k) Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'CLOB' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'CLOB' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type CLOB(1k) Using column position as first parameter to updateBoolean Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'CLOB'. @@ -1756,14 +1650,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type CLOB(1k) Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type CLOB(1k) Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is DATE Testing updateShort on SQL type DATE Using column position as first parameter to updateShort @@ -1827,9 +1717,7 @@ Got expected exception : An attempt was made to get a data value of type 'DATE' from a data value of type 'java.io.InputStream'. Testing updateClob on SQL type DATE Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'DATE' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'DATE' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type DATE Using column position as first parameter to updateDate Using column name as first parameter to updateDate @@ -1843,9 +1731,7 @@ Using column name as first parameter to updateTimestamp Testing updateBlob on SQL type DATE Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'DATE' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'DATE' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type DATE Using column position as first parameter to updateBoolean Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'DATE'. @@ -1856,14 +1742,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type DATE Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type DATE Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is TIME Testing updateShort on SQL type TIME Using column position as first parameter to updateShort @@ -1927,9 +1809,7 @@ Got expected exception : An attempt was made to get a data value of type 'TIME' from a data value of type 'java.io.InputStream'. Testing updateClob on SQL type TIME Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'TIME' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'TIME' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type TIME Using column position as first parameter to updateDate Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'TIME'. @@ -1943,9 +1823,7 @@ Using column name as first parameter to updateTimestamp Testing updateBlob on SQL type TIME Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'TIME' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'TIME' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type TIME Using column position as first parameter to updateBoolean Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'TIME'. @@ -1956,14 +1834,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type TIME Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type TIME Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is TIMESTAMP Testing updateShort on SQL type TIMESTAMP Using column position as first parameter to updateShort @@ -2027,9 +1901,7 @@ Got expected exception : An attempt was made to get a data value of type 'TIMESTAMP' from a data value of type 'java.io.InputStream'. Testing updateClob on SQL type TIMESTAMP Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'TIMESTAMP' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'TIMESTAMP' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type TIMESTAMP Using column position as first parameter to updateDate Using column name as first parameter to updateDate @@ -2041,9 +1913,7 @@ Using column name as first parameter to updateTimestamp Testing updateBlob on SQL type TIMESTAMP Using column position as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'TIMESTAMP' from a data value of type 'java.sql.Blob'. Using column name as first parameter to updateBlob - Got expected exception : An attempt was made to get a data value of type 'TIMESTAMP' from a data value of type 'java.sql.Blob'. Testing updateBoolean on SQL type TIMESTAMP Using column position as first parameter to updateBoolean Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'TIMESTAMP'. @@ -2054,14 +1924,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type TIMESTAMP Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type TIMESTAMP Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Next datatype to test is BLOB(1k) Testing updateShort on SQL type BLOB(1k) Using column position as first parameter to updateShort @@ -2121,9 +1987,7 @@ Using column name as first parameter to updateBinaryStream Testing updateClob on SQL type BLOB(1k) Using column position as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'BLOB' from a data value of type 'java.sql.Clob'. Using column name as first parameter to updateClob - Got expected exception : An attempt was made to get a data value of type 'BLOB' from a data value of type 'java.sql.Clob'. Testing updateDate on SQL type BLOB(1k) Using column position as first parameter to updateDate Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'BLOB'. @@ -2152,14 +2016,10 @@ Using column name as first parameter to updateNull Testing updateArray on SQL type BLOB(1k) Using column position as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateArray - Got expected exception : Feature not implemented: no details. Testing updateRef on SQL type BLOB(1k) Using column position as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Using column name as first parameter to updateRef - Got expected exception : Feature not implemented: no details. Positive Test22 - Test updateObject method Next datatype to test is SMALLINT updateObject with column position & Short object as parameters @@ -2180,10 +2040,6 @@ Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'SMALLINT'. updateObject with column name & bytes[] array as parameters Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'SMALLINT'. - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'SMALLINT' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'SMALLINT' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'SMALLINT'. updateObject with column name & Date object as parameters @@ -2196,10 +2052,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'SMALLINT'. updateObject with column name & TimeStamp object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'SMALLINT'. - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'SMALLINT' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'SMALLINT' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2223,10 +2075,6 @@ Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'INTEGER'. updateObject with column name & bytes[] array as parameters Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'INTEGER'. - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'INTEGER' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'INTEGER' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'INTEGER'. updateObject with column name & Date object as parameters @@ -2239,10 +2087,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'INTEGER'. updateObject with column name & TimeStamp object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'INTEGER'. - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'INTEGER' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'INTEGER' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2266,10 +2110,6 @@ Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'BIGINT'. updateObject with column name & bytes[] array as parameters Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'BIGINT'. - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'BIGINT' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'BIGINT' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'BIGINT'. updateObject with column name & Date object as parameters @@ -2282,10 +2122,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'BIGINT'. updateObject with column name & TimeStamp object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'BIGINT'. - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'BIGINT' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'BIGINT' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2309,10 +2145,6 @@ Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'DECIMAL'. updateObject with column name & bytes[] array as parameters Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'DECIMAL'. - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'DECIMAL' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'DECIMAL' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'DECIMAL'. updateObject with column name & Date object as parameters @@ -2325,10 +2157,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'DECIMAL'. updateObject with column name & TimeStamp object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'DECIMAL'. - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'DECIMAL' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'DECIMAL' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2352,10 +2180,6 @@ Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'REAL'. updateObject with column name & bytes[] array as parameters Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'REAL'. - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'REAL' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'REAL' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'REAL'. updateObject with column name & Date object as parameters @@ -2368,10 +2192,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'REAL'. updateObject with column name & TimeStamp object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'REAL'. - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'REAL' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'REAL' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2395,10 +2215,6 @@ Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'DOUBLE'. updateObject with column name & bytes[] array as parameters Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'DOUBLE'. - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'DOUBLE'. updateObject with column name & Date object as parameters @@ -2411,10 +2227,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'DOUBLE'. updateObject with column name & TimeStamp object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'DOUBLE'. - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2436,20 +2248,12 @@ updateObject with column name & String object as parameters updateObject with column position & bytes[] array as parameters updateObject with column name & bytes[] array as parameters - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'CHAR' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'CHAR' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters updateObject with column name & Date object as parameters updateObject with column position & Time object as parameters updateObject with column name & Time object as parameters updateObject with column position & TimeStamp object as parameters updateObject with column name & TimeStamp object as parameters - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'CHAR' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'CHAR' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2471,20 +2275,12 @@ updateObject with column name & String object as parameters updateObject with column position & bytes[] array as parameters updateObject with column name & bytes[] array as parameters - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters updateObject with column name & Date object as parameters updateObject with column position & Time object as parameters updateObject with column name & Time object as parameters updateObject with column position & TimeStamp object as parameters updateObject with column name & TimeStamp object as parameters - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2506,20 +2302,12 @@ updateObject with column name & String object as parameters updateObject with column position & bytes[] array as parameters updateObject with column name & bytes[] array as parameters - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters updateObject with column name & Date object as parameters updateObject with column position & Time object as parameters updateObject with column name & Time object as parameters updateObject with column position & TimeStamp object as parameters updateObject with column name & TimeStamp object as parameters - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters updateObject with column name & Boolean object as parameters updateObject with column position & null as parameters @@ -2555,10 +2343,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'CHAR () FOR BIT DATA'. updateObject with column position & bytes[] array as parameters updateObject with column name & bytes[] array as parameters - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'CHAR () FOR BIT DATA' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'CHAR () FOR BIT DATA' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'CHAR () FOR BIT DATA'. updateObject with column name & Date object as parameters @@ -2571,10 +2355,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'CHAR () FOR BIT DATA'. updateObject with column name & TimeStamp object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'CHAR () FOR BIT DATA'. - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'CHAR () FOR BIT DATA' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'CHAR () FOR BIT DATA' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'CHAR () FOR BIT DATA'. updateObject with column name & Boolean object as parameters @@ -2612,10 +2392,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'VARCHAR () FOR BIT DATA'. updateObject with column position & bytes[] array as parameters updateObject with column name & bytes[] array as parameters - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'VARCHAR () FOR BIT DATA' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'VARCHAR () FOR BIT DATA' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'VARCHAR () FOR BIT DATA'. updateObject with column name & Date object as parameters @@ -2628,10 +2404,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'VARCHAR () FOR BIT DATA'. updateObject with column name & TimeStamp object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'VARCHAR () FOR BIT DATA'. - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'VARCHAR () FOR BIT DATA' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'VARCHAR () FOR BIT DATA' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'VARCHAR () FOR BIT DATA'. updateObject with column name & Boolean object as parameters @@ -2669,10 +2441,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'LONG VARCHAR FOR BIT DATA'. updateObject with column position & bytes[] array as parameters updateObject with column name & bytes[] array as parameters - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR FOR BIT DATA' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR FOR BIT DATA' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'LONG VARCHAR FOR BIT DATA'. updateObject with column name & Date object as parameters @@ -2685,10 +2453,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'LONG VARCHAR FOR BIT DATA'. updateObject with column name & TimeStamp object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'LONG VARCHAR FOR BIT DATA'. - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR FOR BIT DATA' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'LONG VARCHAR FOR BIT DATA' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'LONG VARCHAR FOR BIT DATA'. updateObject with column name & Boolean object as parameters @@ -2726,8 +2490,6 @@ Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'CLOB'. updateObject with column name & bytes[] array as parameters Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'CLOB'. - updateObject with column position & Clob object as parameters - updateObject with column name & Clob object as parameters updateObject with column position & Date object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'CLOB'. updateObject with column name & Date object as parameters @@ -2740,10 +2502,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'CLOB'. updateObject with column name & TimeStamp object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'CLOB'. - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'CLOB' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'CLOB' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'CLOB'. updateObject with column name & Boolean object as parameters @@ -2783,10 +2541,6 @@ Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'DATE'. updateObject with column name & bytes[] array as parameters Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'DATE'. - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'DATE' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'DATE' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters updateObject with column name & Date object as parameters updateObject with column position & Time object as parameters @@ -2795,10 +2549,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Time' into a data value of type 'DATE'. updateObject with column position & TimeStamp object as parameters updateObject with column name & TimeStamp object as parameters - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'DATE' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'DATE' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'DATE'. updateObject with column name & Boolean object as parameters @@ -2838,10 +2588,6 @@ Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'TIME'. updateObject with column name & bytes[] array as parameters Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'TIME'. - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'TIME' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'TIME' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'TIME'. updateObject with column name & Date object as parameters @@ -2850,10 +2596,6 @@ updateObject with column name & Time object as parameters updateObject with column position & TimeStamp object as parameters updateObject with column name & TimeStamp object as parameters - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'TIME' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'TIME' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'TIME'. updateObject with column name & Boolean object as parameters @@ -2893,20 +2635,12 @@ Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'TIMESTAMP'. updateObject with column name & bytes[] array as parameters Got expected exception : An attempt was made to put a data value of type 'byte[]' into a data value of type 'TIMESTAMP'. - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'TIMESTAMP' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'TIMESTAMP' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters updateObject with column name & Date object as parameters updateObject with column position & Time object as parameters updateObject with column name & Time object as parameters updateObject with column position & TimeStamp object as parameters updateObject with column name & TimeStamp object as parameters - updateObject with column position & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'TIMESTAMP' from a data value of type 'java.sql.Blob'. - updateObject with column name & Blob object as parameters - Got expected exception : An attempt was made to get a data value of type 'TIMESTAMP' from a data value of type 'java.sql.Blob'. updateObject with column position & Boolean object as parameters Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'TIMESTAMP'. updateObject with column name & Boolean object as parameters @@ -2944,10 +2678,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'BLOB'. updateObject with column position & bytes[] array as parameters updateObject with column name & bytes[] array as parameters - updateObject with column position & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'BLOB' from a data value of type 'java.sql.Clob'. - updateObject with column name & Clob object as parameters - Got expected exception : An attempt was made to get a data value of type 'BLOB' from a data value of type 'java.sql.Clob'. updateObject with column position & Date object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'BLOB'. updateObject with column name & Date object as parameters @@ -2960,8 +2690,6 @@ Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'BLOB'. updateObject with column name & TimeStamp object as parameters Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'BLOB'. - updateObject with column position & Blob object as parameters - updateObject with column name & Blob object as parameters updateObject with column position & Boolean object as parameters Got expected exception : An attempt was made to put a data value of type 'boolean' into a data value of type 'BLOB'. updateObject with column name & Boolean object as parameters @@ -2984,8 +2712,6 @@ updateDate and then cancelRowUpdates updateTime and then cancelRowUpdates updateTimestamp and then cancelRowUpdates - updateClob and then cancelRowUpdates - updateBlob and then cancelRowUpdates Positive Test24a - after updateXXX, try cancelRowUpdates and then deleteRow column 1 on this row before updateInt is 1 column 1 on this row after updateInt is 234 Index: java/testing/org/apache/derbyTesting/functionTests/util/derby_tests.policy =================================================================== --- java/testing/org/apache/derbyTesting/functionTests/util/derby_tests.policy (revision 355621) +++ java/testing/org/apache/derbyTesting/functionTests/util/derby_tests.policy (working copy) @@ -47,9 +47,10 @@ // sane=true, jdbcapi/secureUsers1.sql permission java.io.FilePermission "${user.dir}${/}CloudLDAP.out", "write"; - // These permissions are needed to load the JCE for encryption with Sun JDK131. + // These permissions are needed to load the JCE for encryption with Sun and IBM JDK131. // JDK14 has the JCE preloaded permission java.security.SecurityPermission "insertProvider.SunJCE"; + permission java.security.SecurityPermission "insertProvider.IBMJCE"; }; @@ -157,9 +158,10 @@ // sane=true, jdbcapi/secureUsers1.sql permission java.io.FilePermission "${user.dir}${/}CloudLDAP.out", "write"; - // These permissions are needed to load the JCE for encryption with Sun JDK131. + // These permissions are needed to load the JCE for encryption with Sun and IBM JDK131. // JDK14 has the JCE preloaded permission java.security.SecurityPermission "insertProvider.SunJCE"; + permission java.security.SecurityPermission "insertProvider.IBMJCE"; // lang/errorStream.java permission java.lang.RuntimePermission "setIO"; ------=_Part_4242_17625109.1134171076186 Content-Type: application/octet-stream; name=jdk13tests.status Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jdk13tests.status" M java\testing\org\apache\derbyTesting\functionTests\tests\store\TestDurabilityProperty.java M java\testing\org\apache\derbyTesting\functionTests\tests\store\backupRestore1.java M java\testing\org\apache\derbyTesting\functionTests\master\DerbyNetClient\updatableResultSet.out M java\testing\org\apache\derbyTesting\functionTests\master\updatableResultSet.out M java\testing\org\apache\derbyTesting\functionTests\util\derby_tests.policy ------=_Part_4242_17625109.1134171076186--