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 km...@apache.org on 2005/10/01 01:51:02 UTC
svn commit: r292877 [2/3] - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation:
outparams.out resultset.out
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/outparams.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/outparams.out?rev=292877&r1=292876&r2=292877&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 30 16:50:59 2005
@@ -7760,15908 +7760,4 @@
8 = cloudscape was null false
9 = jbms was null false
10 = IBM CS was null false
-end testManyOut
-==============================================
-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.
-==============================================
-TESTING NULLS
-==============================================
-Test for bug 4317, passing null value for a parameter
-==============================================
-TESTING UPDATE COUNT
-==============================================
-executeUpdate on ? = call returnsIntegerP returned -1
-getString(1) returned 666
-==============================================
-TESTING NORMAL OUTPUT PARAMETERS
-==============================================
-...starting doing setXXX for each type xxx
-------------------------------------
-{call takesNothing()}
- cs.registerOutParameter(1, BIT)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, BOOLEAN)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, TINYINT)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, SMALLINT)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, INTEGER)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, BIGINT)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, FLOAT)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, REAL)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, DOUBLE)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, NUMERIC)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, DECIMAL)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, CHAR)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, VARCHAR)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, LONGVARCHAR)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, DATE)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, TIME)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, TIMESTAMP)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, BINARY)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, VARBINARY)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, LONGVARBINARY)
- Exception SQL Exception: No input parameters.
- cs.registerOutParameter(1, OTHER)
- Exception SQL Exception: No input parameters.
-------------------------------------
-call takesShortPrimitive(?,?)
- cs.registerOutParameter(1, BIT)
- setBoolean(1, true)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 2
- getShort(1) = 2
- getInt(1) = 2
- getLong(1) = 2
- getFloat(1) = 2.0
- getFloat(1) = 2.0
- getDouble(1) = 2.0
- getBigDecimal(1) = 2
- getBigDecimal(1) = 2
- 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'.
- getObject(1) = 2
- cs.registerOutParameter(1, BOOLEAN)
- setBoolean(1, true)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 2
- getShort(1) = 2
- getInt(1) = 2
- getLong(1) = 2
- getFloat(1) = 2.0
- getFloat(1) = 2.0
- getDouble(1) = 2.0
- getBigDecimal(1) = 2
- getBigDecimal(1) = 2
- 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'.
- getObject(1) = 2
- cs.registerOutParameter(1, TINYINT)
- setByte(1, 6)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 12
- getShort(1) = 12
- getInt(1) = 12
- getLong(1) = 12
- getFloat(1) = 12.0
- getFloat(1) = 12.0
- getDouble(1) = 12.0
- getBigDecimal(1) = 12
- getBigDecimal(1) = 12
- 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'.
- 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.
- getShort(1) = 132
- getInt(1) = 132
- getLong(1) = 132
- getFloat(1) = 132.0
- getFloat(1) = 132.0
- getDouble(1) = 132.0
- getBigDecimal(1) = 132
- getBigDecimal(1) = 132
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- getObject(1) = 1332
- cs.registerOutParameter(1, NUMERIC)
- setBigDecimal(1, 666.666)
- Exception SQL Exception: 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.
- cs.registerOutParameter(1, CHAR)
- setString(1, "Set via setString()")
- Exception SQL Exception: 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.
- cs.registerOutParameter(1, LONGVARCHAR)
- setString(1, "Set via setString()")
- Exception SQL Exception: 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
-------------------------------------
-call takesIntegerPrimitive(?,?)
- cs.registerOutParameter(1, BIT)
- setBoolean(1, true)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 2
- getShort(1) = 2
- getInt(1) = 2
- getLong(1) = 2
- getFloat(1) = 2.0
- getFloat(1) = 2.0
- getDouble(1) = 2.0
- getBigDecimal(1) = 2
- getBigDecimal(1) = 2
- 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'.
- getObject(1) = 2
- cs.registerOutParameter(1, BOOLEAN)
- setBoolean(1, true)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 2
- getShort(1) = 2
- getInt(1) = 2
- getLong(1) = 2
- getFloat(1) = 2.0
- getFloat(1) = 2.0
- getDouble(1) = 2.0
- getBigDecimal(1) = 2
- getBigDecimal(1) = 2
- 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'.
- getObject(1) = 2
- cs.registerOutParameter(1, TINYINT)
- setByte(1, 6)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 12
- getShort(1) = 12
- getInt(1) = 12
- getLong(1) = 12
- getFloat(1) = 12.0
- getFloat(1) = 12.0
- getDouble(1) = 12.0
- getBigDecimal(1) = 12
- getBigDecimal(1) = 12
- 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'.
- 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.
- getShort(1) = 132
- getInt(1) = 132
- getLong(1) = 132
- getFloat(1) = 132.0
- getFloat(1) = 132.0
- getDouble(1) = 132.0
- getBigDecimal(1) = 132
- getBigDecimal(1) = 132
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- getObject(1) = 1332
- cs.registerOutParameter(1, NUMERIC)
- setBigDecimal(1, 666.666)
- Exception SQL Exception: 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.
- cs.registerOutParameter(1, CHAR)
- setString(1, "Set via setString()")
- Exception SQL Exception: 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.
- cs.registerOutParameter(1, LONGVARCHAR)
- setString(1, "Set via setString()")
- Exception SQL Exception: 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
-------------------------------------
-call takesLongPrimitive(?,?)
- cs.registerOutParameter(1, BIT)
- setBoolean(1, true)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 2
- getShort(1) = 2
- getInt(1) = 2
- getLong(1) = 2
- getFloat(1) = 2.0
- getFloat(1) = 2.0
- getDouble(1) = 2.0
- getBigDecimal(1) = 2
- getBigDecimal(1) = 2
- 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'.
- getObject(1) = 2
- cs.registerOutParameter(1, BOOLEAN)
- setBoolean(1, true)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 2
- getShort(1) = 2
- getInt(1) = 2
- getLong(1) = 2
- getFloat(1) = 2.0
- getFloat(1) = 2.0
- getDouble(1) = 2.0
- getBigDecimal(1) = 2
- getBigDecimal(1) = 2
- 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'.
- getObject(1) = 2
- cs.registerOutParameter(1, TINYINT)
- setByte(1, 6)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 12
- getShort(1) = 12
- getInt(1) = 12
- getLong(1) = 12
- getFloat(1) = 12.0
- getFloat(1) = 12.0
- getDouble(1) = 12.0
- getBigDecimal(1) = 12
- getBigDecimal(1) = 12
- 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'.
- 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.
- getShort(1) = 132
- getInt(1) = 132
- getLong(1) = 132
- getFloat(1) = 132.0
- getFloat(1) = 132.0
- getDouble(1) = 132.0
- getBigDecimal(1) = 132
- getBigDecimal(1) = 132
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
- 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'.
- getObject(1) = 1332
- cs.registerOutParameter(1, NUMERIC)
- setBigDecimal(1, 666.666)
- Exception SQL Exception: 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.
- cs.registerOutParameter(1, CHAR)
- setString(1, "Set via setString()")
- Exception SQL Exception: 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.
- cs.registerOutParameter(1, LONGVARCHAR)
- setString(1, "Set via setString()")
- Exception SQL Exception: 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
-------------------------------------
-call takesFloatPrimitive(?,?)
- cs.registerOutParameter(1, BIT)
- setBoolean(1, true)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 2
- getShort(1) = 2
- getInt(1) = 2
- getLong(1) = 2
- getFloat(1) = 2.0
- getFloat(1) = 2.0
- getDouble(1) = 2.0
- getBigDecimal(1) = 2.0
- getBigDecimal(1) = 2.0
- 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'.
- getObject(1) = 2.0
- cs.registerOutParameter(1, BOOLEAN)
- setBoolean(1, true)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 2
- getShort(1) = 2
- getInt(1) = 2
- getLong(1) = 2
- getFloat(1) = 2.0
- getFloat(1) = 2.0
- getDouble(1) = 2.0
- getBigDecimal(1) = 2.0
- getBigDecimal(1) = 2.0
- 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'.
- getObject(1) = 2.0
- cs.registerOutParameter(1, TINYINT)
- setByte(1, 6)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 12
- getShort(1) = 12
- getInt(1) = 12
- getLong(1) = 12
- getFloat(1) = 12.0
- getFloat(1) = 12.0
- getDouble(1) = 12.0
- getBigDecimal(1) = 12.0
- getBigDecimal(1) = 12.0
- 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'.
- 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.
- getShort(1) = 132
- getInt(1) = 132
- getLong(1) = 132
- getFloat(1) = 132.0
- getFloat(1) = 132.0
- getDouble(1) = 132.0
- getBigDecimal(1) = 132.0
- getBigDecimal(1) = 132.0
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332.0
- getBigDecimal(1) = 1332.0
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332.0
- getBigDecimal(1) = 1332.0
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332.0
- getBigDecimal(1) = 1332.0
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332.0
- getBigDecimal(1) = 1332.0
- 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'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332.0
- getBigDecimal(1) = 1332.0
- 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'.
- 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.
- getShort(1) = 1333
- getInt(1) = 1333
- getLong(1) = 1333
- getFloat(1) = 1333.332
- getFloat(1) = 1333.332
- getDouble(1) = 1333.33203125
- getBigDecimal(1) = 1333.332
- getBigDecimal(1) = 1333.332
- 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'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getObject(1) = 1333.332
- cs.registerOutParameter(1, DECIMAL)
- 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.
- getShort(1) = 1333
- getInt(1) = 1333
- getLong(1) = 1333
- getFloat(1) = 1333.332
- getFloat(1) = 1333.332
- getDouble(1) = 1333.33203125
- getBigDecimal(1) = 1333.332
- getBigDecimal(1) = 1333.332
- 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'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
- getObject(1) = 1333.332
- cs.registerOutParameter(1, CHAR)
- setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type REAL.
- cs.registerOutParameter(1, VARCHAR)
- setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type REAL.
- cs.registerOutParameter(1, LONGVARCHAR)
- setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type REAL.
- cs.registerOutParameter(1, DATE)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type DATE because it maps to type REAL 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 REAL 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 REAL 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 REAL 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 REAL 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 REAL 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 REAL and they are incompatible.
-------------------------------------
-call takesDoublePrimitive(?,?)
- cs.registerOutParameter(1, BIT)
- setBoolean(1, true)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 2
- getShort(1) = 2
- getInt(1) = 2
- getLong(1) = 2
- getFloat(1) = 2.0
- getFloat(1) = 2.0
- getDouble(1) = 2.0
- getBigDecimal(1) = 2.0
- getBigDecimal(1) = 2.0
- 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 'DOUBLE'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getObject(1) = 2.0
- cs.registerOutParameter(1, BOOLEAN)
- setBoolean(1, true)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 2
- getShort(1) = 2
- getInt(1) = 2
- getLong(1) = 2
- getFloat(1) = 2.0
- getFloat(1) = 2.0
- getDouble(1) = 2.0
- getBigDecimal(1) = 2.0
- getBigDecimal(1) = 2.0
- 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 'DOUBLE'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getObject(1) = 2.0
- cs.registerOutParameter(1, TINYINT)
- setByte(1, 6)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = 12
- getShort(1) = 12
- getInt(1) = 12
- getLong(1) = 12
- getFloat(1) = 12.0
- getFloat(1) = 12.0
- getDouble(1) = 12.0
- getBigDecimal(1) = 12.0
- getBigDecimal(1) = 12.0
- 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 'DOUBLE'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- 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.
- getShort(1) = 132
- getInt(1) = 132
- getLong(1) = 132
- getFloat(1) = 132.0
- getFloat(1) = 132.0
- getDouble(1) = 132.0
- getBigDecimal(1) = 132.0
- getBigDecimal(1) = 132.0
- 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 'DOUBLE'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332.0
- getBigDecimal(1) = 1332.0
- 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 'DOUBLE'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332.0
- getBigDecimal(1) = 1332.0
- 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 'DOUBLE'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332.0
- getBigDecimal(1) = 1332.0
- 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 'DOUBLE'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332.0
- getBigDecimal(1) = 1332.0
- 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 'DOUBLE'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- 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.
- getShort(1) = 1332
- getInt(1) = 1332
- getLong(1) = 1332
- getFloat(1) = 1332.0
- getFloat(1) = 1332.0
- getDouble(1) = 1332.0
- getBigDecimal(1) = 1332.0
- getBigDecimal(1) = 1332.0
- 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 'DOUBLE'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- 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.
- getShort(1) = 1333
- getInt(1) = 1333
- getLong(1) = 1333
- getFloat(1) = 1333.332
- getFloat(1) = 1333.332
- getDouble(1) = 1333.332
- getBigDecimal(1) = 1333.332
- getBigDecimal(1) = 1333.332
- 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 'DOUBLE'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getObject(1) = 1333.332
- cs.registerOutParameter(1, DECIMAL)
- 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.
- getShort(1) = 1333
- getInt(1) = 1333
- getLong(1) = 1333
- getFloat(1) = 1333.332
- getFloat(1) = 1333.332
- getDouble(1) = 1333.332
- getBigDecimal(1) = 1333.332
- getBigDecimal(1) = 1333.332
- 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 'DOUBLE'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
- getObject(1) = 1333.332
- cs.registerOutParameter(1, CHAR)
- setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type DOUBLE.
- cs.registerOutParameter(1, VARCHAR)
- setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type DOUBLE.
- cs.registerOutParameter(1, LONGVARCHAR)
- setString(1, "Set via setString()")
- Exception SQL Exception: Invalid character string format for type DOUBLE.
- cs.registerOutParameter(1, DATE)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type DATE because it maps to type DOUBLE 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 DOUBLE 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 DOUBLE 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 DOUBLE 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 DOUBLE 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 DOUBLE 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 DOUBLE and they are incompatible.
-------------------------------------
-{call takesByteArray(?,?)}
- cs.registerOutParameter(1, BIT)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type CHAR () FOR BIT DATA because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, BOOLEAN)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type BOOLEAN because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, TINYINT)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type TINYINT because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, SMALLINT)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type SMALLINT because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, INTEGER)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type INTEGER because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, BIGINT)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type BIGINT because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, FLOAT)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type FLOAT because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, REAL)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type REAL because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, DOUBLE)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type DOUBLE because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, NUMERIC)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type NUMERIC because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, DECIMAL)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type DECIMAL because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, CHAR)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type CHAR because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, VARCHAR)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type VARCHAR because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, LONGVARCHAR)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type LONGVARCHAR because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, DATE)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type DATE because it maps to type VARCHAR () FOR BIT DATA 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 VARCHAR () FOR BIT DATA 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 VARCHAR () FOR BIT DATA and they are incompatible.
- cs.registerOutParameter(1, BINARY)
- setBytes(1, byte[])
- cs.execute()
- getBoolean(1) = SQL Exception: An attempt was made to get a data value of type 'boolean' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getBoolean(1) = SQL Exception: An attempt was made to get a data value of type 'boolean' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getByte(1) = SQL Exception: An attempt was made to get a data value of type 'byte' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getShort(1) = SQL Exception: An attempt was made to get a data value of type 'short' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getInt(1) = SQL Exception: An attempt was made to get a data value of type 'int' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getLong(1) = SQL Exception: An attempt was made to get a data value of type 'long' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getFloat(1) = SQL Exception: An attempt was made to get a data value of type 'float' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getFloat(1) = SQL Exception: An attempt was made to get a data value of type 'float' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getDouble(1) = SQL Exception: An attempt was made to get a data value of type 'double' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getBigDecimal(1) = java.sql.SQLException: Invalid data conversion. Method not called.
- getBigDecimal(1) = java.sql.SQLException: Invalid data conversion. Method not called.
- getString(1) = ff000000000000000000000000000000
- getString(1) = ff000000000000000000000000000000
- getString(1) = ff000000000000000000000000000000
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getBytes(1) = -1000000000000000
- getBytes(1) = -1000000000000000
- getBytes(1) = -1000000000000000
- getObject(1) = -1000000000000000
- cs.registerOutParameter(1, VARBINARY)
- setBytes(1, byte[])
- cs.execute()
- getBoolean(1) = SQL Exception: An attempt was made to get a data value of type 'boolean' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getBoolean(1) = SQL Exception: An attempt was made to get a data value of type 'boolean' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getByte(1) = SQL Exception: An attempt was made to get a data value of type 'byte' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getShort(1) = SQL Exception: An attempt was made to get a data value of type 'short' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getInt(1) = SQL Exception: An attempt was made to get a data value of type 'int' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getLong(1) = SQL Exception: An attempt was made to get a data value of type 'long' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getFloat(1) = SQL Exception: An attempt was made to get a data value of type 'float' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getFloat(1) = SQL Exception: An attempt was made to get a data value of type 'float' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getDouble(1) = SQL Exception: An attempt was made to get a data value of type 'double' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getBigDecimal(1) = java.sql.SQLException: Invalid data conversion. Method not called.
- getBigDecimal(1) = java.sql.SQLException: Invalid data conversion. Method not called.
- getString(1) = ff000000000000000000000000000000
- getString(1) = ff000000000000000000000000000000
- getString(1) = ff000000000000000000000000000000
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getBytes(1) = -1000000000000000
- getBytes(1) = -1000000000000000
- getBytes(1) = -1000000000000000
- getObject(1) = -1000000000000000
- cs.registerOutParameter(1, LONGVARBINARY)
- setBytes(1, byte[])
- cs.execute()
- getBoolean(1) = SQL Exception: An attempt was made to get a data value of type 'boolean' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getBoolean(1) = SQL Exception: An attempt was made to get a data value of type 'boolean' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getByte(1) = SQL Exception: An attempt was made to get a data value of type 'byte' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getShort(1) = SQL Exception: An attempt was made to get a data value of type 'short' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getInt(1) = SQL Exception: An attempt was made to get a data value of type 'int' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getLong(1) = SQL Exception: An attempt was made to get a data value of type 'long' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getFloat(1) = SQL Exception: An attempt was made to get a data value of type 'float' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getFloat(1) = SQL Exception: An attempt was made to get a data value of type 'float' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getDouble(1) = SQL Exception: An attempt was made to get a data value of type 'double' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getBigDecimal(1) = java.sql.SQLException: Invalid data conversion. Method not called.
- getBigDecimal(1) = java.sql.SQLException: Invalid data conversion. Method not called.
- getString(1) = ff000000000000000000000000000000
- getString(1) = ff000000000000000000000000000000
- getString(1) = ff000000000000000000000000000000
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'VARCHAR () FOR BIT DATA'.
- getBytes(1) = -1000000000000000
- getBytes(1) = -1000000000000000
- getBytes(1) = -1000000000000000
- getObject(1) = -1000000000000000
- cs.registerOutParameter(1, OTHER)
- Exception SQL Exception: Parameter 1 cannot be registered to be of type OTHER because it maps to type VARCHAR () FOR BIT DATA and they are incompatible.
-------------------------------------
-call takesString(?,?)
- cs.registerOutParameter(1, BIT)
- setBoolean(1, true)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = SQL Exception: Invalid character string format for type byte.
- getShort(1) = SQL Exception: Invalid character string format for type short.
- getInt(1) = SQL Exception: Invalid character string format for type int.
- getLong(1) = SQL Exception: Invalid character string format for type long.
- getFloat(1) = SQL Exception: Invalid character string format for type float.
- getFloat(1) = SQL Exception: Invalid character string format for type float.
- getDouble(1) = SQL Exception: Invalid character string format for type double.
- getBigDecimal(1) = java.sql.SQLException: Invalid character string format for type java.math.BigDecimal.
- getBigDecimal(1) = java.sql.SQLException: Invalid character string format for type java.math.BigDecimal.
- getString(1) = true
- getString(1) = true
- getString(1) = true
- getDate(1) = SQL Exception: The syntax of the string representation of a datetime value is incorrect.
- getTime(1) = SQL Exception: The syntax of the string representation of a datetime value is incorrect.
- getTimestamp(1) = SQL Exception: The syntax of the string representation of a datetime value is incorrect.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'VARCHAR'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'VARCHAR'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'VARCHAR'.
- getObject(1) = true
- cs.registerOutParameter(1, BOOLEAN)
- setBoolean(1, true)
- cs.execute()
- getBoolean(1) = true
- getBoolean(1) = true
- getByte(1) = SQL Exception: Invalid character string format for type byte.
- getShort(1) = SQL Exception: Invalid character string format for type short.
- getInt(1) = SQL Exception: Invalid character string format for type int.
- getLong(1) = SQL Exception: Invalid character string format for type long.
- getFloat(1) = SQL Exception: Invalid character string format for type float.
- getFloat(1) = SQL Exception: Invalid character string format for type float.
- getDouble(1) = SQL Exception: Invalid character string format for type double.
- getBigDecimal(1) = java.sql.SQLException: Invalid character string format for type java.math.BigDecimal.
- getBigDecimal(1) = java.sql.SQLException: Invalid character string format for type java.math.BigDecimal.
- getString(1) = true
- getString(1) = true
- getString(1) = true
- getDate(1) = SQL Exception: The syntax of the string representation of a datetime value is incorrect.
- getTime(1) = SQL Exception: The syntax of the string representation of a datetime value is incorrect.
- getTimestamp(1) = SQL Exception: The syntax of the string representation of a datetime value is incorrect.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'VARCHAR'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'VARCHAR'.
[... 14363 lines stripped ...]