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 rh...@apache.org on 2006/04/11 16:49:53 UTC
svn commit: r393239 [3/4] - in /db/derby/code/trunk/java:
drda/org/apache/derby/impl/drda/ engine/org/apache/derby/impl/jdbc/
testing/org/apache/derbyTesting/functionTests/master/
testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ testing/o...
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=393239&r1=393238&r2=393239&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 Tue Apr 11 07:49:30 2006
@@ -130,8 +130,8 @@
setTimestamp() as batch IC JDBC MATCH (INVALID)
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() (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(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)
@@ -150,7 +150,7 @@
setBlob() as batch IC JDBC MATCH (INVALID)
setBlob(null) getShort=0 was null true CLOUD EXT (OK)
setBlob(null) as batch getShort=0 was null true CLOUD EXT (OK)
- setUnicodeStream() (22018):Invalid character string format for type SMALLINT. : JDBC MATCH (INVALID)
+ setUnicodeStream() (22018):Invalid character string format for type SMALLINT. JDBC MATCH (INVALID)
setUnicodeStream(null) getShort=0 was null true CLOUD EXT (OK)
setObject(null) OK Invalid data conversion: Parameter object type is invalid for requested conversion.
setObject(null) as batch OK Invalid data conversion: Parameter object type is invalid for requested conversion.
@@ -303,8 +303,8 @@
setTimestamp() as batch IC JDBC MATCH (INVALID)
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() (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(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)
@@ -323,7 +323,7 @@
setBlob() as batch IC JDBC MATCH (INVALID)
setBlob(null) getInt=0 was null true CLOUD EXT (OK)
setBlob(null) as batch getInt=0 was null true CLOUD EXT (OK)
- setUnicodeStream() (22018):Invalid character string format for type INTEGER. : JDBC MATCH (INVALID)
+ setUnicodeStream() (22018):Invalid character string format for type INTEGER. JDBC MATCH (INVALID)
setUnicodeStream(null) getInt=0 was null true CLOUD EXT (OK)
setObject(null) OK Invalid data conversion: Parameter object type is invalid for requested conversion.
setObject(null) as batch OK Invalid data conversion: Parameter object type is invalid for requested conversion.
@@ -476,8 +476,8 @@
setTimestamp() as batch IC JDBC MATCH (INVALID)
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() (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(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)
@@ -496,7 +496,7 @@
setBlob() as batch IC JDBC MATCH (INVALID)
setBlob(null) getLong=0 was null true CLOUD EXT (OK)
setBlob(null) as batch getLong=0 was null true CLOUD EXT (OK)
- setUnicodeStream() (22018):Invalid character string format for type BIGINT. : JDBC MATCH (INVALID)
+ setUnicodeStream() (22018):Invalid character string format for type BIGINT. JDBC MATCH (INVALID)
setUnicodeStream(null) getLong=0 was null true CLOUD EXT (OK)
setObject(null) OK Invalid data conversion: Parameter object type is invalid for requested conversion.
setObject(null) as batch OK Invalid data conversion: Parameter object type is invalid for requested conversion.
@@ -649,8 +649,8 @@
setTimestamp() as batch IC JDBC MATCH (INVALID)
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() (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(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)
@@ -669,7 +669,7 @@
setBlob() as batch IC JDBC MATCH (INVALID)
setBlob(null) getFloat=0.0 was null true CLOUD EXT (OK)
setBlob(null) as batch getFloat=0.0 was null true CLOUD EXT (OK)
- setUnicodeStream() (22018):Invalid character string format for type REAL. : JDBC MATCH (INVALID)
+ setUnicodeStream() (22018):Invalid character string format for type REAL. JDBC MATCH (INVALID)
setUnicodeStream(null) getFloat=0.0 was null true CLOUD EXT (OK)
setObject(null) OK Invalid data conversion: Parameter object type is invalid for requested conversion.
setObject(null) as batch OK Invalid data conversion: Parameter object type is invalid for requested conversion.
@@ -823,8 +823,8 @@
setTimestamp() as batch IC JDBC MATCH (INVALID)
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() (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(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)
@@ -843,7 +843,7 @@
setBlob() as batch IC JDBC MATCH (INVALID)
setBlob(null) getDouble=0.0 was null true CLOUD EXT (OK)
setBlob(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
- setUnicodeStream() (22018):Invalid character string format for type DOUBLE. : JDBC MATCH (INVALID)
+ setUnicodeStream() (22018):Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
setUnicodeStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
setObject(null) OK Invalid data conversion: Parameter object type is invalid for requested conversion.
setObject(null) as batch OK Invalid data conversion: Parameter object type is invalid for requested conversion.
@@ -996,8 +996,8 @@
setTimestamp() as batch IC JDBC MATCH (INVALID)
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() (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(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)
@@ -1016,7 +1016,7 @@
setBlob() as batch IC JDBC MATCH (INVALID)
setBlob(null) getDouble=0.0 was null true CLOUD EXT (OK)
setBlob(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
- setUnicodeStream() (22018):Invalid character string format for type DOUBLE. : JDBC MATCH (INVALID)
+ setUnicodeStream() (22018):Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
setUnicodeStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
setObject(null) OK Invalid data conversion: Parameter object type is invalid for requested conversion.
setObject(null) as batch OK Invalid data conversion: Parameter object type is invalid for requested conversion.
@@ -1169,8 +1169,8 @@
setTimestamp() as batch IC JDBC MATCH (INVALID)
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() (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(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)
@@ -1189,7 +1189,7 @@
setBlob() as batch IC JDBC MATCH (INVALID)
setBlob(null) getBigDecimal=null was null true CLOUD EXT (OK)
setBlob(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
- setUnicodeStream() (22018):Invalid character string format for type DECIMAL. : JDBC MATCH (INVALID)
+ setUnicodeStream() (22018):Invalid character string format for type DECIMAL. JDBC MATCH (INVALID)
setUnicodeStream(null) getBigDecimal=null was null true CLOUD EXT (OK)
setObject(null) OK Invalid data conversion: Parameter object type is invalid for requested conversion.
setObject(null) as batch OK Invalid data conversion: Parameter object type is invalid for requested conversion.
@@ -1886,12 +1886,12 @@
setBlob() as batch getBytes=0x32,0x43 was null false CLOUD EXT (OK)
setBlob(null) getBytes=null was null true CLOUD EXT (OK)
setBlob(null) as batch getBytes=null was null true CLOUD EXT (OK)
- setUnicodeStream() (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
+ setUnicodeStream() (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
setUnicodeStream(null) getBytes=null was null true JDBC MATCH(OK)
setObject(null) OK Invalid data conversion: Parameter object type is invalid for requested conversion.
setObject(null) as batch OK Invalid data conversion: Parameter object type is invalid for requested conversion.
- 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) (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.math.BigDecimal) IC JDBC MATCH (INVALID)
setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
@@ -2020,8 +2020,8 @@
setBigDecimal(null) as batch getDate=null was null true CLOUD EXT (OK)
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() (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(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)
@@ -2041,32 +2041,32 @@
setTimestamp() as batch getDate=2004-02-23 was null false JDBC MATCH(OK)
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() (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(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)
setBinaryStream() as batch IC JDBC MATCH (INVALID)
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() (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(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() (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(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)
setBlob() as batch IC JDBC MATCH (INVALID)
setBlob(null) getDate=null was null true CLOUD EXT (OK)
setBlob(null) as batch getDate=null was null true CLOUD EXT (OK)
- setUnicodeStream() (22007):The syntax of the string representation of a datetime value is incorrect. : JDBC MATCH (INVALID)
+ setUnicodeStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setUnicodeStream(null) getDate=null was null true CLOUD EXT (OK)
setObject(null) OK Invalid data conversion: Parameter object type is invalid for requested conversion.
setObject(null) as batch OK Invalid data conversion: Parameter object type is invalid for requested conversion.
- 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) (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.math.BigDecimal) IC JDBC MATCH (INVALID)
setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
@@ -2193,8 +2193,8 @@
setBigDecimal(null) as batch getTime=null was null true CLOUD EXT (OK)
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() (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(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)
@@ -2214,32 +2214,32 @@
setTimestamp() as batch getTime=17:14:24 was null false JDBC MATCH(OK)
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() (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(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)
setBinaryStream() as batch IC JDBC MATCH (INVALID)
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() (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(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() (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(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)
setBlob() as batch IC JDBC MATCH (INVALID)
setBlob(null) getTime=null was null true CLOUD EXT (OK)
setBlob(null) as batch getTime=null was null true CLOUD EXT (OK)
- setUnicodeStream() (22007):The syntax of the string representation of a datetime value is incorrect. : JDBC MATCH (INVALID)
+ setUnicodeStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setUnicodeStream(null) getTime=null was null true CLOUD EXT (OK)
setObject(null) OK Invalid data conversion: Parameter object type is invalid for requested conversion.
setObject(null) as batch OK Invalid data conversion: Parameter object type is invalid for requested conversion.
- 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) (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.math.BigDecimal) IC JDBC MATCH (INVALID)
setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
@@ -2366,8 +2366,8 @@
setBigDecimal(null) as batch getTimestamp=null was null true CLOUD EXT (OK)
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() (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(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)
@@ -2387,32 +2387,32 @@
setTimestamp() as batch getTimestamp=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
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() (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(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)
setBinaryStream() as batch IC JDBC MATCH (INVALID)
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() (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(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() (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(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)
setBlob() as batch IC JDBC MATCH (INVALID)
setBlob(null) getTimestamp=null was null true CLOUD EXT (OK)
setBlob(null) as batch getTimestamp=null was null true CLOUD EXT (OK)
- setUnicodeStream() (22007):The syntax of the string representation of a datetime value is incorrect. : JDBC MATCH (INVALID)
+ setUnicodeStream() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC MATCH (INVALID)
setUnicodeStream(null) getTimestamp=null was null true CLOUD EXT (OK)
setObject(null) OK Invalid data conversion: Parameter object type is invalid for requested conversion.
setObject(null) as batch OK Invalid data conversion: Parameter object type is invalid for requested conversion.
- 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) (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.math.BigDecimal) IC JDBC MATCH (INVALID)
setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
@@ -2752,7 +2752,7 @@
setBlob() as batch getBlob=0x32,0x43 was null false JDBC MATCH(OK)
setBlob(null) getBlob=null was null true JDBC MATCH(OK)
setBlob(null) as batch getBlob=null was null true JDBC MATCH(OK)
- setUnicodeStream() (XCL12):An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'BLOB'. : JDBC FAIL BLOB(1k)
+ setUnicodeStream() (XCL12):An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'BLOB'. JDBC FAIL BLOB(1k)
setUnicodeStream(null) getBlob=null was null true JDBC MATCH(OK)
setObject(null) OK Invalid data conversion: Parameter object type is invalid for requested conversion.
setObject(null) as batch OK Invalid data conversion: Parameter object type is invalid for requested conversion.
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=393239&r1=393238&r2=393239&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 Tue Apr 11 07:49:30 2006
@@ -1,95 +1,95 @@
testNegative
create procedure asdf() language java external name 'asdfasdf' parameter style java
-EXPECTED SQL Exception: (42Y04) Cannot create a procedure or function with EXTERNAL NAME 'asdfasdf' because it is not a list separated by periods. The expected format is <full java path>.<method name>. :
+EXPECTED SQL Exception: (42Y04) Cannot create a procedure or function with EXTERNAL NAME 'asdfasdf' because it is not a list separated by periods. The expected format is <full java path>.<method name>.
create procedure asdf() language java external name 'asdfasdf.' parameter style java
-EXPECTED SQL Exception: (42Y04) Cannot create a procedure or function with EXTERNAL NAME 'asdfasdf.' because it is not a list separated by periods. The expected format is <full java path>.<method name>. :
+EXPECTED SQL Exception: (42Y04) Cannot create a procedure or function with EXTERNAL NAME 'asdfasdf.' because it is not a list separated by periods. The expected format is <full java path>.<method name>.
create procedure a23456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789() language java external name 'asdf.asdf' parameter style java
-EXPECTED SQL Exception: (42622) The name 'A23456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789' is too long. The maximum length is '128'. :
+EXPECTED SQL Exception: (42622) The name 'A23456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789' is too long. The maximum length is '128'.
create procedure asdf language java external name java.lang.Thread.currentThread parameter style java
-EXPECTED SQL Exception: (42X01) Syntax error: Encountered "language" at line 1, column 23. :
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "language" at line 1, column 23.
CREATE PROCEDURE ASSEMBLY_PARTS (IN ASSEMBLY_NUM INTEGER, OUT NUM_PARTS INTEGER, OUT COST DOUBLE) EXTERNAL NAME 'parts!assembly' DYNAMIC RESULT SETS 1 LANGUAGE C PARAMETER STYLE GENERAL
-EXPECTED SQL Exception: (42X01) Syntax error: Encountered "C" at line 1, column 161. :
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "C" at line 1, column 161.
create procedure sys.proc1() language java external name 'java.lang.System.gc' parameter style java
-EXPECTED SQL Exception: (42X62) 'CREATE PROCEDURE' is not allowed in the 'SYS' schema. :
+EXPECTED SQL Exception: (42X62) 'CREATE PROCEDURE' is not allowed in the 'SYS' schema.
create procedure noclass() language java external name 'asdf.asdf' parameter style java language java
-EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'LANGUAGE' clause are present. :
+EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'LANGUAGE' clause are present.
create procedure noclass() parameter style java language java external name 'asdf.asdf' parameter style java
-EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'PARAMETER STYLE' clause are present. :
+EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'PARAMETER STYLE' clause are present.
create procedure noclass() external name 'asdf.xxxx' language java external name 'asdf.asdf' parameter style java
-EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'EXTERNAL NAME' clause are present. :
+EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'EXTERNAL NAME' clause are present.
create procedure noclass() parameter style java language java external name 'asdf.asdf' parameter style derby_rs_collection
-EXPECTED SQL Exception: (42X01) Syntax error: Encountered "derby_rs_collection" at line 1, column 105. :
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "derby_rs_collection" at line 1, column 105.
create procedure missing01()
-EXPECTED SQL Exception: (42X01) Syntax error: Encountered "<EOF>" at line 1, column 28. :
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "<EOF>" at line 1, column 28.
create procedure missing02() language java
-EXPECTED SQL Exception: (42X01) Syntax error: EXTERNAL NAME. :
+EXPECTED SQL Exception: (42X01) Syntax error: EXTERNAL NAME.
create procedure missing03() language java parameter style java
-EXPECTED SQL Exception: (42X01) Syntax error: EXTERNAL NAME. :
+EXPECTED SQL Exception: (42X01) Syntax error: EXTERNAL NAME.
create procedure missing04() language java external name 'foo.bar'
-EXPECTED SQL Exception: (42X01) Syntax error: PARAMETER STYLE. :
+EXPECTED SQL Exception: (42X01) Syntax error: PARAMETER STYLE.
create procedure missing05() parameter style java
-EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE. :
+EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE.
create procedure missing06() parameter style java external name 'foo.bar'
-EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE. :
+EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE.
create procedure missing07() external name 'goo.bar'
-EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE. :
+EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE.
create procedure missing08() dynamic result sets 1
-EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE. :
+EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE.
create procedure nullinput2() returns null on null input language java parameter style java external name 'foo.bar'
-EXPECTED SQL Exception: (42X01) Syntax error: RETURNS NULL ON NULL INPUT. :
+EXPECTED SQL Exception: (42X01) Syntax error: RETURNS NULL ON NULL INPUT.
create procedure NO_BLOB(IN P1 BLOB(3k)) language java parameter style java external name 'no.blob'
-EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions. :
+EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions.
create procedure NO_CLOB(IN P1 CLOB(3k)) language java parameter style java external name 'no.clob'
-EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions. :
+EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions.
create procedure NO_LVC(IN P1 LONG VARCHAR) language java parameter style java external name 'no.lvc'
-EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions. :
+EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions.
create procedure DUP_P1(IN FRED INT, OUT RON CHAR(10), IN FRED INT) language java parameter style java external name 'no.dup1'
-EXPECTED SQL Exception: (42734) Name 'FRED' specified in context 'DUP_P1' is not unique. :
+EXPECTED SQL Exception: (42734) Name 'FRED' specified in context 'DUP_P1' is not unique.
create procedure D2.DUP_P2(IN "FreD" INT, OUT RON CHAR(10), IN "FreD" INT) language java parameter style java external name 'no.dup2'
-EXPECTED SQL Exception: (42734) Name 'FreD' specified in context 'D2.DUP_P2' is not unique. :
+EXPECTED SQL Exception: (42734) Name 'FreD' specified in context 'D2.DUP_P2' is not unique.
create procedure D3.DUP_P3(IN "FRED" INT, OUT RON CHAR(10), IN fred INT) language java parameter style java external name 'no.dup3'
-EXPECTED SQL Exception: (42734) Name 'FRED' specified in context 'D3.DUP_P3' is not unique. :
+EXPECTED SQL Exception: (42734) Name 'FRED' specified in context 'D3.DUP_P3' is not unique.
CALL APP.NSP(?, ?)
-EXPECTED SQL Exception: (42Y03) 'APP.NSP' is not recognized as a function or procedure. :
+EXPECTED SQL Exception: (42Y03) 'APP.NSP' is not recognized as a function or procedure.
call syscs_util.syscs_set_database_property("foo", "bar")
-EXPECTED SQL Exception: (42X15) Column name 'foo' appears in a statement without a FROM list. :
+EXPECTED SQL Exception: (42X15) Column name 'foo' appears in a statement without a FROM list.
signature mismatched types
CALL APP.SIGNATURE_BUG_DERBY_258_A(4)
-EXPECTED SQL Exception: (22005) An attempt was made to get a data value of type 'java.lang.String' from a data value of type 'INTEGER'. :
+EXPECTED SQL Exception: (22005) An attempt was made to get a data value of type 'java.lang.String' from a data value of type 'INTEGER'.
signature too many parameters
VALUES APP.SIGNATURE_BUG_DERBY_258_B(4)
-EXPECTED SQL Exception: (46J02) Java method signature contains incorrect number (2) of parameters, expected 1. :
+EXPECTED SQL Exception: (46J02) Java method signature contains incorrect number (2) of parameters, expected 1.
signature too few parameters
CALL APP.SIGNATURE_BUG_DERBY_258_C(4)
-EXPECTED SQL Exception: (46J02) Java method signature contains incorrect number (0) of parameters, expected 1. :
+EXPECTED SQL Exception: (46J02) Java method signature contains incorrect number (0) of parameters, expected 1.
signature invalid format
CALL APP.SIGNATURE_BUG_DERBY_258_F(4)
-EXPECTED SQL Exception: (46J01) Java method signature has invalid format. :
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
signature invalid format
CALL APP.SIGNATURE_BUG_DERBY_258_G(4)
-EXPECTED SQL Exception: (46J01) Java method signature has invalid format. :
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
signature invalid format
CALL APP.SIGNATURE_BUG_DERBY_258_H(4)
-EXPECTED SQL Exception: (46J01) Java method signature has invalid format. :
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
signature invalid format
CALL APP.SIGNATURE_BUG_DERBY_258_I(4)
-EXPECTED SQL Exception: (46J01) Java method signature has invalid format. :
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
testDelayedClassChecking
call noclass()
-EXPECTED SQL Exception: (42X51) The class 'asdf' does not exist or is inaccessible. This can happen if the class is not public.::SQLSTATE: XJ001Java exception: 'asdf: java.lang.ClassNotFoundException'. :
+EXPECTED SQL Exception: (42X51) The class 'asdf' does not exist or is inaccessible. This can happen if the class is not public.
call nomethod()
-EXPECTED SQL Exception: (42X50) No method was found that matched the method call java.lang.Integer.asdf(), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible. :
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call java.lang.Integer.asdf(), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
call notstatic()
-EXPECTED SQL Exception: (42X50) No method was found that matched the method call java.lang.Integer.equals(), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible. :
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call java.lang.Integer.equals(), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
call notvoid()
-EXPECTED SQL Exception: (42X50) No method was found that matched the method call void java.lang.Runtime.getRuntime(), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible. :
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call void java.lang.Runtime.getRuntime(), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
testDuplicates
create procedure PROCDUP() language java external name 'failAPP.fail0' parameter style java
-EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists. :
+EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists.
create procedure s1.PROCDUP() language java external name 'fails1.fail0' parameter style java
-EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists. :
+EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists.
create procedure s2.PROCDUP() language java external name 'fails2.fail0' parameter style java
-EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists. :
+EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists.
DEFINED PROCEDURES FOR PROCDUP
APP.PROCDUP AS okAPP.ok0() LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
S1.PROCDUP AS oks1.ok0() LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
@@ -100,19 +100,19 @@
S2.PROCDUP AS oks2.ok0 type procedureNoResult
-----
create procedure S1.NOTYET() SPECIFIC fred language java external name 'failAPP.fail0' parameter style java
-EXPECTED SQL Exception: (0A000) Feature not implemented: SPECIFIC identifier. :
+EXPECTED SQL Exception: (0A000) Feature not implemented: SPECIFIC identifier.
ambigiousMethods
call AMBIGIOUS01(?, ?)
-EXPECTED SQL Exception: (42X73) Method resolution for signature org.apache.derbyTesting.functionTests.util.ProcedureTest.ambigious1(int, java.lang.String, [Ljava.sql.ResultSet;) was ambiguous. (No single maximally specific method.) :
+EXPECTED SQL Exception: (42X73) Method resolution for signature org.apache.derbyTesting.functionTests.util.ProcedureTest.ambigious1(int, java.lang.String, [Ljava.sql.ResultSet;) was ambiguous. (No single maximally specific method.)
call AMBIGIOUS02(?, ?)
-EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.ambigious2(int, int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible. :
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.ambigious2(int, int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
No ResultSet or update count returned
No ResultSet or update count returned
zeroArgProcedures
No ResultSet or update count returned
No ResultSet or update count returned
No ResultSet or update count returned
-EXPECTED SQL Exception: 'ZA' is not recognized as a function or procedure. :
+EXPECTED SQL Exception: 'ZA' is not recognized as a function or procedure.
No ResultSet or update count returned
No ResultSet or update count returned
DEFINED PROCEDURES FOR ZA
@@ -135,10 +135,10 @@
procedureColumnIn P2 CHAR
-----
CALL IR()
-EXPECTED SQL Exception: (42Y03) 'IR' is not recognized as a function or procedure. :
+EXPECTED SQL Exception: (42Y03) 'IR' is not recognized as a function or procedure.
No ResultSet or update count returned
No ResultSet or update count returned
-EXPECTED SQL Exception: The exception 'SQL Exception: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'xxxxGENERATED-IDxxxx' defined on 'T1'.' was thrown while evaluating an expression.::SQLSTATE: 23505The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'xxxxGENERATED-IDxxxx' defined on 'T1'. :
+EXPECTED SQL Exception: The exception 'SQL Exception: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'xxxxGENERATED-IDxxxx' defined on 'T1'.' was thrown while evaluating an expression.
No ResultSet or update count returned
No ResultSet or update count returned
No ResultSet or update count returned
@@ -154,14 +154,14 @@
5 |ir2
6 |'012345678
CALL IR2(2, 'no way')
-EXPECTED SQL Exception: (38000) The exception 'SQL Exception: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'xxxxGENERATED-IDxxxx' defined on 'T1'.' was thrown while evaluating an expression.::SQLSTATE: 23505The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'xxxxGENERATED-IDxxxx' defined on 'T1'. :
+EXPECTED SQL Exception: (38000) The exception 'SQL Exception: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'xxxxGENERATED-IDxxxx' defined on 'T1'.' was thrown while evaluating an expression.
CALL IR2(?, 'no way')
EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized.
CALL IR2(2, ?)
EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized.
dynamicResultSets - parameter style JAVA
create procedure DRS(p1 int) parameter style JAVA READS SQL DATA dynamic result sets -1 language java external name 'org.apache.derbyTesting.functionTests.util.ProcedureTest.selectRows'
-EXPECTED SQL Exception: (42X01) Syntax error: Encountered "-" at line 1, column 86. :
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "-" at line 1, column 86.
DEFINED PROCEDURES FOR DRS
APP.DRS AS org.apache.derbyTesting.functionTests.util.ProcedureTest.selectRows(IN P1 INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA DYNAMIC RESULT SETS 1
DATABASE METATDATA PROCEDURES FOR DRS
@@ -169,9 +169,9 @@
procedureColumnIn P1 INTEGER
-----
CALL DRS()
-EXPECTED SQL Exception: (42Y03) 'DRS' is not recognized as a function or procedure. :
+EXPECTED SQL Exception: (42Y03) 'DRS' is not recognized as a function or procedure.
CALL DRS(?,?)
-EXPECTED SQL Exception: (42Y03) 'DRS' is not recognized as a function or procedure. :
+EXPECTED SQL Exception: (42Y03) 'DRS' is not recognized as a function or procedure.
I |B
-----
3 |int
@@ -205,9 +205,9 @@
6 |'012345678
7 |int
CALL IRDRS(?)
-EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.missingDynamicParameter(int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible. :
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.missingDynamicParameter(int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
CALL rsi(?)
-EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.badDynamicParameter(int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible. :
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.badDynamicParameter(int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
no dynamic result sets
No ResultSet or update count returned
Testing too many result sets
@@ -283,8 +283,8 @@
procedureColumnInOut P_INOUT SMALLINT
procedureColumnOut P_OUT SMALLINT
-----
-EXPECTED SQL Exception: (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'. :
-EXPECTED SQL Exception: (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'. :
+EXPECTED SQL Exception: (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'.
+EXPECTED SQL Exception: (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'.
p_inout 9 p_out 6
p_inout 9 null?false p_out 6 null?false
p_inout 9 null?false p_out 6 null?false
@@ -331,7 +331,7 @@
OP4 11.3 >28.30< null ? false
No ResultSet or update count returned
OP4 39.345 >56.34< null ? false
-EXPECTED SQL Exception: The resulting value is outside the range for the data type DECIMAL/NUMERIC(4,2). :
+EXPECTED SQL Exception: The resulting value is outside the range for the data type DECIMAL/NUMERIC(4,2).
No ResultSet or update count returned
OP4 49.345 >66.34< null ? false
EXPECTED SQL Exception: Invalid argument: parameter index 2 is not an OUT or INOUT parameter.
@@ -351,7 +351,7 @@
OP4INOUT 14+23.5 >37.50< null ? false
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: 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: (07000) At least one parameter to the current statement is uninitialized.
SQL Control
@@ -895,11 +895,11 @@
procedureColumnIn P1 VARCHAR
procedureColumnOut P2 VARCHAR
-----
-CALL LITT.TY_SMALLINT (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'. :
-CALL LITT.TY_INTEGER (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'int'. :
-CALL LITT.TY_BIGINT (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'long'. :
-CALL LITT.TY_REAL (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'float'. :
-CALL LITT.TY_DOUBLE (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'double'. :
+CALL LITT.TY_SMALLINT (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'.
+CALL LITT.TY_INTEGER (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'int'.
+CALL LITT.TY_BIGINT (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'long'.
+CALL LITT.TY_REAL (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'float'.
+CALL LITT.TY_DOUBLE (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'double'.
CALL LITT.TY_DECIMAL (null, ?)=>NULL<
CALL LITT.TY_CHAR (null, ?)=>NULL<
CALL LITT.TY_VARCHAR (null, ?)=>NULL<
@@ -909,30 +909,30 @@
CALL LITT.TY_REAL (12, ?)=>12.0<
CALL LITT.TY_DOUBLE (12, ?)=>12.0<
CALL LITT.TY_DECIMAL (12, ?)=>12.00<
-CALL LITT.TY_CHAR (12, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'INTEGER'. :
-CALL LITT.TY_VARCHAR (12, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'INTEGER'. :
+CALL LITT.TY_CHAR (12, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'INTEGER'.
+CALL LITT.TY_VARCHAR (12, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'INTEGER'.
CALL LITT.TY_SMALLINT (23.43e1, ?)=>234<
CALL LITT.TY_INTEGER (23.43e1, ?)=>234<
CALL LITT.TY_BIGINT (23.43e1, ?)=>234<
CALL LITT.TY_REAL (23.43e1, ?)=>234.3<
CALL LITT.TY_DOUBLE (23.43e1, ?)=>234.3<
CALL LITT.TY_DECIMAL (23.43e1, ?)=>234.30<
-CALL LITT.TY_CHAR (23.43e1, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'DOUBLE'. :
-CALL LITT.TY_VARCHAR (23.43e1, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'DOUBLE'. :
+CALL LITT.TY_CHAR (23.43e1, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'DOUBLE'.
+CALL LITT.TY_VARCHAR (23.43e1, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'DOUBLE'.
CALL LITT.TY_SMALLINT (176.3, ?)=>176<
CALL LITT.TY_INTEGER (176.3, ?)=>176<
CALL LITT.TY_BIGINT (176.3, ?)=>176<
CALL LITT.TY_REAL (176.3, ?)=>176.3<
CALL LITT.TY_DOUBLE (176.3, ?)=>176.3<
CALL LITT.TY_DECIMAL (176.3, ?)=>176.30<
-CALL LITT.TY_CHAR (176.3, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'DECIMAL'. :
-CALL LITT.TY_VARCHAR (176.3, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'DECIMAL'. :
-CALL LITT.TY_SMALLINT ('12.34', ?) (42821) Columns of type 'SMALLINT' cannot hold values of type 'CHAR'. :
-CALL LITT.TY_INTEGER ('12.34', ?) (42821) Columns of type 'INTEGER' cannot hold values of type 'CHAR'. :
-CALL LITT.TY_BIGINT ('12.34', ?) (42821) Columns of type 'BIGINT' cannot hold values of type 'CHAR'. :
-CALL LITT.TY_REAL ('12.34', ?) (42821) Columns of type 'REAL' cannot hold values of type 'CHAR'. :
-CALL LITT.TY_DOUBLE ('12.34', ?) (42821) Columns of type 'DOUBLE' cannot hold values of type 'CHAR'. :
-CALL LITT.TY_DECIMAL ('12.34', ?) (42821) Columns of type 'DECIMAL' cannot hold values of type 'CHAR'. :
+CALL LITT.TY_CHAR (176.3, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'DECIMAL'.
+CALL LITT.TY_VARCHAR (176.3, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'DECIMAL'.
+CALL LITT.TY_SMALLINT ('12.34', ?) (42821) Columns of type 'SMALLINT' cannot hold values of type 'CHAR'.
+CALL LITT.TY_INTEGER ('12.34', ?) (42821) Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
+CALL LITT.TY_BIGINT ('12.34', ?) (42821) Columns of type 'BIGINT' cannot hold values of type 'CHAR'.
+CALL LITT.TY_REAL ('12.34', ?) (42821) Columns of type 'REAL' cannot hold values of type 'CHAR'.
+CALL LITT.TY_DOUBLE ('12.34', ?) (42821) Columns of type 'DOUBLE' cannot hold values of type 'CHAR'.
+CALL LITT.TY_DECIMAL ('12.34', ?) (42821) Columns of type 'DECIMAL' cannot hold values of type 'CHAR'.
CALL LITT.TY_CHAR ('12.34', ?)=>12.34 <
CALL LITT.TY_VARCHAR ('12.34', ?)=>12.34<
MultipleRSAutoCommit: PASS.
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=393239&r1=393238&r2=393239&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 Tue Apr 11 07:49:30 2006
@@ -61,14 +61,14 @@
Make sure that we got CONCUR_UPDATABLE? true
Now attempt a deleteRow without first doing next on the resultset.
SQL State : XCL08
-Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row. :
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row.
Now attempt a updateRow without first doing next on the resultset.
updateRow will check if it is on a row or not even though no changes have been made to the row using updateXXX
SQL State : null
Got expected exception Invalid operation to update at current cursor position
ResultSet is positioned after the last row. attempt to deleteRow at this point should fail!
SQL State : XCL07
-Got expected exception Cursor '<xxx-cursor-name-xxx>' is closed. Verify that autocommit is OFF. :
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is closed. Verify that autocommit is OFF.
ResultSet is positioned after the last row. attempt to updateRow at this point should fail!
SQL State : null
Got expected exception Invalid operation to update at current cursor position
@@ -80,31 +80,31 @@
Got expected exception Invalid operation: result set closed
Negative Test9 - try updatable resultset on system table
SQL State : 42Y90
-Got expected exception FOR UPDATE is not permitted in this type of statement. :
+Got expected exception FOR UPDATE is not permitted in this type of statement.
Negative Test10 - try updatable resultset on a view
SQL State : 42Y90
-Got expected exception FOR UPDATE is not permitted in this type of statement. :
+Got expected exception FOR UPDATE is not permitted in this type of statement.
Negative Test11 - attempt to open updatable resultset when there is join in the select query should fail
SQL State : 42Y90
-Got expected exception FOR UPDATE is not permitted in this type of statement. :
+Got expected exception FOR UPDATE is not permitted in this type of statement.
Negative Test12 - With autocommit on, attempt to drop a table when there is an open updatable resultset on it
Opened an updatable resultset. Now trying to drop that table through another Statement
SQL State : X0X95
-Got expected exception Operation 'DROP TABLE' cannot be performed on object 'T1' because there is an open ResultSet dependent on that object. :
+Got expected exception Operation 'DROP TABLE' cannot be performed on object 'T1' because there is an open ResultSet dependent on that object.
Since autocommit is on, the drop table exception resulted in a runtime rollback causing updatable resultset object to close
SQL State : 24000
-Got expected exception Invalid cursor state - no current row. :
+Got expected exception Invalid cursor state - no current row.
SQL State : 24000
-Got expected exception Invalid cursor state - no current row. :
+Got expected exception Invalid cursor state - no current row.
Negative Test13 - foreign key constraint failure will cause deleteRow to fail
SQL State : 23503
-Got expected exception DELETE on table 'TABLEWITHPRIMARYKEY' caused a violation of foreign key constraint 'FK' for key (1,1). The statement has been rolled back. :
+Got expected exception DELETE on table 'TABLEWITHPRIMARYKEY' caused a violation of foreign key constraint 'FK' for key (1,1). The statement has been rolled back.
Since autocommit is on, the constraint exception resulted in a runtime rollback causing updatable resultset object to close
Jira entry Derby-160 : for Network Server because next should have failed
FAIL!!! next should have failed because foreign key constraint failure resulted in a runtime rollback
Negative Test14 - foreign key constraint failure will cause updateRow to fail
SQL State : 23503
-Got expected exception UPDATE on table 'TABLEWITHPRIMARYKEY' caused a violation of foreign key constraint 'FK' for key (1,1). The statement has been rolled back. :
+Got expected exception UPDATE on table 'TABLEWITHPRIMARYKEY' caused a violation of foreign key constraint 'FK' for key (1,1). The statement has been rolled back.
Since autocommit is on, the constraint exception resulted in a runtime rollback causing updatable resultset object to close
Jira entry Derby-160 : for Network Server because next should have failed
FAIL!!! next should have failed because foreign key constraint failure resulted in a runtime rollback
@@ -127,7 +127,7 @@
Got expected exception Invalid operation to read at current cursor position.
calling deleteRow again w/o first positioning the ResultSet on the next row will fail
SQL State : XCL08
-Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row. :
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row.
Position the ResultSet with next()
Should be able to deletRow() on the current row now
Positive Test1b - request updatable resultset for forward only type resultset
@@ -153,7 +153,7 @@
column 2 on this deleted row is aa
doing positioned delete again w/o first positioning the ResultSet on the next row will fail
SQL State : XCL08
-Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row. :
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row.
Position the ResultSet with next()
Should be able to do positioned delete on the current row now
Positive Test1d - updatable resultset to do positioned update
@@ -177,7 +177,7 @@
{3}
column 1 on this row is 1
SQL State : 42X01
-Got expected exception Syntax error: Encountered "WHERE" at line 1, column 14. :
+Got expected exception Syntax error: Encountered "WHERE" at line 1, column 14.
total number of rows in T1 after one deleteRow is
1
-
@@ -192,7 +192,7 @@
Got expected exception Invalid operation to read at current cursor position.
calling deleteRow again w/o first positioning the ResultSet on the next row will fail
SQL State : XCL08
-Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row. :
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row.
Position the ResultSet with next()
Should be able to deletRow() on the current row now
Positive Test3b - use prepared statement with concur updatable status to test updateXXX
@@ -223,7 +223,7 @@
Got expected exception Invalid operation to read at current cursor position.
calling deleteRow again w/o first positioning the ResultSet on the next row will fail
SQL State : XCL08
-Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row. :
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row.
Position the ResultSet with next()
Should be able to deletRow() on the current row now
Positive Test5 - donot have to select primary key to get an updatable resultset
@@ -296,7 +296,7 @@
attempt to get an updatable resultset using correlation name for an updatable column
The sql is SELECT c1 as col1, c2 as col2 FROM t1 abcde FOR UPDATE of c1
SQL State : 42X42
-Got expected exception Correlation name not allowed for column 'C1' because it is part of the FOR UPDATE list. :
+Got expected exception Correlation name not allowed for column 'C1' because it is part of the FOR UPDATE list.
attempt to get an updatable resultset using correlation name for an readonly column. It should work
The sql is SELECT c1, c2 as col2 FROM t1 abcde FOR UPDATE of c1
Table t1 after updateRow has following rows
@@ -329,7 +329,7 @@
delete using first resultset
attempt to send deleteRow on the same row through a different resultset should throw an exception
SQL State : XCL08
-Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row. :
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is not on a row.
Move to next row in the 2nd resultset and then delete using the second resultset
Positive Test11 - setting the fetch size to > 1 will be ignored by updatable resultset. Same as updatable cursors
Notice the Fetch Size in run time statistics output.
@@ -397,7 +397,7 @@
column 1 on this row is 1
this delete row will fire the delete trigger which will delete all the rows from the table and from the resultset
SQL State : XCL07
-Got expected exception Cursor '<xxx-cursor-name-xxx>' is closed. Verify that autocommit is OFF. :
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is closed. Verify that autocommit is OFF.
Verify that delete trigger got fired by verifying the row count to be 0 in table1WithTriggers
1
-
@@ -431,7 +431,7 @@
column 1 on this row is e1
this delete row will cause the delete cascade constraint to delete all the rows from the table and from the resultset
SQL State : XCL07
-Got expected exception Cursor '<xxx-cursor-name-xxx>' is closed. Verify that autocommit is OFF. :
+Got expected exception Cursor '<xxx-cursor-name-xxx>' is closed. Verify that autocommit is OFF.
Verify that delete trigger got fired by verifying the row count to be 0 in selfReferencingT1
1
-
@@ -446,11 +446,11 @@
column 1 on this row is e1
update row should fail because cascade constraint is update restrict
SQL State : 23503
-Got expected exception UPDATE on table 'SELFREFERENCINGT2' caused a violation of foreign key constraint 'MANAGES2' for key (e1). The statement has been rolled back. :
+Got expected exception UPDATE on table 'SELFREFERENCINGT2' caused a violation of foreign key constraint 'MANAGES2' for key (e1). The statement has been rolled back.
Positive Test15 - With autocommit off, attempt to drop a table when there is an open updatable resultset on it
Opened an updatable resultset. Now trying to drop that table through another Statement
SQL State : X0X95
-Got expected exception Operation 'DROP TABLE' cannot be performed on object 'T1' because there is an open ResultSet dependent on that object. :
+Got expected exception Operation 'DROP TABLE' cannot be performed on object 'T1' because there is an open ResultSet dependent on that object.
Since autocommit is off, the drop table exception will NOT result in a runtime rollback and hence updatable resultset object is still open
Positive Test16a - Do deleteRow within a transaction and then rollback the transaction
Verify that before delete trigger got fired, row count is 0 in deleteTriggerInsertIntoThisTable
@@ -2601,9 +2601,9 @@
updateObject with column name & TimeStamp object as parameters
Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'BINARY'.
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. :
+ 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. :
+ 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 : An attempt was made to put a data value of type 'byte' into a data value of type 'BINARY'.
updateObject with column name & Boolean object as parameters
@@ -2658,9 +2658,9 @@
updateObject with column name & TimeStamp object as parameters
Got expected exception : An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'VARBINARY'.
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. :
+ 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. :
+ 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 : An attempt was made to put a data value of type 'byte' into a data value of type 'VARBINARY'.
updateObject with column name & Boolean object as parameters
@@ -3179,7 +3179,7 @@
Positive test 37.c - check that getXXX gets undefined values when updateXXX has not been called yet on insertRow
Negative Test 38 - insertRow: do not set a value to all not nullable columns
SQL State: 23502
-Got expected exception: Column 'C41' cannot accept a NULL value. :
+Got expected exception: Column 'C41' cannot accept a NULL value.
Negative Test 39 - run updateRow and deleterow when positioned at insertRow
Negative Test 39.a - run updateRow on insertRow
SQL State: null
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Stream.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Stream.out?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Stream.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Stream.out Tue Apr 11 07:49:30 2006
@@ -1,16 +1,16 @@
-get stream from SMALL_BLOB_TABLE.SMALL_BLOB ...
-get stream from SMALL_BLOB_TABLE.SMALL_BLOB again ...
-Expected exception may happen.
-SQL Exception: Stream of column value in result cannot be retrieved twice
-get stream from LARGE_BLOB_TABLE.LARGE_BLOB ...
-get stream from LARGE_BLOB_TABLE.LARGE_BLOB again ...
-Expected exception may happen.
-SQL Exception: Stream of column value in result cannot be retrieved twice
-get reader from SMALL_CLOB_TABLE.SMALL_CLOB ...
-get reader from SMALL_CLOB_TABLE.SMALL_CLOBagain ...
-Expected exception may happen.
-SQL Exception: Stream of column value in result cannot be retrieved twice
-get reader from LARGE_CLOB_TABLE.LARGE_CLOB ...
-get reader from LARGE_CLOB_TABLE.LARGE_CLOBagain ...
-Expected exception may happen.
-SQL Exception: Stream of column value in result cannot be retrieved twice
\ No newline at end of file
+get stream from SMALL_BLOB_TABLE.SMALL_BLOB ...
+get stream from SMALL_BLOB_TABLE.SMALL_BLOB again ...
+Expected exception may happen.
+Stream of column value in result cannot be retrieved twice
+get stream from LARGE_BLOB_TABLE.LARGE_BLOB ...
+get stream from LARGE_BLOB_TABLE.LARGE_BLOB again ...
+Expected exception may happen.
+Stream of column value in result cannot be retrieved twice
+get reader from SMALL_CLOB_TABLE.SMALL_CLOB ...
+get reader from SMALL_CLOB_TABLE.SMALL_CLOBagain ...
+Expected exception may happen.
+Stream of column value in result cannot be retrieved twice
+get reader from LARGE_CLOB_TABLE.LARGE_CLOB ...
+get reader from LARGE_CLOB_TABLE.LARGE_CLOBagain ...
+Expected exception may happen.
+Stream of column value in result cannot be retrieved twice
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/closed.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/closed.out?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/closed.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/closed.out Tue Apr 11 07:49:30 2006
@@ -13,16 +13,16 @@
ERROR 08003: No current connection.
Test database shutdown ...
SQL Exception: Database 'wombat' shutdown.
-Caused by: ERROR 08006: Database 'wombat' shutdown.
- ... 10 more
+Caused by: SQL Exception: Database 'wombat' shutdown.
+ ... 13 more
CALL sleep(10000) - 38000, 38000 -- InterruptedException, XJ001 -- InterruptedException
LOCK TABLE CLOSED.LOCKME IN EXCLUSIVE MODE - 08006, 08006 -- Database 'wombat' shutdown.
ERROR 08006: Database 'wombat' shutdown.
Shutdown test completed.
Test system shutdown ...
SQL Exception: Database 'wombat' shutdown.
-Caused by: ERROR 08006: Database 'wombat' shutdown.
- ... 10 more
+Caused by: SQL Exception: Database 'wombat' shutdown.
+ ... 13 more
CALL sleep(10000) - 38000, 38000 -- InterruptedException, XJ001 -- InterruptedException
LOCK TABLE CLOSED.LOCKME IN EXCLUSIVE MODE - 08006, 08006 -- Database 'wombat' shutdown.
ERROR XJ015: Derby system shutdown.