You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by fu...@apache.org on 2005/07/01 19:28:54 UTC
svn commit: r208776 [4/7] - in /incubator/derby/code/branches/10.1: ./
java/client/org/apache/derby/client/am/ java/demo/simple/
java/engine/org/apache/derby/diag/ java/engine/org/apache/derby/iapi/jdbc/
java/engine/org/apache/derby/impl/load/ java/eng...
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out?rev=208776&r1=208775&r2=208776&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out Fri Jul 1 10:28:49 2005
@@ -565,9 +565,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.
@@ -585,9 +583,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.
@@ -600,14 +596,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
@@ -658,9 +650,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
@@ -678,9 +668,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
@@ -689,14 +677,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
@@ -746,9 +730,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
@@ -766,9 +748,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
@@ -777,14 +757,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
@@ -834,9 +810,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
@@ -854,9 +828,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
@@ -865,14 +837,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
@@ -922,9 +890,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
@@ -942,9 +908,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
@@ -953,14 +917,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
@@ -1008,9 +968,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
@@ -1028,9 +986,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
@@ -1039,14 +995,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
@@ -1094,9 +1046,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
@@ -1114,9 +1064,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
@@ -1125,14 +1073,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
@@ -1176,9 +1120,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
@@ -1190,9 +1132,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
@@ -1201,14 +1141,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
@@ -1252,9 +1188,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
@@ -1266,9 +1200,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
@@ -1277,14 +1209,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
@@ -1328,9 +1256,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
@@ -1342,9 +1268,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
@@ -1353,14 +1277,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
@@ -1420,9 +1340,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
@@ -1440,9 +1358,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
@@ -1453,14 +1369,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
@@ -1520,9 +1432,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
@@ -1540,9 +1450,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
@@ -1553,14 +1461,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
@@ -1620,9 +1524,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
@@ -1640,9 +1542,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
@@ -1653,14 +1553,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
@@ -1718,9 +1614,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
@@ -1738,9 +1632,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
@@ -1751,14 +1643,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
@@ -1822,9 +1710,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
@@ -1838,9 +1724,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
@@ -1851,14 +1735,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
@@ -1922,9 +1802,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
@@ -1938,9 +1816,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
@@ -1951,14 +1827,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
@@ -2022,9 +1894,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
@@ -2038,9 +1908,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
@@ -2051,14 +1919,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
@@ -2118,9 +1982,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
@@ -2138,9 +2000,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
@@ -2151,14 +2011,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
@@ -2181,10 +2037,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
@@ -2197,10 +2049,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
@@ -2228,10 +2076,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
@@ -2244,10 +2088,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
@@ -2275,10 +2115,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
@@ -2291,10 +2127,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
@@ -2322,10 +2154,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
@@ -2338,10 +2166,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
@@ -2367,10 +2191,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
@@ -2383,10 +2203,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
@@ -2412,10 +2228,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
@@ -2428,10 +2240,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
@@ -2457,18 +2265,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
@@ -2494,18 +2296,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
@@ -2531,18 +2327,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
@@ -2580,10 +2370,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
@@ -2596,10 +2382,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
@@ -2639,10 +2421,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
@@ -2655,10 +2433,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
@@ -2698,10 +2472,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
@@ -2714,8 +2484,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
@@ -2755,8 +2523,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
@@ -2769,10 +2535,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
@@ -2814,10 +2576,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
@@ -2826,10 +2584,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
@@ -2871,10 +2625,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
@@ -2883,10 +2633,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
@@ -2928,10 +2674,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
@@ -2940,10 +2682,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
@@ -2983,10 +2721,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
@@ -2999,8 +2733,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
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out?rev=208776&r1=208775&r2=208776&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out Fri Jul 1 10:28:49 2005
@@ -14,7 +14,7 @@
1 row inserted/updated/deleted
ij> insert into tab1 values(50.395, date('2000-11-29'), 'test row 6');
1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'tab1' , 'extinout/tab1_fr.unl' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'TAB1' , 'extinout/tab1_fr.unl' ,
null, null, 'UTF8') ;
0 rows inserted/updated/deleted
ij> -- localized display is off
@@ -41,7 +41,7 @@
0 rows inserted/updated/deleted
ij> create table tab1( c1 decimal(5,3), c2 date, c3 char(20) );
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'tab1' , 'extinout/tab1_fr.unl' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'TAB1' , 'extinout/tab1_fr.unl' ,
null, null, 'UTF8', 0) ;
0 rows inserted/updated/deleted
ij> -- localized display is off
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/UnicodeEscape_JP.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/UnicodeEscape_JP.out?rev=208776&r1=208775&r2=208776&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/UnicodeEscape_JP.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/UnicodeEscape_JP.out Fri Jul 1 10:28:49 2005
@@ -50,7 +50,7 @@
13 |15:34:29|\u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002
15 |15:35:35|sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002
16 |15:39:10|\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 8\u79&
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('APP', 'jtest' , 'extout/jtest.unl' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('APP', 'JTEST' , 'extout/jtest.unl' ,
null, null,'EUC_JP') ;
0 rows inserted/updated/deleted
ij>
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/checkDataSource30.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/checkDataSource30.out?rev=208776&r1=208775&r2=208776&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/checkDataSource30.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/checkDataSource30.out Fri Jul 1 10:28:49 2005
@@ -225,7 +225,7 @@
EmbeddedXADataSource <closedstmt>.execute() XJ012 - 'Statement' already closed.
EVENT(5):connectionClosed
Running JDBC 3.0 connection checks on Global EmbeddedXADataSource
- holdability true
+ holdability false
JDBC 3.0 savepoint SQL Exception: Cannot rollback a global transaction using the Connection, commit processing must go thru XAResource interface.
Running connection checks on Global EmbeddedXADataSource
isolation level 2
@@ -240,7 +240,7 @@
Global EmbeddedXADataSource <closedconn>.createStatement() 08003 - No current connection.
Global EmbeddedXADataSource <closedstmt>.execute() XJ012 - 'Statement' already closed.
Running JDBC 3.0 connection checks on Global EmbeddedXADataSource
- holdability true
+ holdability false
JDBC 3.0 savepoint SQL Exception: Cannot rollback a global transaction using the Connection, commit processing must go thru XAResource interface.
Running connection checks on Global EmbeddedXADataSource
isolation level 2
@@ -303,7 +303,7 @@
Switch to global EmbeddedXADataSource <closedconn>.createStatement() 08003 - No current connection.
Switch to global EmbeddedXADataSource <closedstmt>.execute() XJ012 - 'Statement' already closed.
Running JDBC 3.0 connection checks on Switch to global EmbeddedXADataSource
- holdability true
+ holdability false
JDBC 3.0 savepoint SQL Exception: Cannot rollback a global transaction using the Connection, commit processing must go thru XAResource interface.
Running connection checks on Switch to global EmbeddedXADataSource
isolation level 2
@@ -361,7 +361,7 @@
read only false
EVENT(6):connectionClosed
re-join with new handle X1
- holdability true
+ holdability false
isolation level READ_UNCOMMITTED
auto commit false
read only true
@@ -372,7 +372,7 @@
auto commit true
read only false
pre-X1 commit - X1
- holdability true
+ holdability false
isolation level READ_UNCOMMITTED
auto commit false
read only true
@@ -721,9 +721,7 @@
Notice that autocommit now is false for connection because it is part of the global transaction
Notice that connection's holdability at this point is CLOSE_CURSORS_AT_COMMIT because it is part of the global transaction
CONNECTION(in xa transaction) HOLDABILITY false
-This is a bug. Connection's holdability should have been CLOSE_CURSORS_AT_COMMIT since it is in the global transaction
-Have reported this on Derby dev-list
-CONNECTION(in xa transaction) HOLDABILITY true
+CONNECTION(in xa transaction) HOLDABILITY false
Autocommit on Connection inside global transaction has been set correctly to false
CONNECTION(non-xa) HOLDABILITY false
STATEMENT HOLDABILITY false
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests.out?rev=208776&r1=208775&r2=208776&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests.out Fri Jul 1 10:28:49 2005
@@ -7,16 +7,16 @@
7 rows inserted/updated/deleted
ij> --export error cases
--export can not create file
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'nodir/t1.dat' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'nodir/t1.dat' ,
null, null, null) ;
ERROR XIE0I: An IOException occurred while writing data to the file.
ij> --export table not found
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 'NOTABLE' , 'extinout/t1.dat' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'NOTABLE' , 'extinout/t1.dat' ,
null, null, null) ;
ERROR 38000: The exception 'SQL Exception: Table 'IEP.NOTABLE' does not exist.' was thrown while evaluating an expression.
ERROR 42X05: Table 'IEP.NOTABLE' does not exist.
ij> ---export schema is not valid
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('XXXX', 't1' , 'extinout/t1.dat' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('XXXX', 'T1' , 'extinout/t1.dat' ,
null, null, null) ;
ERROR 38000: The exception 'SQL Exception: Schema 'XXXX' does not exist' was thrown while evaluating an expression.
ERROR 42Y07: Schema 'XXXX' does not exist
@@ -29,52 +29,52 @@
call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from iep.t1',
'extinout/t1.dat' , null, null, 'NOSUCHCODESET') ;
ERROR XIE0I: An IOException occurred while writing data to the file.
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('XXXX', 't1' , 'extinout/t1.dat' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('XXXX', 'T1' , 'extinout/t1.dat' ,
null, null, null) ;
ERROR 38000: The exception 'SQL Exception: Schema 'XXXX' does not exist' was thrown while evaluating an expression.
ERROR 42Y07: Schema 'XXXX' does not exist
ij> --export delimiter errror cases
--period can not be used as character ot column delimiter
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' ,
null, '.', null) ;
ERROR XIE0K: The period was specified as a character string delimiter.
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' ,
'.', null, null) ;
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> --same delimter can not be used as character and column delimters
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' ,
';', ';', null) ;
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> --space character can not be a delimiter
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' ,
' ', ';', null) ;
ERROR XIE0J: A delimiter is not valid or is used more than once.
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' ,
null, ' ', null) ;
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> --if emtry strinng is passed actual value delimiter should be space
--and the that should become a invalid delimiter
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' ,
'', ';', null) ;
ERROR XIE0J: A delimiter is not valid or is used more than once.
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' ,
null, '', null) ;
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> --more than one character passed to the delimiters get truncated to one
--following one should give error because eventually '\' delimiter
--is used a both for char and col
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' ,
'\a', '\', null) ;
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> --DO A VALID EXPORT AND IMPORT
set schema iep;
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' ,
null, null, 'utf-8') ;
0 rows inserted/updated/deleted
ij> delete from t1 ;
7 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE('iep', 't1' , 'extinout/t1.dat' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE('IEP', 'T1' , 'extinout/t1.dat' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> select * from t1;
@@ -89,21 +89,21 @@
106
ij> --import error cases
--import can not find input file
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE('iep', 't1' , 'nodir/t1.dat' ,
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE('IEP', 'T1' , 'nodir/t1.dat' ,
null, null, null, 0) ;
ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
ERROR XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'.
ERROR XIE04: Data file not found: nodir/t1.dat
ij> --import table not found
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 'NOTABLE' , 'extinout/t1.dat' ,
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'NOTABLE' , 'extinout/t1.dat' ,
null, null, null, 0) ;
ERROR XIE0M: Table 'IEP.NOTABLE' does not exist.
ij> --import schema is not valid
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('XXXX', 't1' , 'extinout/t1.dat' ,
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('XXXX', 'T1' , 'extinout/t1.dat' ,
null, null, null, 0) ;
ERROR XIE0M: Table 'XXXX.T1' does not exist.
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' ,
null, null, 'INCORRECTCODESET', 0) ;
ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
@@ -112,20 +112,20 @@
ij> --check import with invalid delimiter usage
--if emtry strinng is passed actual value delimiter should be space
--and the that should become a invalid delimiter
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' ,
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' ,
'', ';', null, 0) ;
ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
ERROR XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'.
ERROR XIE0J: A delimiter is not valid or is used more than once.
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' ,
null, '', null, 0) ;
ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
ERROR XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'.
ERROR XIE0J: A delimiter is not valid or is used more than once.
ij> --same delimter can not be used as character and column delimters
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' ,
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' ,
';', ';', null, 1) ;
ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
@@ -148,7 +148,7 @@
5
6
ij> --export to from a temporary table
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('session', 'temp1' , 'extinout/temp1.dat' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('SESSION', 'TEMP1' , 'extinout/temp1.dat' ,
null, null, null) ;
0 rows inserted/updated/deleted
ij> -- because temporary table has on commit preserve rows, commit issued by export will not delete data from the temp table.
@@ -162,7 +162,7 @@
5
6
ij> --import back to a regualr table
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 'v1' , 'extinout/temp1.dat' ,
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'V1' , 'extinout/temp1.dat' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> select * from v1;
@@ -178,7 +178,7 @@
ij> --import to a temp table should fail with a table not found errror
declare global temporary table session.temp2(c1 int) not logged;
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('session', 'temp2' , 'extinout/temp1.dat' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('SESSION', 'TEMP2' , 'extinout/temp1.dat' ,
null, null, null, 0) ;
ERROR XIE0M: Table 'SESSION.TEMP2' does not exist.
ij> select * from session.temp2 ;
@@ -197,10 +197,10 @@
1 row inserted/updated/deleted
ij> insert into t3 values(4 , 3.5 , 8.6 , 'test strings');
1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't3' , 'extinout/t3.dat' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T3' , 'extinout/t3.dat' ,
null, null, null) ;
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 't3' , 'extinout/t3.dat' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T3' , 'extinout/t3.dat' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> select * from t3;
@@ -215,26 +215,26 @@
3 |3.5 |8 |test strings
4 |3.5 |8 |test strings
ij> --import data column names are incorrect
-call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , 'x1, x2, x3, x4', null,
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'X1, X2, X3, X4', null,
'extinout/t3.dat' ,
null, null, null, 0) ;
-ERROR XIE08: There is no column named: x1.
-ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , 'x1, x2, x3', '1,2,3,4',
+ERROR XIE08: There is no column named: X1.
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'X1, X2, X3', '1,2,3,4',
'extinout/t3.dat' ,
null, null, null, 0) ;
-ERROR XIE08: There is no column named: x1.
+ERROR XIE08: There is no column named: X1.
ij> --import data insert column names count < column indexes does not match
-call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , 'c1, c2, c3', '1,2,3,4',
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'C1, C2, C3', '1,2,3,4',
'extinout/t3.dat' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> --import data column indexes count > insert columns count
-call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , 'c1, c2, c3,c4', '1,2',
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'C1, C2, C3,C4', '1,2',
'extinout/t3.dat' ,
null, null, null, 0) ;
ERROR 38000: The exception 'SQL Exception: The number of values assigned is not the same as the number of specified or implied columns.' was thrown while evaluating an expression.
ERROR 42802: The number of values assigned is not the same as the number of specified or implied columns.
-ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , null, '11,22,12,24',
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , null, '11,22,12,24',
'extinout/t3.dat' ,
null, null, null, 0) ;
ERROR 38000: The exception 'SQL Exception: Column 'COLUMN11' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'COLUMN11' is not a column in the target table.' was thrown while evaluating an expression.
@@ -242,31 +242,31 @@
ij> --repeat the above type cases with empty file and minor variation to paramters
delete from t3 ;
12 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't3' , 'extinout/t3.dat' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T3' , 'extinout/t3.dat' ,
';', '^', 'utf-16') ;
0 rows inserted/updated/deleted
ij> --import data column names are incorrect
-call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , 'x1, x2, x3, x4', null,
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'X1, X2, X3, X4', null,
'extinout/t3.dat' ,
';', '^', 'utf-16', 1) ;
-ERROR XIE08: There is no column named: x1.
-ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , 'x1, x2, x3', '1,2,3,4',
+ERROR XIE08: There is no column named: X1.
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'X1, X2, X3', '1,2,3,4',
'extinout/t3.dat' ,
';', '^', 'utf-16', 1) ;
-ERROR XIE08: There is no column named: x1.
+ERROR XIE08: There is no column named: X1.
ij> --import data insert column names count < column indexes does not match
-call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , 'c1, c2, c3', null,
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'C1, C2, C3', null,
'extinout/t3.dat' ,
';', '^', 'utf-16', 1) ;
0 rows inserted/updated/deleted
ij> --import data column indexes count > insert columns count
-call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , null, '1,2',
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , null, '1,2',
'extinout/t3.dat' ,
';', '^', 'utf-16', 1) ;
ERROR 38000: The exception 'SQL Exception: The number of values assigned is not the same as the number of specified or implied columns.' was thrown while evaluating an expression.
ERROR 42802: The number of values assigned is not the same as the number of specified or implied columns.
ij> --specify column indexes that are not there in the file that is being imported
-call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , null, '11,22,12,24',
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , null, '11,22,12,24',
'extinout/t3.dat' ,
';', '^', 'utf-16', 1) ;
0 rows inserted/updated/deleted
@@ -280,17 +280,17 @@
0 rows inserted/updated/deleted
ij> create table ntype1(bt BLOB(1024) , a int);
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 'ntype' , 'extinout/ntype.dat' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'NTYPE' , 'extinout/ntype.dat' ,
null, null, null) ;
ERROR XIE0B: Column 'CT' in the table is of type CLOB, it is not supported by the import/export feature.
ij> call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from iep.ntype1',
'extinout/ntype.dat' ,
null, null, null) ;
ERROR XIE0B: Column 'BT' in the table is of type BLOB, it is not supported by the import/export feature.
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 'ntype' , 'extinout/ntype.dat' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'NTYPE' , 'extinout/ntype.dat' ,
null, null, null, 0) ;
ERROR XIE0B: Column 'CT' in the table is of type CLOB, it is not supported by the import/export feature.
-ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 'ntype1' , null , null,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'NTYPE1' , null , null,
'extinout/ntype.dat' ,
null, null, null, 0) ;
ERROR XIE0B: Column 'BT' in the table is of type BLOB, it is not supported by the import/export feature.
@@ -313,7 +313,7 @@
ij(C2)> --following import should fail with lock time out
call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.locks.waitTimeout', '5');
0 rows inserted/updated/deleted
-ij(C2)> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('iep', 'parent', 'extinout/parent.del',null, null, null,1);
+ij(C2)> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('IEP', 'PARENT', 'extinout/parent.del',null, null, null,1);
ERROR 38000: The exception 'SQL Exception: Table 'IEP.PARENT' cannot be locked in 'EXCLUSIVE' mode.' was thrown while evaluating an expression.
ERROR X0X02: Table 'IEP.PARENT' cannot be locked in 'EXCLUSIVE' mode.
ERROR 40XL1: A lock could not be obtained within the time requested