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 da...@apache.org on 2006/04/20 06:59:34 UTC
svn commit: r395484 [2/2] - in /db/derby/code/trunk:
java/build/org/apache/derbyBuild/ java/client/org/apache/derby/client/am/
java/client/org/apache/derby/client/net/ java/engine/org/apache/derby/loc/
java/shared/org/apache/derby/shared/common/referen...
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/parameterMapping.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/parameterMapping.out?rev=395484&r1=395483&r2=395484&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/parameterMapping.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/parameterMapping.out Wed Apr 19 21:59:30 2006
@@ -131,7 +131,7 @@
setTimestamp(null) getShort=0 was null true CLOUD EXT (OK)
setTimestamp(null) as batch getShort=0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type SMALLINT. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type SMALLINT. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type SMALLINT. JDBC MATCH (INVALID)
setAsciiStream(null) getShort=0 was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getShort=0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -304,7 +304,7 @@
setTimestamp(null) getInt=0 was null true CLOUD EXT (OK)
setTimestamp(null) as batch getInt=0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type INTEGER. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type INTEGER. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type INTEGER. JDBC MATCH (INVALID)
setAsciiStream(null) getInt=0 was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getInt=0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -477,7 +477,7 @@
setTimestamp(null) getLong=0 was null true CLOUD EXT (OK)
setTimestamp(null) as batch getLong=0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type BIGINT. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type BIGINT. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type BIGINT. JDBC MATCH (INVALID)
setAsciiStream(null) getLong=0 was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getLong=0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -650,7 +650,7 @@
setTimestamp(null) getFloat=0.0 was null true CLOUD EXT (OK)
setTimestamp(null) as batch getFloat=0.0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type REAL. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type REAL. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type REAL. JDBC MATCH (INVALID)
setAsciiStream(null) getFloat=0.0 was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getFloat=0.0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -824,7 +824,7 @@
setTimestamp(null) getDouble=0.0 was null true CLOUD EXT (OK)
setTimestamp(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
setAsciiStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -997,7 +997,7 @@
setTimestamp(null) getDouble=0.0 was null true CLOUD EXT (OK)
setTimestamp(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
setAsciiStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1170,7 +1170,7 @@
setTimestamp(null) getBigDecimal=null was null true CLOUD EXT (OK)
setTimestamp(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type DECIMAL. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type DECIMAL. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type DECIMAL. JDBC MATCH (INVALID)
setAsciiStream(null) getBigDecimal=null was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1891,7 +1891,7 @@
setObject(null) OK Type is not supported.
setObject(null) as batch OK Type is not supported.
setObject(java.lang.String) (XCL12):An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'VARCHAR () FOR BIT DATA'. JDBC FAIL VARCHAR(60) FOR BIT DATA
- setObject(java.lang.String) as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'VARCHAR () FOR BIT DATA'. JDBC FAIL VARCHAR(60) FOR BIT DATA
+ setObject(java.lang.String) as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'VARCHAR () FOR BIT DATA'. JDBC FAIL VARCHAR(60) FOR BIT DATA
setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
@@ -2021,7 +2021,7 @@
setBoolean() IC JDBC MATCH (INVALID)
setBoolean() as batch IC JDBC MATCH (INVALID)
setString() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
- setString() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
+ setString() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
setString(null) getDate=null was null true JDBC MATCH(OK)
setString(null) as batch getDate=null was null true JDBC MATCH(OK)
setString("Invalid Value") IC (Expected)
@@ -2042,7 +2042,7 @@
setTimestamp(null) getDate=null was null true JDBC MATCH(OK)
setTimestamp(null) as batch getDate=null was null true JDBC MATCH(OK)
setAsciiStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setAsciiStream(null) getDate=null was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getDate=null was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2050,11 +2050,11 @@
setBinaryStream(null) getDate=null was null true CLOUD EXT (OK)
setBinaryStream(null) as batch getDate=null was null true CLOUD EXT (OK)
setCharacterStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setCharacterStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setCharacterStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setCharacterStream(null) getDate=null was null true CLOUD EXT (OK)
setCharacterStream(null) as batch getDate=null was null true CLOUD EXT (OK)
setClob() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setClob() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setClob() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setClob(null) getDate=null was null true CLOUD EXT (OK)
setClob(null) as batch getDate=null was null true CLOUD EXT (OK)
setBlob() IC JDBC MATCH (INVALID)
@@ -2066,7 +2066,7 @@
setObject(null) OK Type is not supported.
setObject(null) as batch OK Type is not supported.
setObject(java.lang.String) (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
- setObject(java.lang.String) as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
+ setObject(java.lang.String) as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
@@ -2194,7 +2194,7 @@
setBoolean() IC JDBC MATCH (INVALID)
setBoolean() as batch IC JDBC MATCH (INVALID)
setString() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
- setString() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
+ setString() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
setString(null) getTime=null was null true JDBC MATCH(OK)
setString(null) as batch getTime=null was null true JDBC MATCH(OK)
setString("Invalid Value") IC (Expected)
@@ -2215,7 +2215,7 @@
setTimestamp(null) getTime=null was null true JDBC MATCH(OK)
setTimestamp(null) as batch getTime=null was null true JDBC MATCH(OK)
setAsciiStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setAsciiStream(null) getTime=null was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getTime=null was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2223,11 +2223,11 @@
setBinaryStream(null) getTime=null was null true CLOUD EXT (OK)
setBinaryStream(null) as batch getTime=null was null true CLOUD EXT (OK)
setCharacterStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setCharacterStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setCharacterStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setCharacterStream(null) getTime=null was null true CLOUD EXT (OK)
setCharacterStream(null) as batch getTime=null was null true CLOUD EXT (OK)
setClob() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setClob() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setClob() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setClob(null) getTime=null was null true CLOUD EXT (OK)
setClob(null) as batch getTime=null was null true CLOUD EXT (OK)
setBlob() IC JDBC MATCH (INVALID)
@@ -2239,7 +2239,7 @@
setObject(null) OK Type is not supported.
setObject(null) as batch OK Type is not supported.
setObject(java.lang.String) (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
- setObject(java.lang.String) as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
+ setObject(java.lang.String) as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
@@ -2367,7 +2367,7 @@
setBoolean() IC JDBC MATCH (INVALID)
setBoolean() as batch IC JDBC MATCH (INVALID)
setString() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
- setString() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
+ setString() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
setString(null) getTimestamp=null was null true JDBC MATCH(OK)
setString(null) as batch getTimestamp=null was null true JDBC MATCH(OK)
setString("Invalid Value") IC (Expected)
@@ -2388,7 +2388,7 @@
setTimestamp(null) getTimestamp=null was null true JDBC MATCH(OK)
setTimestamp(null) as batch getTimestamp=null was null true JDBC MATCH(OK)
setAsciiStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setAsciiStream(null) getTimestamp=null was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getTimestamp=null was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2396,11 +2396,11 @@
setBinaryStream(null) getTimestamp=null was null true CLOUD EXT (OK)
setBinaryStream(null) as batch getTimestamp=null was null true CLOUD EXT (OK)
setCharacterStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setCharacterStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setCharacterStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setCharacterStream(null) getTimestamp=null was null true CLOUD EXT (OK)
setCharacterStream(null) as batch getTimestamp=null was null true CLOUD EXT (OK)
setClob() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setClob() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setClob() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setClob(null) getTimestamp=null was null true CLOUD EXT (OK)
setClob(null) as batch getTimestamp=null was null true CLOUD EXT (OK)
setBlob() IC JDBC MATCH (INVALID)
@@ -2412,7 +2412,7 @@
setObject(null) OK Type is not supported.
setObject(null) as batch OK Type is not supported.
setObject(java.lang.String) (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
- setObject(java.lang.String) as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
+ setObject(java.lang.String) as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/procedure.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/procedure.out?rev=395484&r1=395483&r2=395484&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/procedure.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/procedure.out Wed Apr 19 21:59:30 2006
@@ -271,7 +271,7 @@
A |B |C
-----
70 |831 |45.700
-EXPECTED SQL Exception: BigDecimal conversion exception [converters] Overflow occurred during numeric data type conversion of "10243".. See attached Throwable.
+EXPECTED SQL Exception: Overflow occurred during numeric data type conversion of '10243' to packed decimal.
A |B |C
-----
80 |993 |1234.567
@@ -352,7 +352,7 @@
No ResultSet or update count returned
OP4INOUT 9+23.505 >32.50< null ? false
EXPECTED SQL Exception: The resulting value is outside the range for the data type DECIMAL/NUMERIC(4,2).
-EXPECTED SQL Exception: BigDecimal conversion exception [converters] Overflow occurred during numeric data type conversion of "102.33".. See attached Throwable.
+EXPECTED SQL Exception: Overflow occurred during numeric data type conversion of '102.33' to packed decimal.
EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized.
SQL Control
CREATE PROCEDURE SQLC.SQLCONTROL1_0 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128)) PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl'
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/updatableResultSet.out?rev=395484&r1=395483&r2=395484&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/updatableResultSet.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/updatableResultSet.out Wed Apr 19 21:59:30 2006
@@ -272,15 +272,15 @@
But it fails under Network Server mode because JCC and Derby Net Client do not allow statement name change when there an open resultset against it
change the cursor name(case sensitive name) with setCursorName and then try to deleteRow
change the cursor name one more time with setCursorName and then try to deleteRow
-SQL State : null
-Got expected exception Invalid operation: setCursorName() called when there are open ResultSet's on the Statement.
+SQL State : X0X95
+Got expected exception Operation 'setCursorName()' cannot be performed on object 'Statement' because there is an open ResultSet dependent on that object.
Positive Test8b - change the name of the statement when the resultset is open and see if updateRow still works
This test works in embedded mode since Derby can handle the change in the name of the statement with an open resultset
But it fails under Network Server mode because JCC and Derby Net Client do not allow statement name change when there an open resultset against it
change the cursor name one more time with setCursorName and then try to updateRow
change the cursor name(case sensitive name) with setCursorName and then try to updateRow
-SQL State : null
-Got expected exception Invalid operation: setCursorName() called when there are open ResultSet's on the Statement.
+SQL State : X0X95
+Got expected exception Operation 'setCursorName()' cannot be performed on object 'Statement' because there is an open ResultSet dependent on that object.
Positive Test9a - using correlation name for the table in the select sql works in embedded mode and Network Server using Derby Net Client driver
Correlation name for table does not work in Network Server mode (using JCC) because the drivers construct the delete sql with the correlation name rather than the base table name
column 1 on this row is 1
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out?rev=395484&r1=395483&r2=395484&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out Wed Apr 19 21:59:30 2006
@@ -131,7 +131,7 @@
setTimestamp(null) getShort=0 was null true CLOUD EXT (OK)
setTimestamp(null) as batch getShort=0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type SMALLINT. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type SMALLINT. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type SMALLINT. JDBC MATCH (INVALID)
setAsciiStream(null) getShort=0 was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getShort=0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -304,7 +304,7 @@
setTimestamp(null) getInt=0 was null true CLOUD EXT (OK)
setTimestamp(null) as batch getInt=0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type INTEGER. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type INTEGER. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type INTEGER. JDBC MATCH (INVALID)
setAsciiStream(null) getInt=0 was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getInt=0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -477,7 +477,7 @@
setTimestamp(null) getLong=0 was null true CLOUD EXT (OK)
setTimestamp(null) as batch getLong=0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type BIGINT. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type BIGINT. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type BIGINT. JDBC MATCH (INVALID)
setAsciiStream(null) getLong=0 was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getLong=0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -650,7 +650,7 @@
setTimestamp(null) getFloat=0.0 was null true CLOUD EXT (OK)
setTimestamp(null) as batch getFloat=0.0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type REAL. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type REAL. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type REAL. JDBC MATCH (INVALID)
setAsciiStream(null) getFloat=0.0 was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getFloat=0.0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -824,7 +824,7 @@
setTimestamp(null) getDouble=0.0 was null true CLOUD EXT (OK)
setTimestamp(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
setAsciiStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -997,7 +997,7 @@
setTimestamp(null) getDouble=0.0 was null true CLOUD EXT (OK)
setTimestamp(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
setAsciiStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1170,7 +1170,7 @@
setTimestamp(null) getBigDecimal=null was null true CLOUD EXT (OK)
setTimestamp(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type DECIMAL. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type DECIMAL. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type DECIMAL. JDBC MATCH (INVALID)
setAsciiStream(null) getBigDecimal=null was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1891,7 +1891,7 @@
setObject(null) OK Type is not supported.
setObject(null) as batch OK Type is not supported.
setObject(java.lang.String) (XCL12):An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'VARCHAR () FOR BIT DATA'. JDBC FAIL VARCHAR(60) FOR BIT DATA
- setObject(java.lang.String) as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'VARCHAR () FOR BIT DATA'. JDBC FAIL VARCHAR(60) FOR BIT DATA
+ setObject(java.lang.String) as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'VARCHAR () FOR BIT DATA'. JDBC FAIL VARCHAR(60) FOR BIT DATA
setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
@@ -2021,7 +2021,7 @@
setBoolean() IC JDBC MATCH (INVALID)
setBoolean() as batch IC JDBC MATCH (INVALID)
setString() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
- setString() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
+ setString() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
setString(null) getDate=null was null true JDBC MATCH(OK)
setString(null) as batch getDate=null was null true JDBC MATCH(OK)
setString("Invalid Value") IC (Expected)
@@ -2042,7 +2042,7 @@
setTimestamp(null) getDate=null was null true JDBC MATCH(OK)
setTimestamp(null) as batch getDate=null was null true JDBC MATCH(OK)
setAsciiStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setAsciiStream(null) getDate=null was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getDate=null was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2050,11 +2050,11 @@
setBinaryStream(null) getDate=null was null true CLOUD EXT (OK)
setBinaryStream(null) as batch getDate=null was null true CLOUD EXT (OK)
setCharacterStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setCharacterStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setCharacterStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setCharacterStream(null) getDate=null was null true CLOUD EXT (OK)
setCharacterStream(null) as batch getDate=null was null true CLOUD EXT (OK)
setClob() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setClob() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setClob() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setClob(null) getDate=null was null true CLOUD EXT (OK)
setClob(null) as batch getDate=null was null true CLOUD EXT (OK)
setBlob() IC JDBC MATCH (INVALID)
@@ -2066,7 +2066,7 @@
setObject(null) OK Type is not supported.
setObject(null) as batch OK Type is not supported.
setObject(java.lang.String) (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
- setObject(java.lang.String) as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
+ setObject(java.lang.String) as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
@@ -2194,7 +2194,7 @@
setBoolean() IC JDBC MATCH (INVALID)
setBoolean() as batch IC JDBC MATCH (INVALID)
setString() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
- setString() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
+ setString() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
setString(null) getTime=null was null true JDBC MATCH(OK)
setString(null) as batch getTime=null was null true JDBC MATCH(OK)
setString("Invalid Value") IC (Expected)
@@ -2215,7 +2215,7 @@
setTimestamp(null) getTime=null was null true JDBC MATCH(OK)
setTimestamp(null) as batch getTime=null was null true JDBC MATCH(OK)
setAsciiStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setAsciiStream(null) getTime=null was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getTime=null was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2223,11 +2223,11 @@
setBinaryStream(null) getTime=null was null true CLOUD EXT (OK)
setBinaryStream(null) as batch getTime=null was null true CLOUD EXT (OK)
setCharacterStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setCharacterStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setCharacterStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setCharacterStream(null) getTime=null was null true CLOUD EXT (OK)
setCharacterStream(null) as batch getTime=null was null true CLOUD EXT (OK)
setClob() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setClob() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setClob() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setClob(null) getTime=null was null true CLOUD EXT (OK)
setClob(null) as batch getTime=null was null true CLOUD EXT (OK)
setBlob() IC JDBC MATCH (INVALID)
@@ -2239,7 +2239,7 @@
setObject(null) OK Type is not supported.
setObject(null) as batch OK Type is not supported.
setObject(java.lang.String) (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
- setObject(java.lang.String) as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
+ setObject(java.lang.String) as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
@@ -2367,7 +2367,7 @@
setBoolean() IC JDBC MATCH (INVALID)
setBoolean() as batch IC JDBC MATCH (INVALID)
setString() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
- setString() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
+ setString() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
setString(null) getTimestamp=null was null true JDBC MATCH(OK)
setString(null) as batch getTimestamp=null was null true JDBC MATCH(OK)
setString("Invalid Value") IC (Expected)
@@ -2388,7 +2388,7 @@
setTimestamp(null) getTimestamp=null was null true JDBC MATCH(OK)
setTimestamp(null) as batch getTimestamp=null was null true JDBC MATCH(OK)
setAsciiStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setAsciiStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setAsciiStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setAsciiStream(null) getTimestamp=null was null true CLOUD EXT (OK)
setAsciiStream(null) as batch getTimestamp=null was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2396,11 +2396,11 @@
setBinaryStream(null) getTimestamp=null was null true CLOUD EXT (OK)
setBinaryStream(null) as batch getTimestamp=null was null true CLOUD EXT (OK)
setCharacterStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setCharacterStream() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setCharacterStream() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setCharacterStream(null) getTimestamp=null was null true CLOUD EXT (OK)
setCharacterStream(null) as batch getTimestamp=null was null true CLOUD EXT (OK)
setClob() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
- setClob() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
+ setClob() as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setClob(null) getTimestamp=null was null true CLOUD EXT (OK)
setClob(null) as batch getTimestamp=null was null true CLOUD EXT (OK)
setBlob() IC JDBC MATCH (INVALID)
@@ -2412,7 +2412,7 @@
setObject(null) OK Type is not supported.
setObject(null) as batch OK Type is not supported.
setObject(java.lang.String) (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
- setObject(java.lang.String) as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
+ setObject(java.lang.String) as batch (XJ208):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22007):Error for batch element #0: The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/procedure.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/procedure.out?rev=395484&r1=395483&r2=395484&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/procedure.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/procedure.out Wed Apr 19 21:59:30 2006
@@ -271,7 +271,7 @@
A |B |C
-----
70 |831 |45.700
-EXPECTED SQL Exception: BigDecimal conversion exception [converters] Overflow occurred during numeric data type conversion of "10243".. See attached Throwable. Caused by exception class org.apache.derby.client.am.ConversionException: [converters] Overflow occurred during numeric data type conversion of "10243".
+EXPECTED SQL Exception: Overflow occurred during numeric data type conversion of '10243' to packed decimal.
A |B |C
-----
80 |993 |1234.567
@@ -352,7 +352,7 @@
No ResultSet or update count returned
OP4INOUT 9+23.505 >32.50< null ? false
EXPECTED SQL Exception: The resulting value is outside the range for the data type DECIMAL/NUMERIC(4,2).
-EXPECTED SQL Exception: BigDecimal conversion exception [converters] Overflow occurred during numeric data type conversion of "102.33".. See attached Throwable. Caused by exception class org.apache.derby.client.am.ConversionException: [converters] Overflow occurred during numeric data type conversion of "102.33".
+EXPECTED SQL Exception: Overflow occurred during numeric data type conversion of '102.33' to packed decimal.
EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized.
SQL Control
CREATE PROCEDURE SQLC.SQLCONTROL1_0 (OUT E1 VARCHAR(128), OUT E2 VARCHAR(128), OUT E3 VARCHAR(128), OUT E4 VARCHAR(128), OUT E5 VARCHAR(128), OUT E6 VARCHAR(128), OUT E7 VARCHAR(128)) PARAMETER STYLE JAVA LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl'
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/scrollCursors2.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/scrollCursors2.out?rev=395484&r1=395483&r2=395484&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/scrollCursors2.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/scrollCursors2.out Wed Apr 19 21:59:30 2006
@@ -1,5 +1,5 @@
Test scrollCurors2 starting
-Invalid maxRows value: -1
+Invalid parameter value '-1' for Statement.setMaxRows(int maxRows). Parameter value must be >= 0.
This method should only be called on ResultSet objects that are scrollable (type TYPE_SCROLL_SENSITIVE or TYPE_SCROLL_INSENSITIVE).
This method should only be called on ResultSet objects that are scrollable (type TYPE_SCROLL_SENSITIVE or TYPE_SCROLL_INSENSITIVE).
This method should only be called on ResultSet objects that are scrollable (type TYPE_SCROLL_SENSITIVE or TYPE_SCROLL_INSENSITIVE).
@@ -14,7 +14,7 @@
warning = java.sql.SQLWarning: Scroll sensitive result sets are not supported by server; remapping to forward-only cursor
warning = java.sql.SQLWarning: Insensitive updatable result sets are not supported by server; remapping to insensitive read-only cursor
warning = java.sql.SQLWarning: Insensitive updatable result sets are not supported by server; remapping to insensitive read-only cursor
-Invalid maxRows value: -1
+Invalid parameter value '-1' for Statement.setMaxRows(int maxRows). Parameter value must be >= 0.
Invalid parameter value '-5' for ResultSet.setFetchSize(int rows).
warning = java.sql.SQLWarning: Scroll sensitive result sets are not supported by server; remapping to forward-only cursor
warning = java.sql.SQLWarning: Scroll sensitive result sets are not supported by server; remapping to forward-only cursor
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out?rev=395484&r1=395483&r2=395484&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out Wed Apr 19 21:59:30 2006
@@ -272,15 +272,15 @@
But it fails under Network Server mode because JCC and Derby Net Client do not allow statement name change when there an open resultset against it
change the cursor name(case sensitive name) with setCursorName and then try to deleteRow
change the cursor name one more time with setCursorName and then try to deleteRow
-SQL State : null
-Got expected exception Invalid operation: setCursorName() called when there are open ResultSet's on the Statement.
+SQL State : X0X95
+Got expected exception Operation 'setCursorName()' cannot be performed on object 'Statement' because there is an open ResultSet dependent on that object.
Positive Test8b - change the name of the statement when the resultset is open and see if updateRow still works
This test works in embedded mode since Derby can handle the change in the name of the statement with an open resultset
But it fails under Network Server mode because JCC and Derby Net Client do not allow statement name change when there an open resultset against it
change the cursor name one more time with setCursorName and then try to updateRow
change the cursor name(case sensitive name) with setCursorName and then try to updateRow
-SQL State : null
-Got expected exception Invalid operation: setCursorName() called when there are open ResultSet's on the Statement.
+SQL State : X0X95
+Got expected exception Operation 'setCursorName()' cannot be performed on object 'Statement' because there is an open ResultSet dependent on that object.
Positive Test9a - using correlation name for the table in the select sql works in embedded mode and Network Server using Derby Net Client driver
Correlation name for table does not work in Network Server mode (using JCC) because the drivers construct the delete sql with the correlation name rather than the base table name
column 1 on this row is 1
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/StatementTest.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/StatementTest.java?rev=395484&r1=395483&r2=395484&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/StatementTest.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/StatementTest.java Wed Apr 19 21:59:30 2006
@@ -214,19 +214,10 @@
try {
stmt.executeQuery("select count(*) from stmtTable");
} catch (SQLException sqle) {
- // Different error messages are returned for embedded and client.
- if (usingEmbedded()) {
- assertEquals("Unexpected SQL state for performing " +
- "operations on a closed statement.",
- SQLState.NO_CURRENT_CONNECTION,
- sqle.getSQLState());
- } else {
- // TODO: Compare with SQLState when implemented on client side.
- assertEquals("Unexpected SQL state for performing " +
- "operations on a closed statement.",
- "Invalid operation: statement closed",
- sqle.getMessage());
- }
+ assertEquals("Unexpected SQL state for performing " +
+ "operations on a closed statement.",
+ SQLStateConstants.CONNECTION_EXCEPTION_CONNECTION_DOES_NOT_EXIST,
+ sqle.getSQLState());
}
assertTrue("Statement should be closed, because " +
"the connection has been closed", stmt.isClosed());
Modified: db/derby/code/trunk/tools/testing/i18nTestGenerator/clientPrologue.txt
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/tools/testing/i18nTestGenerator/clientPrologue.txt?rev=395484&r1=395483&r2=395484&view=diff
==============================================================================
--- db/derby/code/trunk/tools/testing/i18nTestGenerator/clientPrologue.txt (original)
+++ db/derby/code/trunk/tools/testing/i18nTestGenerator/clientPrologue.txt Wed Apr 19 21:59:30 2006
@@ -3,6 +3,7 @@
import org.apache.derby.client.am.MessageId;
import org.apache.derby.client.am.SqlException;
import org.apache.derby.shared.common.reference.SQLState;
+import org.apache.derby.client.am.SqlCode;
/**
* This class is a GENERATED FILE that tests as many of the messages
Modified: db/derby/code/trunk/tools/testing/i18nTestGenerator/genClient2.sed
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/tools/testing/i18nTestGenerator/genClient2.sed?rev=395484&r1=395483&r2=395484&view=diff
==============================================================================
--- db/derby/code/trunk/tools/testing/i18nTestGenerator/genClient2.sed (original)
+++ db/derby/code/trunk/tools/testing/i18nTestGenerator/genClient2.sed Wed Apr 19 21:59:30 2006
@@ -22,10 +22,19 @@
}
#
+# Calling super is the same as new SqlException for subclasses...
+#
+/super(/i\
+ try { \
+ testException = new SqlException(
+s/super(//
+
+#
# Add substitution for various message parameters where you replace
# the variable with a string containing the variable. This prevents
# compile errors saying "symbol not found"
#
+s/logWriter/null/g
s/fileName/"fileName"/g
s/[[:space:]]e.getMessage()/"e.getMessage"/g
s/Configuration.packageNameForDNC/"Configuration.packageNameForDNC"/g
@@ -43,11 +52,18 @@
s/{e.getClass().getName()/{"exceptionClassName"/g
s/[[:space:]]sourceType/ "sourceType"/g
s/[[:space:]]targetType/ "targetType"/g
-s/[[:space:]]columnName/ "columnName"/g
+s/[[:space:]]columnName)/ "columnName")/g
s/[[:space:]]charsetName/ "charsetName"/g
s/[[:space:]]cursorName/ "cursorName"/g
s/[[:space:]]cursorName/ "cursorName"/g
s/[[:space:]]methodName/ "methodName"/g
+s/[[:space:]]instance/ "instance"/g
+s/[[:space:]]method)/ "method")/g
+s/[[:space:]]b.toString()/ "bytes"/g
+s/[[:space:]]jdbcInterfaceName/ "jdbcInterfaceName"/g
+s/[[:space:]]jdbcStatementInterfaceName/ "jdbcInterfaceName"/g
+s/[[:space:]]name)/ "name")/g
+s/[[:space:]]sql)/ "sql")/g
#
# Deal with extra updateCounts argument to BatchUpdateExceptoins.