You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by da...@apache.org on 2006/03/15 22:31:59 UTC
svn commit: r386169 [34/36] - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master:
DerbyNet/jdk16/ DerbyNetClient/jdk16/ jdk16/
Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/outparams.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/outparams.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/outparams.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/outparams.out Wed Mar 15 13:31:53 2006
@@ -0,0 +1,8995 @@
+==============================================
+TESTING BOUNDARY CONDITIONS
+==============================================
+Expected exception java.sql.SQLException: Parameter 2 cannot be registered as an OUT parameter because it is an IN parameter.
+Expected exception java.sql.SQLException: The parameter position '9' is out of range. The number of parameters for this prepared statement is '2'.
+Expected exception java.sql.SQLException: The parameter position '0' is out of range. The number of parameters for this prepared statement is '2'.
+Expected exception java.sql.SQLException: Return output parameters cannot be set.
+Expected exception java.sql.SQLException: Return output parameters cannot be set.
+Expected exception on setString() on a return output param: java.sql.SQLException: Return output parameters cannot be set.
+Expected exception on prepare of '? = call returnsNothing()': java.sql.SQLSyntaxErrorException: '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 java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, BOOLEAN)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, TINYINT)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, SMALLINT)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, INTEGER)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, BIGINT)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, FLOAT)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, REAL)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, DOUBLE)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, NUMERIC)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, DECIMAL)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, CHAR)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, VARCHAR)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, LONGVARCHAR)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, DATE)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, TIME)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, TIMESTAMP)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, BINARY)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, VARBINARY)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, LONGVARBINARY)
+ Exception java.sql.SQLException: No input parameters.
+ cs.registerOutParameter(1, OTHER)
+ Exception java.sql.SQLException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
+ getBytes(1) = java.sql.SQLDataException: 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 java.sql.SQLDataException: Invalid character string format for type SMALLINT.
+ cs.registerOutParameter(1, VARCHAR)
+ setString(1, "Set via setString()")
+ Exception java.sql.SQLDataException: Invalid character string format for type SMALLINT.
+ cs.registerOutParameter(1, LONGVARCHAR)
+ setString(1, "Set via setString()")
+ Exception java.sql.SQLDataException: Invalid character string format for type SMALLINT.
+ cs.registerOutParameter(1, DATE)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type DATE because it maps to type SMALLINT and they are incompatible.
+ cs.registerOutParameter(1, TIME)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIME because it maps to type SMALLINT and they are incompatible.
+ cs.registerOutParameter(1, TIMESTAMP)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type SMALLINT and they are incompatible.
+ cs.registerOutParameter(1, BINARY)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type BINARY because it maps to type SMALLINT and they are incompatible.
+ cs.registerOutParameter(1, VARBINARY)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type SMALLINT and they are incompatible.
+ cs.registerOutParameter(1, LONGVARBINARY)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type SMALLINT and they are incompatible.
+ cs.registerOutParameter(1, OTHER)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type OTHER because it maps to type SMALLINT and they are incompatible.
+------------------------------------
+call takesIntegerPrimitive(?,?)
+ cs.registerOutParameter(1, BIT)
+ 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
+ getBytes(1) = java.sql.SQLDataException: 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 java.sql.SQLDataException: Invalid character string format for type INTEGER.
+ cs.registerOutParameter(1, VARCHAR)
+ setString(1, "Set via setString()")
+ Exception java.sql.SQLDataException: Invalid character string format for type INTEGER.
+ cs.registerOutParameter(1, LONGVARCHAR)
+ setString(1, "Set via setString()")
+ Exception java.sql.SQLDataException: Invalid character string format for type INTEGER.
+ cs.registerOutParameter(1, DATE)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type DATE because it maps to type INTEGER and they are incompatible.
+ cs.registerOutParameter(1, TIME)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIME because it maps to type INTEGER and they are incompatible.
+ cs.registerOutParameter(1, TIMESTAMP)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type INTEGER and they are incompatible.
+ cs.registerOutParameter(1, BINARY)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type BINARY because it maps to type INTEGER and they are incompatible.
+ cs.registerOutParameter(1, VARBINARY)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type INTEGER and they are incompatible.
+ cs.registerOutParameter(1, LONGVARBINARY)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type INTEGER and they are incompatible.
+ cs.registerOutParameter(1, OTHER)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type OTHER because it maps to type INTEGER and they are incompatible.
+------------------------------------
+call takesLongPrimitive(?,?)
+ cs.registerOutParameter(1, BIT)
+ 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
+ getBytes(1) = java.sql.SQLDataException: 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 java.sql.SQLDataException: Invalid character string format for type BIGINT.
+ cs.registerOutParameter(1, VARCHAR)
+ setString(1, "Set via setString()")
+ Exception java.sql.SQLDataException: Invalid character string format for type BIGINT.
+ cs.registerOutParameter(1, LONGVARCHAR)
+ setString(1, "Set via setString()")
+ Exception java.sql.SQLDataException: Invalid character string format for type BIGINT.
+ cs.registerOutParameter(1, DATE)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type DATE because it maps to type BIGINT and they are incompatible.
+ cs.registerOutParameter(1, TIME)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIME because it maps to type BIGINT and they are incompatible.
+ cs.registerOutParameter(1, TIMESTAMP)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type BIGINT and they are incompatible.
+ cs.registerOutParameter(1, BINARY)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type BINARY because it maps to type BIGINT and they are incompatible.
+ cs.registerOutParameter(1, VARBINARY)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type BIGINT and they are incompatible.
+ cs.registerOutParameter(1, LONGVARBINARY)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type BIGINT and they are incompatible.
+ cs.registerOutParameter(1, OTHER)
+ Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type OTHER because it maps to type BIGINT and they are incompatible.
+------------------------------------
+call takesFloatPrimitive(?,?)
+ cs.registerOutParameter(1, BIT)
+ 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = java.sql.SQLDataException: 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 java.sql.SQLDataException: Invalid character string format for type REAL.
+ cs.registerOutParameter(1, VARCHAR)
+ setString(1, "Set via setString()")
+ Exception java.sql.SQLDataException: Invalid character string format for type REAL.
+ cs.registerOutParameter(1, LONGVARCHAR)
+ setString(1, "Set via setString()")
+ Exception java.sql.SQLDataException: Invalid character string format for type REAL.
+ cs.registerOutParameter(1, DATE)
+ Exception java.sql.SQLException: 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 java.sql.SQLException: 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 java.sql.SQLException: 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 java.sql.SQLException: 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 java.sql.SQLException: 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 java.sql.SQLException: 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 java.sql.SQLException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = java.sql.SQLDataException: 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 java.sql.SQLDataException: Invalid character string format for type DOUBLE.
+ cs.registerOutParameter(1, VARCHAR)
+ setString(1, "Set via setString()")
+ Exception java.sql.SQLDataException: Invalid character string format for type DOUBLE.
+ cs.registerOutParameter(1, LONGVARCHAR)
+ setString(1, "Set via setString()")
+ Exception java.sql.SQLDataException: Invalid character string format for type DOUBLE.
+ cs.registerOutParameter(1, DATE)
+ Exception java.sql.SQLException: 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 java.sql.SQLException: 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 java.sql.SQLException: 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 java.sql.SQLException: 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 java.sql.SQLException: 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 java.sql.SQLException: 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 java.sql.SQLException: 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) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DECIMAL'.
+ getTime(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DECIMAL'.
+ getTimestamp(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DECIMAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
+ getBytes(1) = java.sql.SQLDataException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DECIMAL'.
+ getBytes(1) = java.sql.SQLDataException: 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
[... 7441 lines stripped ...]