You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by fu...@apache.org on 2006/09/01 16:38:25 UTC
svn commit: r439335 [4/5] - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master:
j9_13/outparams.out j9_13/parameterMapping.out j9_foundation/outparams.out
j9_foundation/parameterMapping.out
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/outparams.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/outparams.out?rev=439335&r1=439334&r2=439335&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/outparams.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/outparams.out Fri Sep 1 07:38:24 2006
@@ -1,13 +1,13 @@
==============================================
TESTING BOUNDARY CONDITIONS
==============================================
-Expected exception SQL Exception: Parameter 2 cannot be registered as an OUT parameter because it is an IN parameter.
-Expected exception SQL Exception: The parameter position '9' is out of range. The number of parameters for this prepared statement is '2'.
-Expected exception SQL Exception: The parameter position '0' is out of range. The number of parameters for this prepared statement is '2'.
-Expected exception SQL Exception: Return output parameters cannot be set.
-Expected exception SQL Exception: Return output parameters cannot be set.
-Expected exception on setString() on a return output param: SQL Exception: Return output parameters cannot be set.
-Expected exception on prepare of '? = call returnsNothing()': SQL Exception: 'RETURNSNOTHING' is not recognized as a function or procedure.
+Expected exception java.sql.SQLException: Parameter 2 cannot be registered as an OUT parameter because it is an IN parameter.
+Expected exception java.sql.SQLException: The parameter position '9' is out of range. The number of parameters for this prepared statement is '2'.
+Expected exception java.sql.SQLException: The parameter position '0' is out of range. The number of parameters for this prepared statement is '2'.
+Expected exception java.sql.SQLException: Return output parameters cannot be set.
+Expected exception java.sql.SQLException: Return output parameters cannot be set.
+Expected exception on setString() on a return output param: java.sql.SQLException: Return output parameters cannot be set.
+Expected exception on prepare of '? = call returnsNothing()': java.sql.SQLException: 'RETURNSNOTHING' is not recognized as a function or procedure.
==============================================
TESTING NULLS
==============================================
@@ -24,47 +24,47 @@
------------------------------------
{call takesNothing()}
cs.registerOutParameter(1, BIT)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, BOOLEAN)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, TINYINT)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, SMALLINT)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, INTEGER)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, BIGINT)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, FLOAT)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, REAL)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, DOUBLE)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, NUMERIC)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, DECIMAL)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, CHAR)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, VARCHAR)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, LONGVARCHAR)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, DATE)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, TIME)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, TIMESTAMP)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, BINARY)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, VARBINARY)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, LONGVARBINARY)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
cs.registerOutParameter(1, OTHER)
- Exception SQL Exception: No input parameters.
+ Exception java.sql.SQLException: No input parameters.
------------------------------------
call takesShortPrimitive(?,?)
cs.registerOutParameter(1, BIT)
@@ -84,12 +84,12 @@
getString(1) = 2
getString(1) = 2
getString(1) = 2
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
getObject(1) = 2
cs.registerOutParameter(1, BOOLEAN)
setBoolean(1, true)
@@ -108,12 +108,12 @@
getString(1) = 2
getString(1) = 2
getString(1) = 2
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
getObject(1) = 2
cs.registerOutParameter(1, TINYINT)
setByte(1, 6)
@@ -132,19 +132,19 @@
getString(1) = 12
getString(1) = 12
getString(1) = 12
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
getObject(1) = 12
cs.registerOutParameter(1, SMALLINT)
setShort(1, 66)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 132
getInt(1) = 132
getLong(1) = 132
@@ -156,19 +156,19 @@
getString(1) = 132
getString(1) = 132
getString(1) = 132
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
getObject(1) = 132
cs.registerOutParameter(1, INTEGER)
setInt(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -180,19 +180,19 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
getObject(1) = 1332
cs.registerOutParameter(1, BIGINT)
setLong(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -204,19 +204,19 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
getObject(1) = 1332
cs.registerOutParameter(1, FLOAT)
setFLoat(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -228,19 +228,19 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
getObject(1) = 1332
cs.registerOutParameter(1, REAL)
setFLoat(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -252,19 +252,19 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
getObject(1) = 1332
cs.registerOutParameter(1, DOUBLE)
setDouble(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -276,42 +276,42 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
getObject(1) = 1332
cs.registerOutParameter(1, NUMERIC)
setBigDecimal(1, 666.666)
- Exception SQL Exception: Invalid character string format for type SMALLINT.
+ Exception java.sql.SQLException: Invalid character string format for type SMALLINT.
cs.registerOutParameter(1, DECIMAL)
setBigDecimal(1, 666.666)
- Exception SQL Exception: Invalid character string format for type SMALLINT.
+ Exception java.sql.SQLException: Invalid character string format for type SMALLINT.
cs.registerOutParameter(1, CHAR)
setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type SMALLINT.
+ Exception java.sql.SQLException: Invalid character string format for type SMALLINT.
cs.registerOutParameter(1, VARCHAR)
setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type SMALLINT.
+ Exception java.sql.SQLException: Invalid character string format for type SMALLINT.
cs.registerOutParameter(1, LONGVARCHAR)
setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type SMALLINT.
+ Exception java.sql.SQLException: Invalid character string format for type SMALLINT.
cs.registerOutParameter(1, DATE)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type DATE because it maps to type SMALLINT and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type DATE because it maps to type SMALLINT and they are incompatible.
cs.registerOutParameter(1, TIME)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type TIME because it maps to type SMALLINT and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIME because it maps to type SMALLINT and they are incompatible.
cs.registerOutParameter(1, TIMESTAMP)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type SMALLINT and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type SMALLINT and they are incompatible.
cs.registerOutParameter(1, BINARY)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type BINARY because it maps to type SMALLINT and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type BINARY because it maps to type SMALLINT and they are incompatible.
cs.registerOutParameter(1, VARBINARY)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type SMALLINT and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type SMALLINT and they are incompatible.
cs.registerOutParameter(1, LONGVARBINARY)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type SMALLINT and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type SMALLINT and they are incompatible.
cs.registerOutParameter(1, OTHER)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type OTHER because it maps to type SMALLINT and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type OTHER because it maps to type SMALLINT and they are incompatible.
------------------------------------
call takesIntegerPrimitive(?,?)
cs.registerOutParameter(1, BIT)
@@ -331,12 +331,12 @@
getString(1) = 2
getString(1) = 2
getString(1) = 2
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
getObject(1) = 2
cs.registerOutParameter(1, BOOLEAN)
setBoolean(1, true)
@@ -355,12 +355,12 @@
getString(1) = 2
getString(1) = 2
getString(1) = 2
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
getObject(1) = 2
cs.registerOutParameter(1, TINYINT)
setByte(1, 6)
@@ -379,19 +379,19 @@
getString(1) = 12
getString(1) = 12
getString(1) = 12
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
getObject(1) = 12
cs.registerOutParameter(1, SMALLINT)
setShort(1, 66)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 132
getInt(1) = 132
getLong(1) = 132
@@ -403,19 +403,19 @@
getString(1) = 132
getString(1) = 132
getString(1) = 132
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
getObject(1) = 132
cs.registerOutParameter(1, INTEGER)
setInt(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -427,19 +427,19 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
getObject(1) = 1332
cs.registerOutParameter(1, BIGINT)
setLong(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -451,19 +451,19 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
getObject(1) = 1332
cs.registerOutParameter(1, FLOAT)
setFLoat(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -475,19 +475,19 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
getObject(1) = 1332
cs.registerOutParameter(1, REAL)
setFLoat(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -499,19 +499,19 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
getObject(1) = 1332
cs.registerOutParameter(1, DOUBLE)
setDouble(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -523,42 +523,42 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
getObject(1) = 1332
cs.registerOutParameter(1, NUMERIC)
setBigDecimal(1, 666.666)
- Exception SQL Exception: Invalid character string format for type INTEGER.
+ Exception java.sql.SQLException: Invalid character string format for type INTEGER.
cs.registerOutParameter(1, DECIMAL)
setBigDecimal(1, 666.666)
- Exception SQL Exception: Invalid character string format for type INTEGER.
+ Exception java.sql.SQLException: Invalid character string format for type INTEGER.
cs.registerOutParameter(1, CHAR)
setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type INTEGER.
+ Exception java.sql.SQLException: Invalid character string format for type INTEGER.
cs.registerOutParameter(1, VARCHAR)
setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type INTEGER.
+ Exception java.sql.SQLException: Invalid character string format for type INTEGER.
cs.registerOutParameter(1, LONGVARCHAR)
setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type INTEGER.
+ Exception java.sql.SQLException: Invalid character string format for type INTEGER.
cs.registerOutParameter(1, DATE)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type DATE because it maps to type INTEGER and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type DATE because it maps to type INTEGER and they are incompatible.
cs.registerOutParameter(1, TIME)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type TIME because it maps to type INTEGER and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIME because it maps to type INTEGER and they are incompatible.
cs.registerOutParameter(1, TIMESTAMP)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type INTEGER and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type INTEGER and they are incompatible.
cs.registerOutParameter(1, BINARY)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type BINARY because it maps to type INTEGER and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type BINARY because it maps to type INTEGER and they are incompatible.
cs.registerOutParameter(1, VARBINARY)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type INTEGER and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type INTEGER and they are incompatible.
cs.registerOutParameter(1, LONGVARBINARY)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type INTEGER and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type INTEGER and they are incompatible.
cs.registerOutParameter(1, OTHER)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type OTHER because it maps to type INTEGER and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type OTHER because it maps to type INTEGER and they are incompatible.
------------------------------------
call takesLongPrimitive(?,?)
cs.registerOutParameter(1, BIT)
@@ -578,12 +578,12 @@
getString(1) = 2
getString(1) = 2
getString(1) = 2
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
getObject(1) = 2
cs.registerOutParameter(1, BOOLEAN)
setBoolean(1, true)
@@ -602,12 +602,12 @@
getString(1) = 2
getString(1) = 2
getString(1) = 2
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
getObject(1) = 2
cs.registerOutParameter(1, TINYINT)
setByte(1, 6)
@@ -626,19 +626,19 @@
getString(1) = 12
getString(1) = 12
getString(1) = 12
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
getObject(1) = 12
cs.registerOutParameter(1, SMALLINT)
setShort(1, 66)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 132
getInt(1) = 132
getLong(1) = 132
@@ -650,19 +650,19 @@
getString(1) = 132
getString(1) = 132
getString(1) = 132
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
getObject(1) = 132
cs.registerOutParameter(1, INTEGER)
setInt(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -674,19 +674,19 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
getObject(1) = 1332
cs.registerOutParameter(1, BIGINT)
setLong(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -698,19 +698,19 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
getObject(1) = 1332
cs.registerOutParameter(1, FLOAT)
setFLoat(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -722,19 +722,19 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
getObject(1) = 1332
cs.registerOutParameter(1, REAL)
setFLoat(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -746,19 +746,19 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
getObject(1) = 1332
cs.registerOutParameter(1, DOUBLE)
setDouble(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -770,42 +770,42 @@
getString(1) = 1332
getString(1) = 1332
getString(1) = 1332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
getObject(1) = 1332
cs.registerOutParameter(1, NUMERIC)
setBigDecimal(1, 666.666)
- Exception SQL Exception: Invalid character string format for type BIGINT.
+ Exception java.sql.SQLException: Invalid character string format for type BIGINT.
cs.registerOutParameter(1, DECIMAL)
setBigDecimal(1, 666.666)
- Exception SQL Exception: Invalid character string format for type BIGINT.
+ Exception java.sql.SQLException: Invalid character string format for type BIGINT.
cs.registerOutParameter(1, CHAR)
setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type BIGINT.
+ Exception java.sql.SQLException: Invalid character string format for type BIGINT.
cs.registerOutParameter(1, VARCHAR)
setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type BIGINT.
+ Exception java.sql.SQLException: Invalid character string format for type BIGINT.
cs.registerOutParameter(1, LONGVARCHAR)
setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type BIGINT.
+ Exception java.sql.SQLException: Invalid character string format for type BIGINT.
cs.registerOutParameter(1, DATE)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type DATE because it maps to type BIGINT and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type DATE because it maps to type BIGINT and they are incompatible.
cs.registerOutParameter(1, TIME)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type TIME because it maps to type BIGINT and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIME because it maps to type BIGINT and they are incompatible.
cs.registerOutParameter(1, TIMESTAMP)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type BIGINT and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type BIGINT and they are incompatible.
cs.registerOutParameter(1, BINARY)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type BINARY because it maps to type BIGINT and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type BINARY because it maps to type BIGINT and they are incompatible.
cs.registerOutParameter(1, VARBINARY)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type BIGINT and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type BIGINT and they are incompatible.
cs.registerOutParameter(1, LONGVARBINARY)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type BIGINT and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type BIGINT and they are incompatible.
cs.registerOutParameter(1, OTHER)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type OTHER because it maps to type BIGINT and they are incompatible.
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type OTHER because it maps to type BIGINT and they are incompatible.
------------------------------------
call takesFloatPrimitive(?,?)
cs.registerOutParameter(1, BIT)
@@ -825,12 +825,12 @@
getString(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
getObject(1) = 2.0
cs.registerOutParameter(1, BOOLEAN)
setBoolean(1, true)
@@ -849,12 +849,12 @@
getString(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
getObject(1) = 2.0
cs.registerOutParameter(1, TINYINT)
setByte(1, 6)
@@ -873,19 +873,19 @@
getString(1) = 12.0
getString(1) = 12.0
getString(1) = 12.0
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
getObject(1) = 12.0
cs.registerOutParameter(1, SMALLINT)
setShort(1, 66)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 132
getInt(1) = 132
getLong(1) = 132
@@ -897,19 +897,19 @@
getString(1) = 132.0
getString(1) = 132.0
getString(1) = 132.0
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
getObject(1) = 132.0
cs.registerOutParameter(1, INTEGER)
setInt(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -921,19 +921,19 @@
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
getObject(1) = 1332.0
cs.registerOutParameter(1, BIGINT)
setLong(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -945,19 +945,19 @@
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
getObject(1) = 1332.0
cs.registerOutParameter(1, FLOAT)
setFLoat(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -969,19 +969,19 @@
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
getObject(1) = 1332.0
cs.registerOutParameter(1, REAL)
setFLoat(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -993,19 +993,19 @@
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
getObject(1) = 1332.0
cs.registerOutParameter(1, DOUBLE)
setDouble(1, 666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1332
getInt(1) = 1332
getLong(1) = 1332
@@ -1017,19 +1017,19 @@
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
getObject(1) = 1332.0
cs.registerOutParameter(1, NUMERIC)
setBigDecimal(1, 666.666)
cs.execute()
getBoolean(1) = true
getBoolean(1) = true
- getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT.
getShort(1) = 1333
getInt(1) = 1333
getLong(1) = 1333
@@ -1041,19 +1041,19 @@
getString(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
[... 8435 lines stripped ...]