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/06/13 23:37:35 UTC
svn commit: r190512 [2/4] - in
/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests:
master/j9_13/distinct.out master/j9_13/ejbql.out
master/j9_13/floattypes.out master/j9_13/groupBy.out
master/j9_13/outparams.out master/j9_22/distinct.out
master/j9_22/groupBy.out tests/lang/copyfiles.ant
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?rev=190512&r1=190511&r2=190512&view=diff
==============================================================================
--- 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 Mon Jun 13 14:37:34 2005
@@ -0,0 +1,8995 @@
+==============================================
+TESTING BOUNDARY CONDITIONS
+==============================================
+Expected exception SQL Exception: Parameter 2 cannot be registered as an OUT parameter because it is an IN parameter.
+Expected exception SQL Exception: The parameter position '9' is out of range. The number of parameters for this prepared statement is '2'.
+Expected exception SQL Exception: The parameter position '0' is out of range. The number of parameters for this prepared statement is '2'.
+Expected exception SQL Exception: Return output parameters cannot be set.
+Expected exception SQL Exception: Return output parameters cannot be set.
+Expected exception on 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.0
+ getBigDecimal(1) = 2.0
+ getString(1) = 2.0
+ getString(1) = 2.0
+ getString(1) = 2.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getObject(1) = 2.0
+ cs.registerOutParameter(1, BOOLEAN)
+ setBoolean(1, true)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = 2
+ getShort(1) = 2
+ getInt(1) = 2
+ getLong(1) = 2
+ getFloat(1) = 2.0
+ getFloat(1) = 2.0
+ getDouble(1) = 2.0
+ getBigDecimal(1) = 2.0
+ getBigDecimal(1) = 2.0
+ getString(1) = 2.0
+ getString(1) = 2.0
+ getString(1) = 2.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getObject(1) = 2.0
+ cs.registerOutParameter(1, TINYINT)
+ setByte(1, 6)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = 12
+ getShort(1) = 12
+ getInt(1) = 12
+ getLong(1) = 12
+ getFloat(1) = 12.0
+ getFloat(1) = 12.0
+ getDouble(1) = 12.0
+ getBigDecimal(1) = 12.0
+ getBigDecimal(1) = 12.0
+ getString(1) = 12.0
+ getString(1) = 12.0
+ getString(1) = 12.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getObject(1) = 12.0
+ cs.registerOutParameter(1, SMALLINT)
+ setShort(1, 66)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 132
+ getInt(1) = 132
+ getLong(1) = 132
+ getFloat(1) = 132.0
+ getFloat(1) = 132.0
+ getDouble(1) = 132.0
+ getBigDecimal(1) = 132.0
+ getBigDecimal(1) = 132.0
+ getString(1) = 132.0
+ getString(1) = 132.0
+ getString(1) = 132.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getObject(1) = 132.0
+ cs.registerOutParameter(1, INTEGER)
+ setInt(1, 666)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 1332
+ getInt(1) = 1332
+ getLong(1) = 1332
+ getFloat(1) = 1332.0
+ getFloat(1) = 1332.0
+ getDouble(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getObject(1) = 1332.0
+ cs.registerOutParameter(1, BIGINT)
+ setLong(1, 666)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 1332
+ getInt(1) = 1332
+ getLong(1) = 1332
+ getFloat(1) = 1332.0
+ getFloat(1) = 1332.0
+ getDouble(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getObject(1) = 1332.0
+ cs.registerOutParameter(1, FLOAT)
+ setFLoat(1, 666)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 1332
+ getInt(1) = 1332
+ getLong(1) = 1332
+ getFloat(1) = 1332.0
+ getFloat(1) = 1332.0
+ getDouble(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getObject(1) = 1332.0
+ cs.registerOutParameter(1, REAL)
+ setFLoat(1, 666)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 1332
+ getInt(1) = 1332
+ getLong(1) = 1332
+ getFloat(1) = 1332.0
+ getFloat(1) = 1332.0
+ getDouble(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getObject(1) = 1332.0
+ cs.registerOutParameter(1, DOUBLE)
+ setDouble(1, 666)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 1332
+ getInt(1) = 1332
+ getLong(1) = 1332
+ getFloat(1) = 1332.0
+ getFloat(1) = 1332.0
+ getDouble(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getObject(1) = 1332.0
+ cs.registerOutParameter(1, NUMERIC)
+ setBigDecimal(1, 666.666)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 1333
+ getInt(1) = 1333
+ getLong(1) = 1333
+ getFloat(1) = 1333.332
+ getFloat(1) = 1333.332
+ getDouble(1) = 1333.33203125
+ getBigDecimal(1) = 1333.332
+ getBigDecimal(1) = 1333.332
+ getString(1) = 1333.332
+ getString(1) = 1333.332
+ getString(1) = 1333.332
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getObject(1) = 1333.332
+ cs.registerOutParameter(1, DECIMAL)
+ setBigDecimal(1, 666.666)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 1333
+ getInt(1) = 1333
+ getLong(1) = 1333
+ getFloat(1) = 1333.332
+ getFloat(1) = 1333.332
+ getDouble(1) = 1333.33203125
+ getBigDecimal(1) = 1333.332
+ getBigDecimal(1) = 1333.332
+ getString(1) = 1333.332
+ getString(1) = 1333.332
+ getString(1) = 1333.332
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
+ getObject(1) = 1333.332
+ cs.registerOutParameter(1, CHAR)
+ setString(1, "Set via setString()")
+ Exception SQL Exception: Invalid character string format for type REAL.
+ cs.registerOutParameter(1, VARCHAR)
+ setString(1, "Set via setString()")
+ Exception SQL Exception: Invalid character string format for type REAL.
+ cs.registerOutParameter(1, LONGVARCHAR)
+ setString(1, "Set via setString()")
+ Exception SQL Exception: Invalid character string format for type REAL.
+ cs.registerOutParameter(1, DATE)
+ Exception SQL Exception: Parameter 1 cannot be registered to be of type DATE because it maps to type REAL and they are incompatible.
+ cs.registerOutParameter(1, TIME)
+ Exception SQL Exception: Parameter 1 cannot be registered to be of type TIME because it maps to type REAL and they are incompatible.
+ cs.registerOutParameter(1, TIMESTAMP)
+ Exception SQL Exception: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type REAL and they are incompatible.
+ cs.registerOutParameter(1, BINARY)
+ Exception SQL Exception: Parameter 1 cannot be registered to be of type BINARY because it maps to type REAL and they are incompatible.
+ cs.registerOutParameter(1, VARBINARY)
+ Exception SQL Exception: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type REAL and they are incompatible.
+ cs.registerOutParameter(1, LONGVARBINARY)
+ Exception SQL Exception: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type REAL and they are incompatible.
+ cs.registerOutParameter(1, OTHER)
+ Exception SQL Exception: Parameter 1 cannot be registered to be of type OTHER because it maps to type REAL and they are incompatible.
+------------------------------------
+call takesDoublePrimitive(?,?)
+ cs.registerOutParameter(1, BIT)
+ setBoolean(1, true)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = 2
+ getShort(1) = 2
+ getInt(1) = 2
+ getLong(1) = 2
+ getFloat(1) = 2.0
+ getFloat(1) = 2.0
+ getDouble(1) = 2.0
+ getBigDecimal(1) = 2.0
+ getBigDecimal(1) = 2.0
+ getString(1) = 2.0
+ getString(1) = 2.0
+ getString(1) = 2.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getObject(1) = 2.0
+ cs.registerOutParameter(1, BOOLEAN)
+ setBoolean(1, true)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = 2
+ getShort(1) = 2
+ getInt(1) = 2
+ getLong(1) = 2
+ getFloat(1) = 2.0
+ getFloat(1) = 2.0
+ getDouble(1) = 2.0
+ getBigDecimal(1) = 2.0
+ getBigDecimal(1) = 2.0
+ getString(1) = 2.0
+ getString(1) = 2.0
+ getString(1) = 2.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getObject(1) = 2.0
+ cs.registerOutParameter(1, TINYINT)
+ setByte(1, 6)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = 12
+ getShort(1) = 12
+ getInt(1) = 12
+ getLong(1) = 12
+ getFloat(1) = 12.0
+ getFloat(1) = 12.0
+ getDouble(1) = 12.0
+ getBigDecimal(1) = 12.0
+ getBigDecimal(1) = 12.0
+ getString(1) = 12.0
+ getString(1) = 12.0
+ getString(1) = 12.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getObject(1) = 12.0
+ cs.registerOutParameter(1, SMALLINT)
+ setShort(1, 66)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 132
+ getInt(1) = 132
+ getLong(1) = 132
+ getFloat(1) = 132.0
+ getFloat(1) = 132.0
+ getDouble(1) = 132.0
+ getBigDecimal(1) = 132.0
+ getBigDecimal(1) = 132.0
+ getString(1) = 132.0
+ getString(1) = 132.0
+ getString(1) = 132.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getObject(1) = 132.0
+ cs.registerOutParameter(1, INTEGER)
+ setInt(1, 666)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 1332
+ getInt(1) = 1332
+ getLong(1) = 1332
+ getFloat(1) = 1332.0
+ getFloat(1) = 1332.0
+ getDouble(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getObject(1) = 1332.0
+ cs.registerOutParameter(1, BIGINT)
+ setLong(1, 666)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 1332
+ getInt(1) = 1332
+ getLong(1) = 1332
+ getFloat(1) = 1332.0
+ getFloat(1) = 1332.0
+ getDouble(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getObject(1) = 1332.0
+ cs.registerOutParameter(1, FLOAT)
+ setFLoat(1, 666)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 1332
+ getInt(1) = 1332
+ getLong(1) = 1332
+ getFloat(1) = 1332.0
+ getFloat(1) = 1332.0
+ getDouble(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getObject(1) = 1332.0
+ cs.registerOutParameter(1, REAL)
+ setFLoat(1, 666)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 1332
+ getInt(1) = 1332
+ getLong(1) = 1332
+ getFloat(1) = 1332.0
+ getFloat(1) = 1332.0
+ getDouble(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getObject(1) = 1332.0
+ cs.registerOutParameter(1, DOUBLE)
+ setDouble(1, 666)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 1332
+ getInt(1) = 1332
+ getLong(1) = 1332
+ getFloat(1) = 1332.0
+ getFloat(1) = 1332.0
+ getDouble(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getString(1) = 1332.0
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getObject(1) = 1332.0
+ cs.registerOutParameter(1, NUMERIC)
+ setBigDecimal(1, 666.666)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 1333
+ getInt(1) = 1333
+ getLong(1) = 1333
+ getFloat(1) = 1333.332
+ getFloat(1) = 1333.332
+ getDouble(1) = 1333.332
+ getBigDecimal(1) = 1333.332
+ getBigDecimal(1) = 1333.332
+ getString(1) = 1333.332
+ getString(1) = 1333.332
+ getString(1) = 1333.332
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getObject(1) = 1333.332
+ cs.registerOutParameter(1, DECIMAL)
+ setBigDecimal(1, 666.666)
+ cs.execute()
+ getBoolean(1) = true
+ getBoolean(1) = true
+ getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
+ getShort(1) = 1333
+ getInt(1) = 1333
+ getLong(1) = 1333
+ getFloat(1) = 1333.332
+ getFloat(1) = 1333.332
+ getDouble(1) = 1333.332
+ getBigDecimal(1) = 1333.332
+ getBigDecimal(1) = 1333.332
+ getString(1) = 1333.332
+ getString(1) = 1333.332
+ getString(1) = 1333.332
+ getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'DOUBLE'.
+ getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'DOUBLE'.
+ getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'DOUBLE'.
+ getObject(1) = 1333.332
+ cs.registerOutParameter(1, CHAR)
+ setString(1, "Set via setString()")
+ Exception SQL Exception: Invalid character string format for type DOUBLE.
+ cs.registerOutParameter(1, VARCHAR)
+ setString(1, "Set via setString()")
+ Exception SQL Exception: Invalid character string format for type DOUBLE.
+ cs.registerOutParameter(1, LONGVARCHAR)
+ setString(1, "Set via setString()")
+ Exception SQL Exception: Invalid character string format for type DOUBLE.
+ cs.registerOutParameter(1, DATE)
+ Exception SQL Exception: Parameter 1 cannot be registered to be of type DATE because it maps to type DOUBLE and they are incompatible.
+ cs.registerOutParameter(1, TIME)
+ Exception SQL Exception: Parameter 1 cannot be registered to be of type TIME because it maps to type DOUBLE and they are incompatible.
+ cs.registerOutParameter(1, TIMESTAMP)
+ Exception SQL Exception: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type DOUBLE and they are incompatible.
+ cs.registerOutParameter(1, BINARY)
+ Exception SQL Exception: Parameter 1 cannot be registered to be of type BINARY because it maps to type DOUBLE and they are incompatible.
+ cs.registerOutParameter(1, VARBINARY)
+ Exception SQL Exception: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type DOUBLE and they are incompatible.
+ cs.registerOutParameter(1, LONGVARBINARY)
+ Exception SQL Exception: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type DOUBLE and they are incompatible.
+ cs.registerOutParameter(1, OTHER)
+ Exception SQL Exception: Parameter 1 cannot be registered to be of type OTHER because it maps to type DOUBLE and they are incompatible.
+------------------------------------
+call 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 ...]