You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by fu...@apache.org on 2005/03/17 00:31:47 UTC
svn commit: r157825 [2/4] - in
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests:
harness/RunTest.java master/j9_13/outparams.out
master/j9_13/parameterMapping.out master/st_b5772.out
tests/derbynet/testProtocol_app.properties tests/storetests/build.xml
tests/storetests/st_b5772.sql
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/outparams.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/outparams.out?view=diff&r1=157824&r2=157825
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/outparams.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/outparams.out Wed Mar 16 15:31:45 2005
@@ -1,8995 +0,0 @@
-==============================================
-TESTING BOUNDARY CONDITIONS
-==============================================
-Expected exception SQL Exception: Parameter 2 cannot be 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 setBigDecimal() 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)
- 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, 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) = 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, 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)
- 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, 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) = 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, 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)
- 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, 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) = 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, 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
- getBigDecimal(1) = 2
- 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
- getBigDecimal(1) = 2
- 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
- getBigDecimal(1) = 12
- 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
- getBigDecimal(1) = 132
- 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
- getBigDecimal(1) = 1332
- 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
- getBigDecimal(1) = 1332
- 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
- getBigDecimal(1) = 1332
- 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
- getBigDecimal(1) = 1332
- 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
- getBigDecimal(1) = 1332
- 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.33203125
- getBigDecimal(1) = 1333.33203125
- 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.33203125
- getBigDecimal(1) = 1333.33203125
- 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
- getBigDecimal(1) = 2
- 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
- getBigDecimal(1) = 2
- 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
- getBigDecimal(1) = 12
- 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
- getBigDecimal(1) = 132
- 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
- getBigDecimal(1) = 1332
- 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
- getBigDecimal(1) = 1332
- 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
- getBigDecimal(1) = 1332
- 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
- getBigDecimal(1) = 1332
- 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
- getBigDecimal(1) = 1332
- 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 takesBigDecimal(?,?)
- 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.0000
- getBigDecimal(1) = 2.0000
- getString(1) = 2.0000
- getString(1) = 2.0000
- getString(1) = 2.0000
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DECIMAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DECIMAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getObject(1) = 2.0000
- 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.0000
- getBigDecimal(1) = 2.0000
- getString(1) = 2.0000
- getString(1) = 2.0000
- getString(1) = 2.0000
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DECIMAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DECIMAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getObject(1) = 2.0000
- 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.0000
- getBigDecimal(1) = 12.0000
- getString(1) = 12.0000
- getString(1) = 12.0000
- getString(1) = 12.0000
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DECIMAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DECIMAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getObject(1) = 12.0000
- 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.0000
- getBigDecimal(1) = 132.0000
- getString(1) = 132.0000
- getString(1) = 132.0000
- getString(1) = 132.0000
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DECIMAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DECIMAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getObject(1) = 132.0000
- 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.0000
- getBigDecimal(1) = 1332.0000
- getString(1) = 1332.0000
- getString(1) = 1332.0000
- getString(1) = 1332.0000
- getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DECIMAL'.
- getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DECIMAL'.
- getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
- getObject(1) = 1332.0000
- 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.0000
- getBigDecimal(1) = 1332.0000
- getString(1) = 1332.0000
- getString(1) = 1332.0000
- getString(1) = 1332.0000
[... 7345 lines stripped ...]