Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 24893 invoked from network); 1 Sep 2006 14:38:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Sep 2006 14:38:52 -0000 Received: (qmail 49747 invoked by uid 500); 1 Sep 2006 14:38:52 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 49721 invoked by uid 500); 1 Sep 2006 14:38:52 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 49704 invoked by uid 99); 1 Sep 2006 14:38:52 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Sep 2006 07:38:52 -0700 X-ASF-Spam-Status: No, hits=-9.4 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [140.211.166.113] (HELO eris.apache.org) (140.211.166.113) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Sep 2006 07:38:47 -0700 Received: by eris.apache.org (Postfix, from userid 65534) id 6BE221A9823; Fri, 1 Sep 2006 07:38:27 -0700 (PDT) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r439335 [4/5] - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master: j9_13/outparams.out j9_13/parameterMapping.out j9_foundation/outparams.out j9_foundation/parameterMapping.out Date: Fri, 01 Sep 2006 14:38:25 -0000 To: derby-commits@db.apache.org From: fuzzylogic@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20060901143827.6BE221A9823@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/outparams.out URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/outparams.out?rev=439335&r1=439334&r2=439335&view=diff ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/outparams.out (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/outparams.out Fri Sep 1 07:38:24 2006 @@ -1,13 +1,13 @@ ============================================== TESTING BOUNDARY CONDITIONS ============================================== -Expected exception SQL Exception: Parameter 2 cannot be registered as an OUT parameter because it is an IN parameter. -Expected exception SQL Exception: The parameter position '9' is out of range. The number of parameters for this prepared statement is '2'. -Expected exception SQL Exception: The parameter position '0' is out of range. The number of parameters for this prepared statement is '2'. -Expected exception SQL Exception: Return output parameters cannot be set. -Expected exception SQL Exception: Return output parameters cannot be set. -Expected exception on setString() on a return output param: SQL Exception: Return output parameters cannot be set. -Expected exception on prepare of '? = call returnsNothing()': SQL Exception: 'RETURNSNOTHING' is not recognized as a function or procedure. +Expected exception java.sql.SQLException: Parameter 2 cannot be registered as an OUT parameter because it is an IN parameter. +Expected exception java.sql.SQLException: The parameter position '9' is out of range. The number of parameters for this prepared statement is '2'. +Expected exception java.sql.SQLException: The parameter position '0' is out of range. The number of parameters for this prepared statement is '2'. +Expected exception java.sql.SQLException: Return output parameters cannot be set. +Expected exception java.sql.SQLException: Return output parameters cannot be set. +Expected exception on setString() on a return output param: java.sql.SQLException: Return output parameters cannot be set. +Expected exception on prepare of '? = call returnsNothing()': java.sql.SQLException: 'RETURNSNOTHING' is not recognized as a function or procedure. ============================================== TESTING NULLS ============================================== @@ -24,47 +24,47 @@ ------------------------------------ {call takesNothing()} cs.registerOutParameter(1, BIT) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, BOOLEAN) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, TINYINT) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, SMALLINT) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, INTEGER) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, BIGINT) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, FLOAT) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, REAL) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, DOUBLE) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, NUMERIC) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, DECIMAL) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, CHAR) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, VARCHAR) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, LONGVARCHAR) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, DATE) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, TIME) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, TIMESTAMP) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, BINARY) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, VARBINARY) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, LONGVARBINARY) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. cs.registerOutParameter(1, OTHER) - Exception SQL Exception: No input parameters. + Exception java.sql.SQLException: No input parameters. ------------------------------------ call takesShortPrimitive(?,?) cs.registerOutParameter(1, BIT) @@ -84,12 +84,12 @@ getString(1) = 2 getString(1) = 2 getString(1) = 2 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. getObject(1) = 2 cs.registerOutParameter(1, BOOLEAN) setBoolean(1, true) @@ -108,12 +108,12 @@ getString(1) = 2 getString(1) = 2 getString(1) = 2 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. getObject(1) = 2 cs.registerOutParameter(1, TINYINT) setByte(1, 6) @@ -132,19 +132,19 @@ getString(1) = 12 getString(1) = 12 getString(1) = 12 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. getObject(1) = 12 cs.registerOutParameter(1, SMALLINT) setShort(1, 66) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 132 getInt(1) = 132 getLong(1) = 132 @@ -156,19 +156,19 @@ getString(1) = 132 getString(1) = 132 getString(1) = 132 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. getObject(1) = 132 cs.registerOutParameter(1, INTEGER) setInt(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -180,19 +180,19 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. getObject(1) = 1332 cs.registerOutParameter(1, BIGINT) setLong(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -204,19 +204,19 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. getObject(1) = 1332 cs.registerOutParameter(1, FLOAT) setFLoat(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -228,19 +228,19 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. getObject(1) = 1332 cs.registerOutParameter(1, REAL) setFLoat(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -252,19 +252,19 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. getObject(1) = 1332 cs.registerOutParameter(1, DOUBLE) setDouble(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -276,42 +276,42 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'SMALLINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'. getObject(1) = 1332 cs.registerOutParameter(1, NUMERIC) setBigDecimal(1, 666.666) - Exception SQL Exception: Invalid character string format for type SMALLINT. + Exception java.sql.SQLException: Invalid character string format for type SMALLINT. cs.registerOutParameter(1, DECIMAL) setBigDecimal(1, 666.666) - Exception SQL Exception: Invalid character string format for type SMALLINT. + Exception java.sql.SQLException: Invalid character string format for type SMALLINT. cs.registerOutParameter(1, CHAR) setString(1, "Set via setString()") - Exception SQL Exception: Invalid character string format for type SMALLINT. + Exception java.sql.SQLException: Invalid character string format for type SMALLINT. cs.registerOutParameter(1, VARCHAR) setString(1, "Set via setString()") - Exception SQL Exception: Invalid character string format for type SMALLINT. + Exception java.sql.SQLException: Invalid character string format for type SMALLINT. cs.registerOutParameter(1, LONGVARCHAR) setString(1, "Set via setString()") - Exception SQL Exception: Invalid character string format for type SMALLINT. + Exception java.sql.SQLException: Invalid character string format for type SMALLINT. cs.registerOutParameter(1, DATE) - Exception SQL Exception: Parameter 1 cannot be registered to be of type DATE because it maps to type SMALLINT and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type DATE because it maps to type SMALLINT and they are incompatible. cs.registerOutParameter(1, TIME) - Exception SQL Exception: Parameter 1 cannot be registered to be of type TIME because it maps to type SMALLINT and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIME because it maps to type SMALLINT and they are incompatible. cs.registerOutParameter(1, TIMESTAMP) - Exception SQL Exception: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type SMALLINT and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type SMALLINT and they are incompatible. cs.registerOutParameter(1, BINARY) - Exception SQL Exception: Parameter 1 cannot be registered to be of type BINARY because it maps to type SMALLINT and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type BINARY because it maps to type SMALLINT and they are incompatible. cs.registerOutParameter(1, VARBINARY) - Exception SQL Exception: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type SMALLINT and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type SMALLINT and they are incompatible. cs.registerOutParameter(1, LONGVARBINARY) - Exception SQL Exception: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type SMALLINT and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type SMALLINT and they are incompatible. cs.registerOutParameter(1, OTHER) - Exception SQL Exception: Parameter 1 cannot be registered to be of type OTHER because it maps to type SMALLINT and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type OTHER because it maps to type SMALLINT and they are incompatible. ------------------------------------ call takesIntegerPrimitive(?,?) cs.registerOutParameter(1, BIT) @@ -331,12 +331,12 @@ getString(1) = 2 getString(1) = 2 getString(1) = 2 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. getObject(1) = 2 cs.registerOutParameter(1, BOOLEAN) setBoolean(1, true) @@ -355,12 +355,12 @@ getString(1) = 2 getString(1) = 2 getString(1) = 2 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. getObject(1) = 2 cs.registerOutParameter(1, TINYINT) setByte(1, 6) @@ -379,19 +379,19 @@ getString(1) = 12 getString(1) = 12 getString(1) = 12 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. getObject(1) = 12 cs.registerOutParameter(1, SMALLINT) setShort(1, 66) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 132 getInt(1) = 132 getLong(1) = 132 @@ -403,19 +403,19 @@ getString(1) = 132 getString(1) = 132 getString(1) = 132 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. getObject(1) = 132 cs.registerOutParameter(1, INTEGER) setInt(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -427,19 +427,19 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. getObject(1) = 1332 cs.registerOutParameter(1, BIGINT) setLong(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -451,19 +451,19 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. getObject(1) = 1332 cs.registerOutParameter(1, FLOAT) setFLoat(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -475,19 +475,19 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. getObject(1) = 1332 cs.registerOutParameter(1, REAL) setFLoat(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -499,19 +499,19 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. getObject(1) = 1332 cs.registerOutParameter(1, DOUBLE) setDouble(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -523,42 +523,42 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'. getObject(1) = 1332 cs.registerOutParameter(1, NUMERIC) setBigDecimal(1, 666.666) - Exception SQL Exception: Invalid character string format for type INTEGER. + Exception java.sql.SQLException: Invalid character string format for type INTEGER. cs.registerOutParameter(1, DECIMAL) setBigDecimal(1, 666.666) - Exception SQL Exception: Invalid character string format for type INTEGER. + Exception java.sql.SQLException: Invalid character string format for type INTEGER. cs.registerOutParameter(1, CHAR) setString(1, "Set via setString()") - Exception SQL Exception: Invalid character string format for type INTEGER. + Exception java.sql.SQLException: Invalid character string format for type INTEGER. cs.registerOutParameter(1, VARCHAR) setString(1, "Set via setString()") - Exception SQL Exception: Invalid character string format for type INTEGER. + Exception java.sql.SQLException: Invalid character string format for type INTEGER. cs.registerOutParameter(1, LONGVARCHAR) setString(1, "Set via setString()") - Exception SQL Exception: Invalid character string format for type INTEGER. + Exception java.sql.SQLException: Invalid character string format for type INTEGER. cs.registerOutParameter(1, DATE) - Exception SQL Exception: Parameter 1 cannot be registered to be of type DATE because it maps to type INTEGER and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type DATE because it maps to type INTEGER and they are incompatible. cs.registerOutParameter(1, TIME) - Exception SQL Exception: Parameter 1 cannot be registered to be of type TIME because it maps to type INTEGER and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIME because it maps to type INTEGER and they are incompatible. cs.registerOutParameter(1, TIMESTAMP) - Exception SQL Exception: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type INTEGER and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type INTEGER and they are incompatible. cs.registerOutParameter(1, BINARY) - Exception SQL Exception: Parameter 1 cannot be registered to be of type BINARY because it maps to type INTEGER and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type BINARY because it maps to type INTEGER and they are incompatible. cs.registerOutParameter(1, VARBINARY) - Exception SQL Exception: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type INTEGER and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type INTEGER and they are incompatible. cs.registerOutParameter(1, LONGVARBINARY) - Exception SQL Exception: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type INTEGER and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type INTEGER and they are incompatible. cs.registerOutParameter(1, OTHER) - Exception SQL Exception: Parameter 1 cannot be registered to be of type OTHER because it maps to type INTEGER and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type OTHER because it maps to type INTEGER and they are incompatible. ------------------------------------ call takesLongPrimitive(?,?) cs.registerOutParameter(1, BIT) @@ -578,12 +578,12 @@ getString(1) = 2 getString(1) = 2 getString(1) = 2 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. getObject(1) = 2 cs.registerOutParameter(1, BOOLEAN) setBoolean(1, true) @@ -602,12 +602,12 @@ getString(1) = 2 getString(1) = 2 getString(1) = 2 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. getObject(1) = 2 cs.registerOutParameter(1, TINYINT) setByte(1, 6) @@ -626,19 +626,19 @@ getString(1) = 12 getString(1) = 12 getString(1) = 12 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. getObject(1) = 12 cs.registerOutParameter(1, SMALLINT) setShort(1, 66) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 132 getInt(1) = 132 getLong(1) = 132 @@ -650,19 +650,19 @@ getString(1) = 132 getString(1) = 132 getString(1) = 132 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. getObject(1) = 132 cs.registerOutParameter(1, INTEGER) setInt(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -674,19 +674,19 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. getObject(1) = 1332 cs.registerOutParameter(1, BIGINT) setLong(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -698,19 +698,19 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. getObject(1) = 1332 cs.registerOutParameter(1, FLOAT) setFLoat(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -722,19 +722,19 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. getObject(1) = 1332 cs.registerOutParameter(1, REAL) setFLoat(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -746,19 +746,19 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. getObject(1) = 1332 cs.registerOutParameter(1, DOUBLE) setDouble(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -770,42 +770,42 @@ getString(1) = 1332 getString(1) = 1332 getString(1) = 1332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'. getObject(1) = 1332 cs.registerOutParameter(1, NUMERIC) setBigDecimal(1, 666.666) - Exception SQL Exception: Invalid character string format for type BIGINT. + Exception java.sql.SQLException: Invalid character string format for type BIGINT. cs.registerOutParameter(1, DECIMAL) setBigDecimal(1, 666.666) - Exception SQL Exception: Invalid character string format for type BIGINT. + Exception java.sql.SQLException: Invalid character string format for type BIGINT. cs.registerOutParameter(1, CHAR) setString(1, "Set via setString()") - Exception SQL Exception: Invalid character string format for type BIGINT. + Exception java.sql.SQLException: Invalid character string format for type BIGINT. cs.registerOutParameter(1, VARCHAR) setString(1, "Set via setString()") - Exception SQL Exception: Invalid character string format for type BIGINT. + Exception java.sql.SQLException: Invalid character string format for type BIGINT. cs.registerOutParameter(1, LONGVARCHAR) setString(1, "Set via setString()") - Exception SQL Exception: Invalid character string format for type BIGINT. + Exception java.sql.SQLException: Invalid character string format for type BIGINT. cs.registerOutParameter(1, DATE) - Exception SQL Exception: Parameter 1 cannot be registered to be of type DATE because it maps to type BIGINT and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type DATE because it maps to type BIGINT and they are incompatible. cs.registerOutParameter(1, TIME) - Exception SQL Exception: Parameter 1 cannot be registered to be of type TIME because it maps to type BIGINT and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIME because it maps to type BIGINT and they are incompatible. cs.registerOutParameter(1, TIMESTAMP) - Exception SQL Exception: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type BIGINT and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type BIGINT and they are incompatible. cs.registerOutParameter(1, BINARY) - Exception SQL Exception: Parameter 1 cannot be registered to be of type BINARY because it maps to type BIGINT and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type BINARY because it maps to type BIGINT and they are incompatible. cs.registerOutParameter(1, VARBINARY) - Exception SQL Exception: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type BIGINT and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type BIGINT and they are incompatible. cs.registerOutParameter(1, LONGVARBINARY) - Exception SQL Exception: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type BIGINT and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type BIGINT and they are incompatible. cs.registerOutParameter(1, OTHER) - Exception SQL Exception: Parameter 1 cannot be registered to be of type OTHER because it maps to type BIGINT and they are incompatible. + Exception java.sql.SQLException: Parameter 1 cannot be registered to be of type OTHER because it maps to type BIGINT and they are incompatible. ------------------------------------ call takesFloatPrimitive(?,?) cs.registerOutParameter(1, BIT) @@ -825,12 +825,12 @@ getString(1) = 2.0 getString(1) = 2.0 getString(1) = 2.0 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. getObject(1) = 2.0 cs.registerOutParameter(1, BOOLEAN) setBoolean(1, true) @@ -849,12 +849,12 @@ getString(1) = 2.0 getString(1) = 2.0 getString(1) = 2.0 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. getObject(1) = 2.0 cs.registerOutParameter(1, TINYINT) setByte(1, 6) @@ -873,19 +873,19 @@ getString(1) = 12.0 getString(1) = 12.0 getString(1) = 12.0 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. getObject(1) = 12.0 cs.registerOutParameter(1, SMALLINT) setShort(1, 66) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 132 getInt(1) = 132 getLong(1) = 132 @@ -897,19 +897,19 @@ getString(1) = 132.0 getString(1) = 132.0 getString(1) = 132.0 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. getObject(1) = 132.0 cs.registerOutParameter(1, INTEGER) setInt(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -921,19 +921,19 @@ getString(1) = 1332.0 getString(1) = 1332.0 getString(1) = 1332.0 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. getObject(1) = 1332.0 cs.registerOutParameter(1, BIGINT) setLong(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -945,19 +945,19 @@ getString(1) = 1332.0 getString(1) = 1332.0 getString(1) = 1332.0 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. getObject(1) = 1332.0 cs.registerOutParameter(1, FLOAT) setFLoat(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -969,19 +969,19 @@ getString(1) = 1332.0 getString(1) = 1332.0 getString(1) = 1332.0 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. getObject(1) = 1332.0 cs.registerOutParameter(1, REAL) setFLoat(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -993,19 +993,19 @@ getString(1) = 1332.0 getString(1) = 1332.0 getString(1) = 1332.0 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. getObject(1) = 1332.0 cs.registerOutParameter(1, DOUBLE) setDouble(1, 666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1332 getInt(1) = 1332 getLong(1) = 1332 @@ -1017,19 +1017,19 @@ getString(1) = 1332.0 getString(1) = 1332.0 getString(1) = 1332.0 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getDate(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. + getTime(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. + getTimestamp(1) = java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. + getBytes(1) = java.sql.SQLException: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. getObject(1) = 1332.0 cs.registerOutParameter(1, NUMERIC) setBigDecimal(1, 666.666) cs.execute() getBoolean(1) = true getBoolean(1) = true - getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT. + getByte(1) = java.sql.SQLException: The resulting value is outside the range for the data type TINYINT. getShort(1) = 1333 getInt(1) = 1333 getLong(1) = 1333 @@ -1041,19 +1041,19 @@ getString(1) = 1333.332 getString(1) = 1333.332 getString(1) = 1333.332 - getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'. - getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'. - getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. - getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'. [... 8435 lines stripped ...]