You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by km...@apache.org on 2006/01/27 04:06:18 UTC
svn commit: r372708 [2/5] - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests:
master/j9_foundation/ tests/jdbcapi/ tests/lang/ util/
Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/parameterMapping.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/parameterMapping.out?rev=372708&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/parameterMapping.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/parameterMapping.out Thu Jan 26 19:06:10 2006
@@ -0,0 +1,3393 @@
+Test parameterMapping starting
+STILL TO RESOLVE -- Cloudscape getBoolean() allow conversion on strings to match JCC
+STILL TO RESOLVE -- Cloudscape getXXX() disable on LOBs.
+getXXX on : -6
+ skipping
+getXXX on : SMALLINT
+ NULL VALUE
+ getByte=0 was null true JDBC MATCH(OK)
+ getShort=0 was null true JDBC MATCH(OK)
+ getInt=0 was null true JDBC MATCH(OK)
+ getLong=0 was null true JDBC MATCH(OK)
+ getFloat=0.0 was null true JDBC MATCH(OK)
+ getDouble=0.0 was null true JDBC MATCH(OK)
+ getBoolean=false was null true JDBC MATCH(OK)
+ getString=null was null true JDBC MATCH(OK)
+ getBytes=null was null true CLOUD EXT (OK)
+ getDate=null was null true CLOUD EXT (OK)
+ getTime=null was null true CLOUD EXT (OK)
+ getTimestamp=null was null true CLOUD EXT (OK)
+ getAsciiStream=SPECIFIC CHECK OK
+ getBinaryStream=SPECIFIC CHECK OK
+ getCharacterStream=SPECIFIC CHECK OK
+ getClob=SPECIFIC CHECK OK
+ getBlob=SPECIFIC CHECK OK
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=null was null true
+ VALID VALUE
+ getByte=32 was null false JDBC MATCH(OK)
+ getShort=32 was null false JDBC MATCH(OK)
+ getInt=32 was null false JDBC MATCH(OK)
+ getLong=32 was null false JDBC MATCH(OK)
+ getFloat=32.0 was null false JDBC MATCH(OK)
+ getDouble=32.0 was null false JDBC MATCH(OK)
+ getBoolean=true was null false JDBC MATCH(OK)
+ getString=32 was null false JDBC MATCH(OK)
+ getBytes=IC JDBC MATCH (INVALID)
+ getDate=IC JDBC MATCH (INVALID)
+ getTime=IC JDBC MATCH (INVALID)
+ getTimestamp=IC JDBC MATCH (INVALID)
+ getAsciiStream=IC JDBC MATCH (INVALID)
+ getBinaryStream=IC JDBC MATCH (INVALID)
+ getCharacterStream=IC JDBC MATCH (INVALID)
+ getClob=IC JDBC MATCH (INVALID)
+ getBlob=IC JDBC MATCH (INVALID)
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=CORRECT :java.lang.Integer was null false
+setNull() with all JDBC Types on SMALLINT
+ setNull(Types.TINYINT) getShort=0 was null true
+ setNull with batching support(Types.TINYINT) getShort=0 was null true
+ setNull(SMALLINT) getShort=0 was null true
+ setNull with batching support(SMALLINT) getShort=0 was null true
+ setNull(INTEGER) getShort=0 was null true
+ setNull with batching support(INTEGER) getShort=0 was null true
+ setNull(BIGINT) getShort=0 was null true
+ setNull with batching support(BIGINT) getShort=0 was null true
+ setNull(REAL) getShort=0 was null true
+ setNull with batching support(REAL) getShort=0 was null true
+ setNull(Types.FLOAT) getShort=0 was null true
+ setNull with batching support(Types.FLOAT) getShort=0 was null true
+ setNull(DOUBLE) getShort=0 was null true
+ setNull with batching support(DOUBLE) getShort=0 was null true
+ setNull(DECIMAL) getShort=0 was null true
+ setNull with batching support(DECIMAL) getShort=0 was null true
+ setNull(Types.NUMERIC) getShort=0 was null true
+ setNull with batching support(Types.NUMERIC) getShort=0 was null true
+ setNull(Types.BIT) getShort=0 was null true
+ setNull with batching support(Types.BIT) getShort=0 was null true
+ setNull(CHAR) getShort=0 was null true
+ setNull with batching support(CHAR) getShort=0 was null true
+ setNull(VARCHAR) getShort=0 was null true
+ setNull with batching support(VARCHAR) getShort=0 was null true
+ setNull(LONG VARCHAR) getShort=0 was null true
+ setNull with batching support(LONG VARCHAR) getShort=0 was null true
+ setNull(VARCHAR () FOR BIT DATA) IC
+ setNull with batching support(VARCHAR () FOR BIT DATA) IC
+ setNull(DATE) IC
+ setNull with batching support(DATE) IC
+ setNull(TIME) IC
+ setNull with batching support(TIME) IC
+ setNull(TIMESTAMP) IC
+ setNull with batching support(TIMESTAMP) IC
+ setNull(CLOB) IC
+ setNull with batching support(CLOB) IC
+ setNull(BLOB) IC
+ setNull with batching support(BLOB) IC
+ setNull(Types.NULL) IC
+ setNull with batching support(Types.NULL) IC
+ setNull(235350345) IC
+ setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on SMALLINT
+For setXXX() methods that pass an object, a null and valid values are checked
+ setByte() getShort=98 was null false JDBC MATCH(OK)
+ setByte() as batch getShort=98 was null false JDBC MATCH(OK)
+ setShort() getShort=98 was null false JDBC MATCH(OK)
+ setShort() as batch getShort=98 was null false JDBC MATCH(OK)
+ setInt() getShort=98 was null false JDBC MATCH(OK)
+ setInt() as batch getShort=98 was null false JDBC MATCH(OK)
+ setLong() getShort=98 was null false JDBC MATCH(OK)
+ setLong() as batch getShort=98 was null false JDBC MATCH(OK)
+ setFloat() getShort=98 was null false JDBC MATCH(OK)
+ setFloat() as batch getShort=98 was null false JDBC MATCH(OK)
+ setDouble() getShort=98 was null false JDBC MATCH(OK)
+ setDouble() as batch getShort=98 was null false JDBC MATCH(OK)
+ setBoolean() getShort=1 was null false JDBC MATCH(OK)
+ setBoolean() as batch getShort=1 was null false JDBC MATCH(OK)
+ setString() getShort=97 was null false JDBC MATCH(OK)
+ setString() as batch getShort=97 was null false JDBC MATCH(OK)
+ setString(null) getShort=0 was null true JDBC MATCH(OK)
+ setString(null) as batch getShort=0 was null true JDBC MATCH(OK)
+ setString("Invalid Value") IC (Expected)
+ setBytes() IC JDBC MATCH (INVALID)
+ setBytes() as batchIC JDBC MATCH (INVALID)
+ setBytes(null) IC JDBC MATCH (INVALID)
+ setBytes(null) as batchIC JDBC MATCH (INVALID)
+ setDate() IC JDBC MATCH (INVALID)
+ setDate() as batch IC JDBC MATCH (INVALID)
+ setDate(null) IC JDBC MATCH (INVALID)
+ setDate(null) as batch IC JDBC MATCH (INVALID)
+ setTime() IC JDBC MATCH (INVALID)
+ setTime() as batch IC JDBC MATCH (INVALID)
+ setTime(null) IC JDBC MATCH (INVALID)
+ setTime(null) as batch IC JDBC MATCH (INVALID)
+ setTimestamp() IC JDBC MATCH (INVALID)
+ setTimestamp() as batch IC JDBC MATCH (INVALID)
+ setTimestamp(null) IC JDBC MATCH (INVALID)
+ setTimestamp(null) as batch IC JDBC MATCH (INVALID)
+ setAsciiStream() IC JDBC MATCH (INVALID)
+ setAsciiStream() as batch IC JDBC MATCH (INVALID)
+ setAsciiStream(null) IC JDBC MATCH (INVALID)
+ setAsciiStream(null) as batch IC JDBC MATCH (INVALID)
+ setBinaryStream() IC JDBC MATCH (INVALID)
+ setBinaryStream() as batch IC JDBC MATCH (INVALID)
+ setBinaryStream(null) IC JDBC MATCH (INVALID)
+ setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
+ setCharacterStream() IC JDBC MATCH (INVALID)
+ setCharacterStream() as batch IC JDBC MATCH (INVALID)
+ setCharacterStream(null) IC JDBC MATCH (INVALID)
+ setCharacterStream(null) as batch IC JDBC MATCH (INVALID)
+ setClob() IC JDBC MATCH (INVALID)
+ setClob() as batch IC JDBC MATCH (INVALID)
+ setClob(null) IC JDBC MATCH (INVALID)
+ setClob(null) as batch IC JDBC MATCH (INVALID)
+ setBlob() IC JDBC MATCH (INVALID)
+ setBlob() as batch IC JDBC MATCH (INVALID)
+ setBlob(null) IC JDBC MATCH (INVALID)
+ setBlob(null) as batch IC JDBC MATCH (INVALID)
+ setUnicodeStream() ResultSet.setUnicodeStream not present - correct for JSR169
+ setUnicodeStream(null) ResultSet.setUnicodeStream not present - correct for JSR169
+ setObject(null) OK An attempt was made to get a data value of type 'SMALLINT' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'SMALLINT' from a data value of type 'null'.
+ setObject(java.lang.String) getShort=46 was null false JDBC MATCH(OK)
+ setObject(java.lang.String) as batch getShort=46 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) getShort=1 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) as batch getShort=1 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) getShort=74 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) as batch getShort=74 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) getShort=79 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) as batch getShort=79 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) getShort=76 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) as batch getShort=76 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) getShort=12 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) as batch getShort=12 was null false JDBC MATCH(OK)
+ setObject(byte[]) IC JDBC MATCH (INVALID)
+ setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Timestamp) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Blob) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Blob) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Clob) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Clob) as batch IC JDBC MATCH (INVALID)
+CREATE PROCEDURE PMP.TYPE_AS(IN P1 SMALLINT, INOUT P2 SMALLINT, OUT P3 SMALLINT) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.SimpleProcedureTest.pmap'
+INOUT SMALLINT registerOutParameter(Types.TINYINT) -- OK
+OUT SMALLINT registerOutParameter(Types.TINYINT) -- OK
+P2=cs.getByte=38 was null false
+P3=cs.getByte=77 was null false
+INOUT SMALLINT registerOutParameter(Types.SMALLINT) -- OK
+OUT SMALLINT registerOutParameter(Types.SMALLINT) -- OK
+P2=cs.getShort=38 was null false
+P3=cs.getShort=77 was null false
+INOUT SMALLINT registerOutParameter(Types.INTEGER) -- OK
+OUT SMALLINT registerOutParameter(Types.INTEGER) -- OK
+P2=cs.getInt=38 was null false
+P3=cs.getInt=77 was null false
+INOUT SMALLINT registerOutParameter(Types.BIGINT) -- OK
+OUT SMALLINT registerOutParameter(Types.BIGINT) -- OK
+P2=cs.getLong=38 was null false
+P3=cs.getLong=77 was null false
+INOUT SMALLINT registerOutParameter(Types.REAL) -- OK
+OUT SMALLINT registerOutParameter(Types.REAL) -- OK
+P2=cs.getFloat=38.0 was null false
+P3=cs.getFloat=77.0 was null false
+INOUT SMALLINT registerOutParameter(Types.FLOAT) -- OK
+OUT SMALLINT registerOutParameter(Types.FLOAT) -- OK
+P2=cs.getDouble=38.0 was null false
+P3=cs.getDouble=77.0 was null false
+INOUT SMALLINT registerOutParameter(Types.DOUBLE) -- OK
+OUT SMALLINT registerOutParameter(Types.DOUBLE) -- OK
+P2=cs.getDouble=38.0 was null false
+P3=cs.getDouble=77.0 was null false
+INOUT SMALLINT registerOutParameter(Types.DECIMAL) -- OK
+OUT SMALLINT registerOutParameter(Types.DECIMAL) -- OK
+SQLSTATE(22018): SQL Exception: Invalid character string format for type SMALLINT.
+INOUT SMALLINT registerOutParameter(Types.NUMERIC) -- OK
+OUT SMALLINT registerOutParameter(Types.NUMERIC) -- OK
+INOUT SMALLINT registerOutParameter(Types.BIT) -- OK
+OUT SMALLINT registerOutParameter(Types.BIT) -- OK
+P2=cs.getBoolean=true was null false
+P3=cs.getBoolean=true was null false
+INOUT SMALLINT registerOutParameter(Types.CHAR) -- OK
+OUT SMALLINT registerOutParameter(Types.CHAR) -- OK
+P2=cs.getString=38 was null false
+P3=cs.getString=77 was null false
+INOUT SMALLINT registerOutParameter(Types.VARCHAR) -- OK
+OUT SMALLINT registerOutParameter(Types.VARCHAR) -- OK
+P2=cs.getString=38 was null false
+P3=cs.getString=77 was null false
+INOUT SMALLINT registerOutParameter(Types.LONGVARCHAR) -- OK
+OUT SMALLINT registerOutParameter(Types.LONGVARCHAR) -- OK
+P2=cs.getString=38 was null false
+P3=cs.getString=77 was null false
+INOUT SMALLINT registerOutParameter(Types.VARBINARY) -- XCL25
+OUT SMALLINT registerOutParameter(Types.VARBINARY) -- XCL25
+INOUT SMALLINT registerOutParameter(Types.DATE) -- XCL25
+OUT SMALLINT registerOutParameter(Types.DATE) -- XCL25
+INOUT SMALLINT registerOutParameter(Types.TIME) -- XCL25
+OUT SMALLINT registerOutParameter(Types.TIME) -- XCL25
+INOUT SMALLINT registerOutParameter(Types.TIMESTAMP) -- XCL25
+OUT SMALLINT registerOutParameter(Types.TIMESTAMP) -- XCL25
+INOUT SMALLINT registerOutParameter(Types.CLOB) -- XCL25
+OUT SMALLINT registerOutParameter(Types.CLOB) -- XCL25
+INOUT SMALLINT registerOutParameter(Types.BLOB) -- XCL25
+OUT SMALLINT registerOutParameter(Types.BLOB) -- XCL25
+getXXX on : INTEGER
+ NULL VALUE
+ getByte=0 was null true JDBC MATCH(OK)
+ getShort=0 was null true JDBC MATCH(OK)
+ getInt=0 was null true JDBC MATCH(OK)
+ getLong=0 was null true JDBC MATCH(OK)
+ getFloat=0.0 was null true JDBC MATCH(OK)
+ getDouble=0.0 was null true JDBC MATCH(OK)
+ getBoolean=false was null true JDBC MATCH(OK)
+ getString=null was null true JDBC MATCH(OK)
+ getBytes=null was null true CLOUD EXT (OK)
+ getDate=null was null true CLOUD EXT (OK)
+ getTime=null was null true CLOUD EXT (OK)
+ getTimestamp=null was null true CLOUD EXT (OK)
+ getAsciiStream=SPECIFIC CHECK OK
+ getBinaryStream=SPECIFIC CHECK OK
+ getCharacterStream=SPECIFIC CHECK OK
+ getClob=SPECIFIC CHECK OK
+ getBlob=SPECIFIC CHECK OK
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=null was null true
+ VALID VALUE
+ getByte=32 was null false JDBC MATCH(OK)
+ getShort=32 was null false JDBC MATCH(OK)
+ getInt=32 was null false JDBC MATCH(OK)
+ getLong=32 was null false JDBC MATCH(OK)
+ getFloat=32.0 was null false JDBC MATCH(OK)
+ getDouble=32.0 was null false JDBC MATCH(OK)
+ getBoolean=true was null false JDBC MATCH(OK)
+ getString=32 was null false JDBC MATCH(OK)
+ getBytes=IC JDBC MATCH (INVALID)
+ getDate=IC JDBC MATCH (INVALID)
+ getTime=IC JDBC MATCH (INVALID)
+ getTimestamp=IC JDBC MATCH (INVALID)
+ getAsciiStream=IC JDBC MATCH (INVALID)
+ getBinaryStream=IC JDBC MATCH (INVALID)
+ getCharacterStream=IC JDBC MATCH (INVALID)
+ getClob=IC JDBC MATCH (INVALID)
+ getBlob=IC JDBC MATCH (INVALID)
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=CORRECT :java.lang.Integer was null false
+setNull() with all JDBC Types on INTEGER
+ setNull(Types.TINYINT) getInt=0 was null true
+ setNull with batching support(Types.TINYINT) getInt=0 was null true
+ setNull(SMALLINT) getInt=0 was null true
+ setNull with batching support(SMALLINT) getInt=0 was null true
+ setNull(INTEGER) getInt=0 was null true
+ setNull with batching support(INTEGER) getInt=0 was null true
+ setNull(BIGINT) getInt=0 was null true
+ setNull with batching support(BIGINT) getInt=0 was null true
+ setNull(REAL) getInt=0 was null true
+ setNull with batching support(REAL) getInt=0 was null true
+ setNull(Types.FLOAT) getInt=0 was null true
+ setNull with batching support(Types.FLOAT) getInt=0 was null true
+ setNull(DOUBLE) getInt=0 was null true
+ setNull with batching support(DOUBLE) getInt=0 was null true
+ setNull(DECIMAL) getInt=0 was null true
+ setNull with batching support(DECIMAL) getInt=0 was null true
+ setNull(Types.NUMERIC) getInt=0 was null true
+ setNull with batching support(Types.NUMERIC) getInt=0 was null true
+ setNull(Types.BIT) getInt=0 was null true
+ setNull with batching support(Types.BIT) getInt=0 was null true
+ setNull(CHAR) getInt=0 was null true
+ setNull with batching support(CHAR) getInt=0 was null true
+ setNull(VARCHAR) getInt=0 was null true
+ setNull with batching support(VARCHAR) getInt=0 was null true
+ setNull(LONG VARCHAR) getInt=0 was null true
+ setNull with batching support(LONG VARCHAR) getInt=0 was null true
+ setNull(VARCHAR () FOR BIT DATA) IC
+ setNull with batching support(VARCHAR () FOR BIT DATA) IC
+ setNull(DATE) IC
+ setNull with batching support(DATE) IC
+ setNull(TIME) IC
+ setNull with batching support(TIME) IC
+ setNull(TIMESTAMP) IC
+ setNull with batching support(TIMESTAMP) IC
+ setNull(CLOB) IC
+ setNull with batching support(CLOB) IC
+ setNull(BLOB) IC
+ setNull with batching support(BLOB) IC
+ setNull(Types.NULL) IC
+ setNull with batching support(Types.NULL) IC
+ setNull(235350345) IC
+ setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on INTEGER
+For setXXX() methods that pass an object, a null and valid values are checked
+ setByte() getInt=98 was null false JDBC MATCH(OK)
+ setByte() as batch getInt=98 was null false JDBC MATCH(OK)
+ setShort() getInt=98 was null false JDBC MATCH(OK)
+ setShort() as batch getInt=98 was null false JDBC MATCH(OK)
+ setInt() getInt=98 was null false JDBC MATCH(OK)
+ setInt() as batch getInt=98 was null false JDBC MATCH(OK)
+ setLong() getInt=98 was null false JDBC MATCH(OK)
+ setLong() as batch getInt=98 was null false JDBC MATCH(OK)
+ setFloat() getInt=98 was null false JDBC MATCH(OK)
+ setFloat() as batch getInt=98 was null false JDBC MATCH(OK)
+ setDouble() getInt=98 was null false JDBC MATCH(OK)
+ setDouble() as batch getInt=98 was null false JDBC MATCH(OK)
+ setBoolean() getInt=1 was null false JDBC MATCH(OK)
+ setBoolean() as batch getInt=1 was null false JDBC MATCH(OK)
+ setString() getInt=97 was null false JDBC MATCH(OK)
+ setString() as batch getInt=97 was null false JDBC MATCH(OK)
+ setString(null) getInt=0 was null true JDBC MATCH(OK)
+ setString(null) as batch getInt=0 was null true JDBC MATCH(OK)
+ setString("Invalid Value") IC (Expected)
+ setBytes() IC JDBC MATCH (INVALID)
+ setBytes() as batchIC JDBC MATCH (INVALID)
+ setBytes(null) IC JDBC MATCH (INVALID)
+ setBytes(null) as batchIC JDBC MATCH (INVALID)
+ setDate() IC JDBC MATCH (INVALID)
+ setDate() as batch IC JDBC MATCH (INVALID)
+ setDate(null) IC JDBC MATCH (INVALID)
+ setDate(null) as batch IC JDBC MATCH (INVALID)
+ setTime() IC JDBC MATCH (INVALID)
+ setTime() as batch IC JDBC MATCH (INVALID)
+ setTime(null) IC JDBC MATCH (INVALID)
+ setTime(null) as batch IC JDBC MATCH (INVALID)
+ setTimestamp() IC JDBC MATCH (INVALID)
+ setTimestamp() as batch IC JDBC MATCH (INVALID)
+ setTimestamp(null) IC JDBC MATCH (INVALID)
+ setTimestamp(null) as batch IC JDBC MATCH (INVALID)
+ setAsciiStream() IC JDBC MATCH (INVALID)
+ setAsciiStream() as batch IC JDBC MATCH (INVALID)
+ setAsciiStream(null) IC JDBC MATCH (INVALID)
+ setAsciiStream(null) as batch IC JDBC MATCH (INVALID)
+ setBinaryStream() IC JDBC MATCH (INVALID)
+ setBinaryStream() as batch IC JDBC MATCH (INVALID)
+ setBinaryStream(null) IC JDBC MATCH (INVALID)
+ setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
+ setCharacterStream() IC JDBC MATCH (INVALID)
+ setCharacterStream() as batch IC JDBC MATCH (INVALID)
+ setCharacterStream(null) IC JDBC MATCH (INVALID)
+ setCharacterStream(null) as batch IC JDBC MATCH (INVALID)
+ setClob() IC JDBC MATCH (INVALID)
+ setClob() as batch IC JDBC MATCH (INVALID)
+ setClob(null) IC JDBC MATCH (INVALID)
+ setClob(null) as batch IC JDBC MATCH (INVALID)
+ setBlob() IC JDBC MATCH (INVALID)
+ setBlob() as batch IC JDBC MATCH (INVALID)
+ setBlob(null) IC JDBC MATCH (INVALID)
+ setBlob(null) as batch IC JDBC MATCH (INVALID)
+ setUnicodeStream() ResultSet.setUnicodeStream not present - correct for JSR169
+ setUnicodeStream(null) ResultSet.setUnicodeStream not present - correct for JSR169
+ setObject(null) OK An attempt was made to get a data value of type 'INTEGER' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'INTEGER' from a data value of type 'null'.
+ setObject(java.lang.String) getInt=46 was null false JDBC MATCH(OK)
+ setObject(java.lang.String) as batch getInt=46 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) getInt=1 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) as batch getInt=1 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) getInt=74 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) as batch getInt=74 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) getInt=79 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) as batch getInt=79 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) getInt=76 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) as batch getInt=76 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) getInt=12 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) as batch getInt=12 was null false JDBC MATCH(OK)
+ setObject(byte[]) IC JDBC MATCH (INVALID)
+ setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Timestamp) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Blob) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Blob) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Clob) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Clob) as batch IC JDBC MATCH (INVALID)
+CREATE PROCEDURE PMP.TYPE_AS(IN P1 INTEGER, INOUT P2 INTEGER, OUT P3 INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.SimpleProcedureTest.pmap'
+INOUT INTEGER registerOutParameter(Types.TINYINT) -- OK
+OUT INTEGER registerOutParameter(Types.TINYINT) -- OK
+P2=cs.getByte=41 was null false
+P3=cs.getByte=88 was null false
+INOUT INTEGER registerOutParameter(Types.SMALLINT) -- OK
+OUT INTEGER registerOutParameter(Types.SMALLINT) -- OK
+P2=cs.getShort=41 was null false
+P3=cs.getShort=88 was null false
+INOUT INTEGER registerOutParameter(Types.INTEGER) -- OK
+OUT INTEGER registerOutParameter(Types.INTEGER) -- OK
+P2=cs.getInt=41 was null false
+P3=cs.getInt=88 was null false
+INOUT INTEGER registerOutParameter(Types.BIGINT) -- OK
+OUT INTEGER registerOutParameter(Types.BIGINT) -- OK
+P2=cs.getLong=41 was null false
+P3=cs.getLong=88 was null false
+INOUT INTEGER registerOutParameter(Types.REAL) -- OK
+OUT INTEGER registerOutParameter(Types.REAL) -- OK
+P2=cs.getFloat=41.0 was null false
+P3=cs.getFloat=88.0 was null false
+INOUT INTEGER registerOutParameter(Types.FLOAT) -- OK
+OUT INTEGER registerOutParameter(Types.FLOAT) -- OK
+P2=cs.getDouble=41.0 was null false
+P3=cs.getDouble=88.0 was null false
+INOUT INTEGER registerOutParameter(Types.DOUBLE) -- OK
+OUT INTEGER registerOutParameter(Types.DOUBLE) -- OK
+P2=cs.getDouble=41.0 was null false
+P3=cs.getDouble=88.0 was null false
+INOUT INTEGER registerOutParameter(Types.DECIMAL) -- OK
+OUT INTEGER registerOutParameter(Types.DECIMAL) -- OK
+SQLSTATE(22018): SQL Exception: Invalid character string format for type INTEGER.
+INOUT INTEGER registerOutParameter(Types.NUMERIC) -- OK
+OUT INTEGER registerOutParameter(Types.NUMERIC) -- OK
+INOUT INTEGER registerOutParameter(Types.BIT) -- OK
+OUT INTEGER registerOutParameter(Types.BIT) -- OK
+P2=cs.getBoolean=true was null false
+P3=cs.getBoolean=true was null false
+INOUT INTEGER registerOutParameter(Types.CHAR) -- OK
+OUT INTEGER registerOutParameter(Types.CHAR) -- OK
+P2=cs.getString=41 was null false
+P3=cs.getString=88 was null false
+INOUT INTEGER registerOutParameter(Types.VARCHAR) -- OK
+OUT INTEGER registerOutParameter(Types.VARCHAR) -- OK
+P2=cs.getString=41 was null false
+P3=cs.getString=88 was null false
+INOUT INTEGER registerOutParameter(Types.LONGVARCHAR) -- OK
+OUT INTEGER registerOutParameter(Types.LONGVARCHAR) -- OK
+P2=cs.getString=41 was null false
+P3=cs.getString=88 was null false
+INOUT INTEGER registerOutParameter(Types.VARBINARY) -- XCL25
+OUT INTEGER registerOutParameter(Types.VARBINARY) -- XCL25
+INOUT INTEGER registerOutParameter(Types.DATE) -- XCL25
+OUT INTEGER registerOutParameter(Types.DATE) -- XCL25
+INOUT INTEGER registerOutParameter(Types.TIME) -- XCL25
+OUT INTEGER registerOutParameter(Types.TIME) -- XCL25
+INOUT INTEGER registerOutParameter(Types.TIMESTAMP) -- XCL25
+OUT INTEGER registerOutParameter(Types.TIMESTAMP) -- XCL25
+INOUT INTEGER registerOutParameter(Types.CLOB) -- XCL25
+OUT INTEGER registerOutParameter(Types.CLOB) -- XCL25
+INOUT INTEGER registerOutParameter(Types.BLOB) -- XCL25
+OUT INTEGER registerOutParameter(Types.BLOB) -- XCL25
+getXXX on : BIGINT
+ NULL VALUE
+ getByte=0 was null true JDBC MATCH(OK)
+ getShort=0 was null true JDBC MATCH(OK)
+ getInt=0 was null true JDBC MATCH(OK)
+ getLong=0 was null true JDBC MATCH(OK)
+ getFloat=0.0 was null true JDBC MATCH(OK)
+ getDouble=0.0 was null true JDBC MATCH(OK)
+ getBoolean=false was null true JDBC MATCH(OK)
+ getString=null was null true JDBC MATCH(OK)
+ getBytes=null was null true CLOUD EXT (OK)
+ getDate=null was null true CLOUD EXT (OK)
+ getTime=null was null true CLOUD EXT (OK)
+ getTimestamp=null was null true CLOUD EXT (OK)
+ getAsciiStream=SPECIFIC CHECK OK
+ getBinaryStream=SPECIFIC CHECK OK
+ getCharacterStream=SPECIFIC CHECK OK
+ getClob=SPECIFIC CHECK OK
+ getBlob=SPECIFIC CHECK OK
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=null was null true
+ VALID VALUE
+ getByte=32 was null false JDBC MATCH(OK)
+ getShort=32 was null false JDBC MATCH(OK)
+ getInt=32 was null false JDBC MATCH(OK)
+ getLong=32 was null false JDBC MATCH(OK)
+ getFloat=32.0 was null false JDBC MATCH(OK)
+ getDouble=32.0 was null false JDBC MATCH(OK)
+ getBoolean=true was null false JDBC MATCH(OK)
+ getString=32 was null false JDBC MATCH(OK)
+ getBytes=IC JDBC MATCH (INVALID)
+ getDate=IC JDBC MATCH (INVALID)
+ getTime=IC JDBC MATCH (INVALID)
+ getTimestamp=IC JDBC MATCH (INVALID)
+ getAsciiStream=IC JDBC MATCH (INVALID)
+ getBinaryStream=IC JDBC MATCH (INVALID)
+ getCharacterStream=IC JDBC MATCH (INVALID)
+ getClob=IC JDBC MATCH (INVALID)
+ getBlob=IC JDBC MATCH (INVALID)
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=CORRECT :java.lang.Long was null false
+setNull() with all JDBC Types on BIGINT
+ setNull(Types.TINYINT) getLong=0 was null true
+ setNull with batching support(Types.TINYINT) getLong=0 was null true
+ setNull(SMALLINT) getLong=0 was null true
+ setNull with batching support(SMALLINT) getLong=0 was null true
+ setNull(INTEGER) getLong=0 was null true
+ setNull with batching support(INTEGER) getLong=0 was null true
+ setNull(BIGINT) getLong=0 was null true
+ setNull with batching support(BIGINT) getLong=0 was null true
+ setNull(REAL) getLong=0 was null true
+ setNull with batching support(REAL) getLong=0 was null true
+ setNull(Types.FLOAT) getLong=0 was null true
+ setNull with batching support(Types.FLOAT) getLong=0 was null true
+ setNull(DOUBLE) getLong=0 was null true
+ setNull with batching support(DOUBLE) getLong=0 was null true
+ setNull(DECIMAL) getLong=0 was null true
+ setNull with batching support(DECIMAL) getLong=0 was null true
+ setNull(Types.NUMERIC) getLong=0 was null true
+ setNull with batching support(Types.NUMERIC) getLong=0 was null true
+ setNull(Types.BIT) getLong=0 was null true
+ setNull with batching support(Types.BIT) getLong=0 was null true
+ setNull(CHAR) getLong=0 was null true
+ setNull with batching support(CHAR) getLong=0 was null true
+ setNull(VARCHAR) getLong=0 was null true
+ setNull with batching support(VARCHAR) getLong=0 was null true
+ setNull(LONG VARCHAR) getLong=0 was null true
+ setNull with batching support(LONG VARCHAR) getLong=0 was null true
+ setNull(VARCHAR () FOR BIT DATA) IC
+ setNull with batching support(VARCHAR () FOR BIT DATA) IC
+ setNull(DATE) IC
+ setNull with batching support(DATE) IC
+ setNull(TIME) IC
+ setNull with batching support(TIME) IC
+ setNull(TIMESTAMP) IC
+ setNull with batching support(TIMESTAMP) IC
+ setNull(CLOB) IC
+ setNull with batching support(CLOB) IC
+ setNull(BLOB) IC
+ setNull with batching support(BLOB) IC
+ setNull(Types.NULL) IC
+ setNull with batching support(Types.NULL) IC
+ setNull(235350345) IC
+ setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on BIGINT
+For setXXX() methods that pass an object, a null and valid values are checked
+ setByte() getLong=98 was null false JDBC MATCH(OK)
+ setByte() as batch getLong=98 was null false JDBC MATCH(OK)
+ setShort() getLong=98 was null false JDBC MATCH(OK)
+ setShort() as batch getLong=98 was null false JDBC MATCH(OK)
+ setInt() getLong=98 was null false JDBC MATCH(OK)
+ setInt() as batch getLong=98 was null false JDBC MATCH(OK)
+ setLong() getLong=98 was null false JDBC MATCH(OK)
+ setLong() as batch getLong=98 was null false JDBC MATCH(OK)
+ setFloat() getLong=98 was null false JDBC MATCH(OK)
+ setFloat() as batch getLong=98 was null false JDBC MATCH(OK)
+ setDouble() getLong=98 was null false JDBC MATCH(OK)
+ setDouble() as batch getLong=98 was null false JDBC MATCH(OK)
+ setBoolean() getLong=1 was null false JDBC MATCH(OK)
+ setBoolean() as batch getLong=1 was null false JDBC MATCH(OK)
+ setString() getLong=97 was null false JDBC MATCH(OK)
+ setString() as batch getLong=97 was null false JDBC MATCH(OK)
+ setString(null) getLong=0 was null true JDBC MATCH(OK)
+ setString(null) as batch getLong=0 was null true JDBC MATCH(OK)
+ setString("Invalid Value") IC (Expected)
+ setBytes() IC JDBC MATCH (INVALID)
+ setBytes() as batchIC JDBC MATCH (INVALID)
+ setBytes(null) IC JDBC MATCH (INVALID)
+ setBytes(null) as batchIC JDBC MATCH (INVALID)
+ setDate() IC JDBC MATCH (INVALID)
+ setDate() as batch IC JDBC MATCH (INVALID)
+ setDate(null) IC JDBC MATCH (INVALID)
+ setDate(null) as batch IC JDBC MATCH (INVALID)
+ setTime() IC JDBC MATCH (INVALID)
+ setTime() as batch IC JDBC MATCH (INVALID)
+ setTime(null) IC JDBC MATCH (INVALID)
+ setTime(null) as batch IC JDBC MATCH (INVALID)
+ setTimestamp() IC JDBC MATCH (INVALID)
+ setTimestamp() as batch IC JDBC MATCH (INVALID)
+ setTimestamp(null) IC JDBC MATCH (INVALID)
+ setTimestamp(null) as batch IC JDBC MATCH (INVALID)
+ setAsciiStream() IC JDBC MATCH (INVALID)
+ setAsciiStream() as batch IC JDBC MATCH (INVALID)
+ setAsciiStream(null) IC JDBC MATCH (INVALID)
+ setAsciiStream(null) as batch IC JDBC MATCH (INVALID)
+ setBinaryStream() IC JDBC MATCH (INVALID)
+ setBinaryStream() as batch IC JDBC MATCH (INVALID)
+ setBinaryStream(null) IC JDBC MATCH (INVALID)
+ setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
+ setCharacterStream() IC JDBC MATCH (INVALID)
+ setCharacterStream() as batch IC JDBC MATCH (INVALID)
+ setCharacterStream(null) IC JDBC MATCH (INVALID)
+ setCharacterStream(null) as batch IC JDBC MATCH (INVALID)
+ setClob() IC JDBC MATCH (INVALID)
+ setClob() as batch IC JDBC MATCH (INVALID)
+ setClob(null) IC JDBC MATCH (INVALID)
+ setClob(null) as batch IC JDBC MATCH (INVALID)
+ setBlob() IC JDBC MATCH (INVALID)
+ setBlob() as batch IC JDBC MATCH (INVALID)
+ setBlob(null) IC JDBC MATCH (INVALID)
+ setBlob(null) as batch IC JDBC MATCH (INVALID)
+ setUnicodeStream() ResultSet.setUnicodeStream not present - correct for JSR169
+ setUnicodeStream(null) ResultSet.setUnicodeStream not present - correct for JSR169
+ setObject(null) OK An attempt was made to get a data value of type 'BIGINT' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'BIGINT' from a data value of type 'null'.
+ setObject(java.lang.String) getLong=46 was null false JDBC MATCH(OK)
+ setObject(java.lang.String) as batch getLong=46 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) getLong=1 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) as batch getLong=1 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) getLong=74 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) as batch getLong=74 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) getLong=79 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) as batch getLong=79 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) getLong=76 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) as batch getLong=76 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) getLong=12 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) as batch getLong=12 was null false JDBC MATCH(OK)
+ setObject(byte[]) IC JDBC MATCH (INVALID)
+ setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Timestamp) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Blob) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Blob) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Clob) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Clob) as batch IC JDBC MATCH (INVALID)
+CREATE PROCEDURE PMP.TYPE_AS(IN P1 BIGINT, INOUT P2 BIGINT, OUT P3 BIGINT) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.SimpleProcedureTest.pmap'
+INOUT BIGINT registerOutParameter(Types.TINYINT) -- OK
+OUT BIGINT registerOutParameter(Types.TINYINT) -- OK
+P2=cs.getByte=40 was null false
+P3=cs.getByte=99 was null false
+INOUT BIGINT registerOutParameter(Types.SMALLINT) -- OK
+OUT BIGINT registerOutParameter(Types.SMALLINT) -- OK
+P2=cs.getShort=40 was null false
+P3=cs.getShort=99 was null false
+INOUT BIGINT registerOutParameter(Types.INTEGER) -- OK
+OUT BIGINT registerOutParameter(Types.INTEGER) -- OK
+P2=cs.getInt=40 was null false
+P3=cs.getInt=99 was null false
+INOUT BIGINT registerOutParameter(Types.BIGINT) -- OK
+OUT BIGINT registerOutParameter(Types.BIGINT) -- OK
+P2=cs.getLong=40 was null false
+P3=cs.getLong=99 was null false
+INOUT BIGINT registerOutParameter(Types.REAL) -- OK
+OUT BIGINT registerOutParameter(Types.REAL) -- OK
+P2=cs.getFloat=40.0 was null false
+P3=cs.getFloat=99.0 was null false
+INOUT BIGINT registerOutParameter(Types.FLOAT) -- OK
+OUT BIGINT registerOutParameter(Types.FLOAT) -- OK
+P2=cs.getDouble=40.0 was null false
+P3=cs.getDouble=99.0 was null false
+INOUT BIGINT registerOutParameter(Types.DOUBLE) -- OK
+OUT BIGINT registerOutParameter(Types.DOUBLE) -- OK
+P2=cs.getDouble=40.0 was null false
+P3=cs.getDouble=99.0 was null false
+INOUT BIGINT registerOutParameter(Types.DECIMAL) -- OK
+OUT BIGINT registerOutParameter(Types.DECIMAL) -- OK
+SQLSTATE(22018): SQL Exception: Invalid character string format for type BIGINT.
+INOUT BIGINT registerOutParameter(Types.NUMERIC) -- OK
+OUT BIGINT registerOutParameter(Types.NUMERIC) -- OK
+INOUT BIGINT registerOutParameter(Types.BIT) -- OK
+OUT BIGINT registerOutParameter(Types.BIT) -- OK
+P2=cs.getBoolean=true was null false
+P3=cs.getBoolean=true was null false
+INOUT BIGINT registerOutParameter(Types.CHAR) -- OK
+OUT BIGINT registerOutParameter(Types.CHAR) -- OK
+P2=cs.getString=40 was null false
+P3=cs.getString=99 was null false
+INOUT BIGINT registerOutParameter(Types.VARCHAR) -- OK
+OUT BIGINT registerOutParameter(Types.VARCHAR) -- OK
+P2=cs.getString=40 was null false
+P3=cs.getString=99 was null false
+INOUT BIGINT registerOutParameter(Types.LONGVARCHAR) -- OK
+OUT BIGINT registerOutParameter(Types.LONGVARCHAR) -- OK
+P2=cs.getString=40 was null false
+P3=cs.getString=99 was null false
+INOUT BIGINT registerOutParameter(Types.VARBINARY) -- XCL25
+OUT BIGINT registerOutParameter(Types.VARBINARY) -- XCL25
+INOUT BIGINT registerOutParameter(Types.DATE) -- XCL25
+OUT BIGINT registerOutParameter(Types.DATE) -- XCL25
+INOUT BIGINT registerOutParameter(Types.TIME) -- XCL25
+OUT BIGINT registerOutParameter(Types.TIME) -- XCL25
+INOUT BIGINT registerOutParameter(Types.TIMESTAMP) -- XCL25
+OUT BIGINT registerOutParameter(Types.TIMESTAMP) -- XCL25
+INOUT BIGINT registerOutParameter(Types.CLOB) -- XCL25
+OUT BIGINT registerOutParameter(Types.CLOB) -- XCL25
+INOUT BIGINT registerOutParameter(Types.BLOB) -- XCL25
+OUT BIGINT registerOutParameter(Types.BLOB) -- XCL25
+getXXX on : REAL
+ NULL VALUE
+ getByte=0 was null true JDBC MATCH(OK)
+ getShort=0 was null true JDBC MATCH(OK)
+ getInt=0 was null true JDBC MATCH(OK)
+ getLong=0 was null true JDBC MATCH(OK)
+ getFloat=0.0 was null true JDBC MATCH(OK)
+ getDouble=0.0 was null true JDBC MATCH(OK)
+ getBoolean=false was null true JDBC MATCH(OK)
+ getString=null was null true JDBC MATCH(OK)
+ getBytes=null was null true CLOUD EXT (OK)
+ getDate=null was null true CLOUD EXT (OK)
+ getTime=null was null true CLOUD EXT (OK)
+ getTimestamp=null was null true CLOUD EXT (OK)
+ getAsciiStream=SPECIFIC CHECK OK
+ getBinaryStream=SPECIFIC CHECK OK
+ getCharacterStream=SPECIFIC CHECK OK
+ getClob=SPECIFIC CHECK OK
+ getBlob=SPECIFIC CHECK OK
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=null was null true
+ VALID VALUE
+ getByte=32 was null false JDBC MATCH(OK)
+ getShort=32 was null false JDBC MATCH(OK)
+ getInt=32 was null false JDBC MATCH(OK)
+ getLong=32 was null false JDBC MATCH(OK)
+ getFloat=32.0 was null false JDBC MATCH(OK)
+ getDouble=32.0 was null false JDBC MATCH(OK)
+ getBoolean=true was null false JDBC MATCH(OK)
+ getString=32.0 was null false JDBC MATCH(OK)
+ getBytes=IC JDBC MATCH (INVALID)
+ getDate=IC JDBC MATCH (INVALID)
+ getTime=IC JDBC MATCH (INVALID)
+ getTimestamp=IC JDBC MATCH (INVALID)
+ getAsciiStream=IC JDBC MATCH (INVALID)
+ getBinaryStream=IC JDBC MATCH (INVALID)
+ getCharacterStream=IC JDBC MATCH (INVALID)
+ getClob=IC JDBC MATCH (INVALID)
+ getBlob=IC JDBC MATCH (INVALID)
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=CORRECT :java.lang.Float was null false
+setNull() with all JDBC Types on REAL
+ setNull(Types.TINYINT) getFloat=0.0 was null true
+ setNull with batching support(Types.TINYINT) getFloat=0.0 was null true
+ setNull(SMALLINT) getFloat=0.0 was null true
+ setNull with batching support(SMALLINT) getFloat=0.0 was null true
+ setNull(INTEGER) getFloat=0.0 was null true
+ setNull with batching support(INTEGER) getFloat=0.0 was null true
+ setNull(BIGINT) getFloat=0.0 was null true
+ setNull with batching support(BIGINT) getFloat=0.0 was null true
+ setNull(REAL) getFloat=0.0 was null true
+ setNull with batching support(REAL) getFloat=0.0 was null true
+ setNull(Types.FLOAT) getFloat=0.0 was null true
+ setNull with batching support(Types.FLOAT) getFloat=0.0 was null true
+ setNull(DOUBLE) getFloat=0.0 was null true
+ setNull with batching support(DOUBLE) getFloat=0.0 was null true
+ setNull(DECIMAL) getFloat=0.0 was null true
+ setNull with batching support(DECIMAL) getFloat=0.0 was null true
+ setNull(Types.NUMERIC) getFloat=0.0 was null true
+ setNull with batching support(Types.NUMERIC) getFloat=0.0 was null true
+ setNull(Types.BIT) getFloat=0.0 was null true
+ setNull with batching support(Types.BIT) getFloat=0.0 was null true
+ setNull(CHAR) getFloat=0.0 was null true
+ setNull with batching support(CHAR) getFloat=0.0 was null true
+ setNull(VARCHAR) getFloat=0.0 was null true
+ setNull with batching support(VARCHAR) getFloat=0.0 was null true
+ setNull(LONG VARCHAR) getFloat=0.0 was null true
+ setNull with batching support(LONG VARCHAR) getFloat=0.0 was null true
+ setNull(VARCHAR () FOR BIT DATA) IC
+ setNull with batching support(VARCHAR () FOR BIT DATA) IC
+ setNull(DATE) IC
+ setNull with batching support(DATE) IC
+ setNull(TIME) IC
+ setNull with batching support(TIME) IC
+ setNull(TIMESTAMP) IC
+ setNull with batching support(TIMESTAMP) IC
+ setNull(CLOB) IC
+ setNull with batching support(CLOB) IC
+ setNull(BLOB) IC
+ setNull with batching support(BLOB) IC
+ setNull(Types.NULL) IC
+ setNull with batching support(Types.NULL) IC
+ setNull(235350345) IC
+ setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on REAL
+For setXXX() methods that pass an object, a null and valid values are checked
+ setByte() getFloat=98.0 was null false JDBC MATCH(OK)
+ setByte() as batch getFloat=98.0 was null false JDBC MATCH(OK)
+ setShort() getFloat=98.0 was null false JDBC MATCH(OK)
+ setShort() as batch getFloat=98.0 was null false JDBC MATCH(OK)
+ setInt() getFloat=98.0 was null false JDBC MATCH(OK)
+ setInt() as batch getFloat=98.0 was null false JDBC MATCH(OK)
+ setLong() getFloat=98.0 was null false JDBC MATCH(OK)
+ setLong() as batch getFloat=98.0 was null false JDBC MATCH(OK)
+ setFloat() getFloat=98.4 was null false JDBC MATCH(OK)
+ setFloat() as batch getFloat=98.4 was null false JDBC MATCH(OK)
+ setDouble() getFloat=98.5 was null false JDBC MATCH(OK)
+ setDouble() as batch getFloat=98.5 was null false JDBC MATCH(OK)
+ setBoolean() getFloat=1.0 was null false JDBC MATCH(OK)
+ setBoolean() as batch getFloat=1.0 was null false JDBC MATCH(OK)
+ setString() getFloat=97.0 was null false JDBC MATCH(OK)
+ setString() as batch getFloat=97.0 was null false JDBC MATCH(OK)
+ setString(null) getFloat=0.0 was null true JDBC MATCH(OK)
+ setString(null) as batch getFloat=0.0 was null true JDBC MATCH(OK)
+ setString("Invalid Value") IC (Expected)
+ setBytes() IC JDBC MATCH (INVALID)
+ setBytes() as batchIC JDBC MATCH (INVALID)
+ setBytes(null) IC JDBC MATCH (INVALID)
+ setBytes(null) as batchIC JDBC MATCH (INVALID)
+ setDate() IC JDBC MATCH (INVALID)
+ setDate() as batch IC JDBC MATCH (INVALID)
+ setDate(null) IC JDBC MATCH (INVALID)
+ setDate(null) as batch IC JDBC MATCH (INVALID)
+ setTime() IC JDBC MATCH (INVALID)
+ setTime() as batch IC JDBC MATCH (INVALID)
+ setTime(null) IC JDBC MATCH (INVALID)
+ setTime(null) as batch IC JDBC MATCH (INVALID)
+ setTimestamp() IC JDBC MATCH (INVALID)
+ setTimestamp() as batch IC JDBC MATCH (INVALID)
+ setTimestamp(null) IC JDBC MATCH (INVALID)
+ setTimestamp(null) as batch IC JDBC MATCH (INVALID)
+ setAsciiStream() IC JDBC MATCH (INVALID)
+ setAsciiStream() as batch IC JDBC MATCH (INVALID)
+ setAsciiStream(null) IC JDBC MATCH (INVALID)
+ setAsciiStream(null) as batch IC JDBC MATCH (INVALID)
+ setBinaryStream() IC JDBC MATCH (INVALID)
+ setBinaryStream() as batch IC JDBC MATCH (INVALID)
+ setBinaryStream(null) IC JDBC MATCH (INVALID)
+ setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
+ setCharacterStream() IC JDBC MATCH (INVALID)
+ setCharacterStream() as batch IC JDBC MATCH (INVALID)
+ setCharacterStream(null) IC JDBC MATCH (INVALID)
+ setCharacterStream(null) as batch IC JDBC MATCH (INVALID)
+ setClob() IC JDBC MATCH (INVALID)
+ setClob() as batch IC JDBC MATCH (INVALID)
+ setClob(null) IC JDBC MATCH (INVALID)
+ setClob(null) as batch IC JDBC MATCH (INVALID)
+ setBlob() IC JDBC MATCH (INVALID)
+ setBlob() as batch IC JDBC MATCH (INVALID)
+ setBlob(null) IC JDBC MATCH (INVALID)
+ setBlob(null) as batch IC JDBC MATCH (INVALID)
+ setUnicodeStream() ResultSet.setUnicodeStream not present - correct for JSR169
+ setUnicodeStream(null) ResultSet.setUnicodeStream not present - correct for JSR169
+ setObject(null) OK An attempt was made to get a data value of type 'REAL' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'REAL' from a data value of type 'null'.
+ setObject(java.lang.String) getFloat=46.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.String) as batch getFloat=46.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) getFloat=1.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) as batch getFloat=1.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) getFloat=74.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) as batch getFloat=74.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) getFloat=79.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) as batch getFloat=79.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) getFloat=76.3 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) as batch getFloat=76.3 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) getFloat=12.33 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) as batch getFloat=12.33 was null false JDBC MATCH(OK)
+ setObject(byte[]) IC JDBC MATCH (INVALID)
+ setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Timestamp) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Blob) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Blob) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Clob) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Clob) as batch IC JDBC MATCH (INVALID)
+CREATE PROCEDURE PMP.TYPE_AS(IN P1 REAL, INOUT P2 REAL, OUT P3 REAL) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.SimpleProcedureTest.pmap'
+INOUT REAL registerOutParameter(Types.TINYINT) -- OK
+OUT REAL registerOutParameter(Types.TINYINT) -- OK
+P2=cs.getByte=41 was null false
+P3=cs.getByte=88 was null false
+INOUT REAL registerOutParameter(Types.SMALLINT) -- OK
+OUT REAL registerOutParameter(Types.SMALLINT) -- OK
+P2=cs.getShort=41 was null false
+P3=cs.getShort=88 was null false
+INOUT REAL registerOutParameter(Types.INTEGER) -- OK
+OUT REAL registerOutParameter(Types.INTEGER) -- OK
+P2=cs.getInt=41 was null false
+P3=cs.getInt=88 was null false
+INOUT REAL registerOutParameter(Types.BIGINT) -- OK
+OUT REAL registerOutParameter(Types.BIGINT) -- OK
+P2=cs.getLong=41 was null false
+P3=cs.getLong=88 was null false
+INOUT REAL registerOutParameter(Types.REAL) -- OK
+OUT REAL registerOutParameter(Types.REAL) -- OK
+P2=cs.getFloat=41.9 was null false
+P3=cs.getFloat=88.8 was null false
+INOUT REAL registerOutParameter(Types.FLOAT) -- OK
+OUT REAL registerOutParameter(Types.FLOAT) -- OK
+P2=cs.getDouble=41.900001525878906 was null false
+P3=cs.getDouble=88.80000305175781 was null false
+INOUT REAL registerOutParameter(Types.DOUBLE) -- OK
+OUT REAL registerOutParameter(Types.DOUBLE) -- OK
+P2=cs.getDouble=41.900001525878906 was null false
+P3=cs.getDouble=88.80000305175781 was null false
+INOUT REAL registerOutParameter(Types.DECIMAL) -- OK
+OUT REAL registerOutParameter(Types.DECIMAL) -- OK
+P2=cs.getBigDecimal=41.9 was null false
+P3=cs.getBigDecimal=88.8 was null false
+INOUT REAL registerOutParameter(Types.NUMERIC) -- OK
+OUT REAL registerOutParameter(Types.NUMERIC) -- OK
+INOUT REAL registerOutParameter(Types.BIT) -- OK
+OUT REAL registerOutParameter(Types.BIT) -- OK
+P2=cs.getBoolean=true was null false
+P3=cs.getBoolean=true was null false
+INOUT REAL registerOutParameter(Types.CHAR) -- OK
+OUT REAL registerOutParameter(Types.CHAR) -- OK
+P2=cs.getString=41.9 was null false
+P3=cs.getString=88.8 was null false
+INOUT REAL registerOutParameter(Types.VARCHAR) -- OK
+OUT REAL registerOutParameter(Types.VARCHAR) -- OK
+P2=cs.getString=41.9 was null false
+P3=cs.getString=88.8 was null false
+INOUT REAL registerOutParameter(Types.LONGVARCHAR) -- OK
+OUT REAL registerOutParameter(Types.LONGVARCHAR) -- OK
+P2=cs.getString=41.9 was null false
+P3=cs.getString=88.8 was null false
+INOUT REAL registerOutParameter(Types.VARBINARY) -- XCL25
+OUT REAL registerOutParameter(Types.VARBINARY) -- XCL25
+INOUT REAL registerOutParameter(Types.DATE) -- XCL25
+OUT REAL registerOutParameter(Types.DATE) -- XCL25
+INOUT REAL registerOutParameter(Types.TIME) -- XCL25
+OUT REAL registerOutParameter(Types.TIME) -- XCL25
+INOUT REAL registerOutParameter(Types.TIMESTAMP) -- XCL25
+OUT REAL registerOutParameter(Types.TIMESTAMP) -- XCL25
+INOUT REAL registerOutParameter(Types.CLOB) -- XCL25
+OUT REAL registerOutParameter(Types.CLOB) -- XCL25
+INOUT REAL registerOutParameter(Types.BLOB) -- XCL25
+OUT REAL registerOutParameter(Types.BLOB) -- XCL25
+getXXX on : FLOAT
+FAIL - mismatch column type 8 expected 6
+ NULL VALUE
+ getByte=0 was null true JDBC MATCH(OK)
+ getShort=0 was null true JDBC MATCH(OK)
+ getInt=0 was null true JDBC MATCH(OK)
+ getLong=0 was null true JDBC MATCH(OK)
+ getFloat=0.0 was null true JDBC MATCH(OK)
+ getDouble=0.0 was null true JDBC MATCH(OK)
+ getBoolean=false was null true JDBC MATCH(OK)
+ getString=null was null true JDBC MATCH(OK)
+ getBytes=null was null true CLOUD EXT (OK)
+ getDate=null was null true CLOUD EXT (OK)
+ getTime=null was null true CLOUD EXT (OK)
+ getTimestamp=null was null true CLOUD EXT (OK)
+ getAsciiStream=SPECIFIC CHECK OK
+ getBinaryStream=SPECIFIC CHECK OK
+ getCharacterStream=SPECIFIC CHECK OK
+ getClob=SPECIFIC CHECK OK
+ getBlob=SPECIFIC CHECK OK
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=null was null true
+ VALID VALUE
+ getByte=32 was null false JDBC MATCH(OK)
+ getShort=32 was null false JDBC MATCH(OK)
+ getInt=32 was null false JDBC MATCH(OK)
+ getLong=32 was null false JDBC MATCH(OK)
+ getFloat=32.0 was null false JDBC MATCH(OK)
+ getDouble=32.0 was null false JDBC MATCH(OK)
+ getBoolean=true was null false JDBC MATCH(OK)
+ getString=32.0 was null false JDBC MATCH(OK)
+ getBytes=IC JDBC MATCH (INVALID)
+ getDate=IC JDBC MATCH (INVALID)
+ getTime=IC JDBC MATCH (INVALID)
+ getTimestamp=IC JDBC MATCH (INVALID)
+ getAsciiStream=IC JDBC MATCH (INVALID)
+ getBinaryStream=IC JDBC MATCH (INVALID)
+ getCharacterStream=IC JDBC MATCH (INVALID)
+ getClob=IC JDBC MATCH (INVALID)
+ getBlob=IC JDBC MATCH (INVALID)
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=CORRECT :java.lang.Double was null false
+setNull() with all JDBC Types on FLOAT
+ setNull(Types.TINYINT) getDouble=0.0 was null true
+ setNull with batching support(Types.TINYINT) getDouble=0.0 was null true
+ setNull(SMALLINT) getDouble=0.0 was null true
+ setNull with batching support(SMALLINT) getDouble=0.0 was null true
+ setNull(INTEGER) getDouble=0.0 was null true
+ setNull with batching support(INTEGER) getDouble=0.0 was null true
+ setNull(BIGINT) getDouble=0.0 was null true
+ setNull with batching support(BIGINT) getDouble=0.0 was null true
+ setNull(REAL) getDouble=0.0 was null true
+ setNull with batching support(REAL) getDouble=0.0 was null true
+ setNull(Types.FLOAT) getDouble=0.0 was null true
+ setNull with batching support(Types.FLOAT) getDouble=0.0 was null true
+ setNull(DOUBLE) getDouble=0.0 was null true
+ setNull with batching support(DOUBLE) getDouble=0.0 was null true
+ setNull(DECIMAL) getDouble=0.0 was null true
+ setNull with batching support(DECIMAL) getDouble=0.0 was null true
+ setNull(Types.NUMERIC) getDouble=0.0 was null true
+ setNull with batching support(Types.NUMERIC) getDouble=0.0 was null true
+ setNull(Types.BIT) getDouble=0.0 was null true
+ setNull with batching support(Types.BIT) getDouble=0.0 was null true
+ setNull(CHAR) getDouble=0.0 was null true
+ setNull with batching support(CHAR) getDouble=0.0 was null true
+ setNull(VARCHAR) getDouble=0.0 was null true
+ setNull with batching support(VARCHAR) getDouble=0.0 was null true
+ setNull(LONG VARCHAR) getDouble=0.0 was null true
+ setNull with batching support(LONG VARCHAR) getDouble=0.0 was null true
+ setNull(VARCHAR () FOR BIT DATA) IC
+ setNull with batching support(VARCHAR () FOR BIT DATA) IC
+ setNull(DATE) IC
+ setNull with batching support(DATE) IC
+ setNull(TIME) IC
+ setNull with batching support(TIME) IC
+ setNull(TIMESTAMP) IC
+ setNull with batching support(TIMESTAMP) IC
+ setNull(CLOB) IC
+ setNull with batching support(CLOB) IC
+ setNull(BLOB) IC
+ setNull with batching support(BLOB) IC
+ setNull(Types.NULL) IC
+ setNull with batching support(Types.NULL) IC
+ setNull(235350345) IC
+ setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on FLOAT
+For setXXX() methods that pass an object, a null and valid values are checked
+ setByte() getDouble=98.0 was null false JDBC MATCH(OK)
+ setByte() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+ setShort() getDouble=98.0 was null false JDBC MATCH(OK)
+ setShort() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+ setInt() getDouble=98.0 was null false JDBC MATCH(OK)
+ setInt() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+ setLong() getDouble=98.0 was null false JDBC MATCH(OK)
+ setLong() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+ setFloat() getDouble=98.4000015258789 was null false JDBC MATCH(OK)
+ setFloat() as batch getDouble=98.4000015258789 was null false JDBC MATCH(OK)
+ setDouble() getDouble=98.5 was null false JDBC MATCH(OK)
+ setDouble() as batch getDouble=98.5 was null false JDBC MATCH(OK)
+ setBoolean() getDouble=1.0 was null false JDBC MATCH(OK)
+ setBoolean() as batch getDouble=1.0 was null false JDBC MATCH(OK)
+ setString() getDouble=97.0 was null false JDBC MATCH(OK)
+ setString() as batch getDouble=97.0 was null false JDBC MATCH(OK)
+ setString(null) getDouble=0.0 was null true JDBC MATCH(OK)
+ setString(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
+ setString("Invalid Value") IC (Expected)
+ setBytes() IC JDBC MATCH (INVALID)
+ setBytes() as batchIC JDBC MATCH (INVALID)
+ setBytes(null) IC JDBC MATCH (INVALID)
+ setBytes(null) as batchIC JDBC MATCH (INVALID)
+ setDate() IC JDBC MATCH (INVALID)
+ setDate() as batch IC JDBC MATCH (INVALID)
+ setDate(null) IC JDBC MATCH (INVALID)
+ setDate(null) as batch IC JDBC MATCH (INVALID)
+ setTime() IC JDBC MATCH (INVALID)
+ setTime() as batch IC JDBC MATCH (INVALID)
+ setTime(null) IC JDBC MATCH (INVALID)
+ setTime(null) as batch IC JDBC MATCH (INVALID)
+ setTimestamp() IC JDBC MATCH (INVALID)
+ setTimestamp() as batch IC JDBC MATCH (INVALID)
+ setTimestamp(null) IC JDBC MATCH (INVALID)
+ setTimestamp(null) as batch IC JDBC MATCH (INVALID)
+ setAsciiStream() IC JDBC MATCH (INVALID)
+ setAsciiStream() as batch IC JDBC MATCH (INVALID)
+ setAsciiStream(null) IC JDBC MATCH (INVALID)
+ setAsciiStream(null) as batch IC JDBC MATCH (INVALID)
+ setBinaryStream() IC JDBC MATCH (INVALID)
+ setBinaryStream() as batch IC JDBC MATCH (INVALID)
+ setBinaryStream(null) IC JDBC MATCH (INVALID)
+ setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
+ setCharacterStream() IC JDBC MATCH (INVALID)
+ setCharacterStream() as batch IC JDBC MATCH (INVALID)
+ setCharacterStream(null) IC JDBC MATCH (INVALID)
+ setCharacterStream(null) as batch IC JDBC MATCH (INVALID)
+ setClob() IC JDBC MATCH (INVALID)
+ setClob() as batch IC JDBC MATCH (INVALID)
+ setClob(null) IC JDBC MATCH (INVALID)
+ setClob(null) as batch IC JDBC MATCH (INVALID)
+ setBlob() IC JDBC MATCH (INVALID)
+ setBlob() as batch IC JDBC MATCH (INVALID)
+ setBlob(null) IC JDBC MATCH (INVALID)
+ setBlob(null) as batch IC JDBC MATCH (INVALID)
+ setUnicodeStream() ResultSet.setUnicodeStream not present - correct for JSR169
+ setUnicodeStream(null) ResultSet.setUnicodeStream not present - correct for JSR169
+ setObject(null) OK An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'null'.
+ setObject(java.lang.String) getDouble=46.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.String) as batch getDouble=46.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) getDouble=1.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) as batch getDouble=1.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) getDouble=74.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) as batch getDouble=74.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) getDouble=79.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) as batch getDouble=79.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) getDouble=76.30000305175781 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) as batch getDouble=76.30000305175781 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) getDouble=12.33 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) as batch getDouble=12.33 was null false JDBC MATCH(OK)
+ setObject(byte[]) IC JDBC MATCH (INVALID)
+ setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Timestamp) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Blob) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Blob) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Clob) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Clob) as batch IC JDBC MATCH (INVALID)
+CREATE PROCEDURE PMP.TYPE_AS(IN P1 FLOAT, INOUT P2 FLOAT, OUT P3 FLOAT) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.SimpleProcedureTest.pmap'
+INOUT FLOAT registerOutParameter(Types.TINYINT) -- OK
+OUT FLOAT registerOutParameter(Types.TINYINT) -- OK
+P2=cs.getByte=35 was null false
+P3=cs.getByte=66 was null false
+INOUT FLOAT registerOutParameter(Types.SMALLINT) -- OK
+OUT FLOAT registerOutParameter(Types.SMALLINT) -- OK
+P2=cs.getShort=35 was null false
+P3=cs.getShort=66 was null false
+INOUT FLOAT registerOutParameter(Types.INTEGER) -- OK
+OUT FLOAT registerOutParameter(Types.INTEGER) -- OK
+P2=cs.getInt=35 was null false
+P3=cs.getInt=66 was null false
+INOUT FLOAT registerOutParameter(Types.BIGINT) -- OK
+OUT FLOAT registerOutParameter(Types.BIGINT) -- OK
+P2=cs.getLong=35 was null false
+P3=cs.getLong=66 was null false
+INOUT FLOAT registerOutParameter(Types.REAL) -- OK
+OUT FLOAT registerOutParameter(Types.REAL) -- OK
+P2=cs.getFloat=35.9 was null false
+P3=cs.getFloat=66.8 was null false
+INOUT FLOAT registerOutParameter(Types.FLOAT) -- OK
+OUT FLOAT registerOutParameter(Types.FLOAT) -- OK
+P2=cs.getDouble=35.9 was null false
+P3=cs.getDouble=66.8 was null false
+INOUT FLOAT registerOutParameter(Types.DOUBLE) -- OK
+OUT FLOAT registerOutParameter(Types.DOUBLE) -- OK
+P2=cs.getDouble=35.9 was null false
+P3=cs.getDouble=66.8 was null false
+INOUT FLOAT registerOutParameter(Types.DECIMAL) -- OK
+OUT FLOAT registerOutParameter(Types.DECIMAL) -- OK
+P2=cs.getBigDecimal=35.9 was null false
+P3=cs.getBigDecimal=66.8 was null false
+INOUT FLOAT registerOutParameter(Types.NUMERIC) -- OK
+OUT FLOAT registerOutParameter(Types.NUMERIC) -- OK
+INOUT FLOAT registerOutParameter(Types.BIT) -- OK
+OUT FLOAT registerOutParameter(Types.BIT) -- OK
+P2=cs.getBoolean=true was null false
+P3=cs.getBoolean=true was null false
+INOUT FLOAT registerOutParameter(Types.CHAR) -- OK
+OUT FLOAT registerOutParameter(Types.CHAR) -- OK
+P2=cs.getString=35.9 was null false
+P3=cs.getString=66.8 was null false
+INOUT FLOAT registerOutParameter(Types.VARCHAR) -- OK
+OUT FLOAT registerOutParameter(Types.VARCHAR) -- OK
+P2=cs.getString=35.9 was null false
+P3=cs.getString=66.8 was null false
+INOUT FLOAT registerOutParameter(Types.LONGVARCHAR) -- OK
+OUT FLOAT registerOutParameter(Types.LONGVARCHAR) -- OK
+P2=cs.getString=35.9 was null false
+P3=cs.getString=66.8 was null false
+INOUT FLOAT registerOutParameter(Types.VARBINARY) -- XCL25
+OUT FLOAT registerOutParameter(Types.VARBINARY) -- XCL25
+INOUT FLOAT registerOutParameter(Types.DATE) -- XCL25
+OUT FLOAT registerOutParameter(Types.DATE) -- XCL25
+INOUT FLOAT registerOutParameter(Types.TIME) -- XCL25
+OUT FLOAT registerOutParameter(Types.TIME) -- XCL25
+INOUT FLOAT registerOutParameter(Types.TIMESTAMP) -- XCL25
+OUT FLOAT registerOutParameter(Types.TIMESTAMP) -- XCL25
+INOUT FLOAT registerOutParameter(Types.CLOB) -- XCL25
+OUT FLOAT registerOutParameter(Types.CLOB) -- XCL25
+INOUT FLOAT registerOutParameter(Types.BLOB) -- XCL25
+OUT FLOAT registerOutParameter(Types.BLOB) -- XCL25
+getXXX on : DOUBLE
+ NULL VALUE
+ getByte=0 was null true JDBC MATCH(OK)
+ getShort=0 was null true JDBC MATCH(OK)
+ getInt=0 was null true JDBC MATCH(OK)
+ getLong=0 was null true JDBC MATCH(OK)
+ getFloat=0.0 was null true JDBC MATCH(OK)
+ getDouble=0.0 was null true JDBC MATCH(OK)
+ getBoolean=false was null true JDBC MATCH(OK)
+ getString=null was null true JDBC MATCH(OK)
+ getBytes=null was null true CLOUD EXT (OK)
+ getDate=null was null true CLOUD EXT (OK)
+ getTime=null was null true CLOUD EXT (OK)
+ getTimestamp=null was null true CLOUD EXT (OK)
+ getAsciiStream=SPECIFIC CHECK OK
+ getBinaryStream=SPECIFIC CHECK OK
+ getCharacterStream=SPECIFIC CHECK OK
+ getClob=SPECIFIC CHECK OK
+ getBlob=SPECIFIC CHECK OK
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=null was null true
+ VALID VALUE
+ getByte=32 was null false JDBC MATCH(OK)
+ getShort=32 was null false JDBC MATCH(OK)
+ getInt=32 was null false JDBC MATCH(OK)
+ getLong=32 was null false JDBC MATCH(OK)
+ getFloat=32.0 was null false JDBC MATCH(OK)
+ getDouble=32.0 was null false JDBC MATCH(OK)
+ getBoolean=true was null false JDBC MATCH(OK)
+ getString=32.0 was null false JDBC MATCH(OK)
+ getBytes=IC JDBC MATCH (INVALID)
+ getDate=IC JDBC MATCH (INVALID)
+ getTime=IC JDBC MATCH (INVALID)
+ getTimestamp=IC JDBC MATCH (INVALID)
+ getAsciiStream=IC JDBC MATCH (INVALID)
+ getBinaryStream=IC JDBC MATCH (INVALID)
+ getCharacterStream=IC JDBC MATCH (INVALID)
+ getClob=IC JDBC MATCH (INVALID)
+ getBlob=IC JDBC MATCH (INVALID)
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=CORRECT :java.lang.Double was null false
+setNull() with all JDBC Types on DOUBLE
+ setNull(Types.TINYINT) getDouble=0.0 was null true
+ setNull with batching support(Types.TINYINT) getDouble=0.0 was null true
+ setNull(SMALLINT) getDouble=0.0 was null true
+ setNull with batching support(SMALLINT) getDouble=0.0 was null true
+ setNull(INTEGER) getDouble=0.0 was null true
+ setNull with batching support(INTEGER) getDouble=0.0 was null true
+ setNull(BIGINT) getDouble=0.0 was null true
+ setNull with batching support(BIGINT) getDouble=0.0 was null true
+ setNull(REAL) getDouble=0.0 was null true
+ setNull with batching support(REAL) getDouble=0.0 was null true
+ setNull(Types.FLOAT) getDouble=0.0 was null true
+ setNull with batching support(Types.FLOAT) getDouble=0.0 was null true
+ setNull(DOUBLE) getDouble=0.0 was null true
+ setNull with batching support(DOUBLE) getDouble=0.0 was null true
+ setNull(DECIMAL) getDouble=0.0 was null true
+ setNull with batching support(DECIMAL) getDouble=0.0 was null true
+ setNull(Types.NUMERIC) getDouble=0.0 was null true
+ setNull with batching support(Types.NUMERIC) getDouble=0.0 was null true
+ setNull(Types.BIT) getDouble=0.0 was null true
+ setNull with batching support(Types.BIT) getDouble=0.0 was null true
+ setNull(CHAR) getDouble=0.0 was null true
+ setNull with batching support(CHAR) getDouble=0.0 was null true
+ setNull(VARCHAR) getDouble=0.0 was null true
+ setNull with batching support(VARCHAR) getDouble=0.0 was null true
+ setNull(LONG VARCHAR) getDouble=0.0 was null true
+ setNull with batching support(LONG VARCHAR) getDouble=0.0 was null true
+ setNull(VARCHAR () FOR BIT DATA) IC
+ setNull with batching support(VARCHAR () FOR BIT DATA) IC
+ setNull(DATE) IC
+ setNull with batching support(DATE) IC
+ setNull(TIME) IC
+ setNull with batching support(TIME) IC
+ setNull(TIMESTAMP) IC
+ setNull with batching support(TIMESTAMP) IC
+ setNull(CLOB) IC
+ setNull with batching support(CLOB) IC
+ setNull(BLOB) IC
+ setNull with batching support(BLOB) IC
+ setNull(Types.NULL) IC
+ setNull with batching support(Types.NULL) IC
+ setNull(235350345) IC
+ setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on DOUBLE
+For setXXX() methods that pass an object, a null and valid values are checked
+ setByte() getDouble=98.0 was null false JDBC MATCH(OK)
+ setByte() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+ setShort() getDouble=98.0 was null false JDBC MATCH(OK)
+ setShort() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+ setInt() getDouble=98.0 was null false JDBC MATCH(OK)
+ setInt() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+ setLong() getDouble=98.0 was null false JDBC MATCH(OK)
+ setLong() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+ setFloat() getDouble=98.4000015258789 was null false JDBC MATCH(OK)
+ setFloat() as batch getDouble=98.4000015258789 was null false JDBC MATCH(OK)
+ setDouble() getDouble=98.5 was null false JDBC MATCH(OK)
+ setDouble() as batch getDouble=98.5 was null false JDBC MATCH(OK)
+ setBoolean() getDouble=1.0 was null false JDBC MATCH(OK)
+ setBoolean() as batch getDouble=1.0 was null false JDBC MATCH(OK)
+ setString() getDouble=97.0 was null false JDBC MATCH(OK)
+ setString() as batch getDouble=97.0 was null false JDBC MATCH(OK)
+ setString(null) getDouble=0.0 was null true JDBC MATCH(OK)
+ setString(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
+ setString("Invalid Value") IC (Expected)
+ setBytes() IC JDBC MATCH (INVALID)
+ setBytes() as batchIC JDBC MATCH (INVALID)
+ setBytes(null) IC JDBC MATCH (INVALID)
+ setBytes(null) as batchIC JDBC MATCH (INVALID)
+ setDate() IC JDBC MATCH (INVALID)
+ setDate() as batch IC JDBC MATCH (INVALID)
+ setDate(null) IC JDBC MATCH (INVALID)
+ setDate(null) as batch IC JDBC MATCH (INVALID)
+ setTime() IC JDBC MATCH (INVALID)
+ setTime() as batch IC JDBC MATCH (INVALID)
+ setTime(null) IC JDBC MATCH (INVALID)
+ setTime(null) as batch IC JDBC MATCH (INVALID)
+ setTimestamp() IC JDBC MATCH (INVALID)
+ setTimestamp() as batch IC JDBC MATCH (INVALID)
+ setTimestamp(null) IC JDBC MATCH (INVALID)
+ setTimestamp(null) as batch IC JDBC MATCH (INVALID)
+ setAsciiStream() IC JDBC MATCH (INVALID)
+ setAsciiStream() as batch IC JDBC MATCH (INVALID)
+ setAsciiStream(null) IC JDBC MATCH (INVALID)
+ setAsciiStream(null) as batch IC JDBC MATCH (INVALID)
+ setBinaryStream() IC JDBC MATCH (INVALID)
+ setBinaryStream() as batch IC JDBC MATCH (INVALID)
+ setBinaryStream(null) IC JDBC MATCH (INVALID)
+ setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
+ setCharacterStream() IC JDBC MATCH (INVALID)
+ setCharacterStream() as batch IC JDBC MATCH (INVALID)
+ setCharacterStream(null) IC JDBC MATCH (INVALID)
+ setCharacterStream(null) as batch IC JDBC MATCH (INVALID)
+ setClob() IC JDBC MATCH (INVALID)
+ setClob() as batch IC JDBC MATCH (INVALID)
+ setClob(null) IC JDBC MATCH (INVALID)
+ setClob(null) as batch IC JDBC MATCH (INVALID)
+ setBlob() IC JDBC MATCH (INVALID)
+ setBlob() as batch IC JDBC MATCH (INVALID)
+ setBlob(null) IC JDBC MATCH (INVALID)
+ setBlob(null) as batch IC JDBC MATCH (INVALID)
+ setUnicodeStream() ResultSet.setUnicodeStream not present - correct for JSR169
+ setUnicodeStream(null) ResultSet.setUnicodeStream not present - correct for JSR169
+ setObject(null) OK An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'null'.
+ setObject(java.lang.String) getDouble=46.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.String) as batch getDouble=46.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) getDouble=1.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) as batch getDouble=1.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) getDouble=74.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) as batch getDouble=74.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) getDouble=79.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) as batch getDouble=79.0 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) getDouble=76.30000305175781 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) as batch getDouble=76.30000305175781 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) getDouble=12.33 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) as batch getDouble=12.33 was null false JDBC MATCH(OK)
+ setObject(byte[]) IC JDBC MATCH (INVALID)
+ setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Timestamp) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Blob) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Blob) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Clob) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Clob) as batch IC JDBC MATCH (INVALID)
+CREATE PROCEDURE PMP.TYPE_AS(IN P1 DOUBLE, INOUT P2 DOUBLE, OUT P3 DOUBLE) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.SimpleProcedureTest.pmap'
+INOUT DOUBLE registerOutParameter(Types.TINYINT) -- OK
+OUT DOUBLE registerOutParameter(Types.TINYINT) -- OK
+P2=cs.getByte=35 was null false
+P3=cs.getByte=66 was null false
+INOUT DOUBLE registerOutParameter(Types.SMALLINT) -- OK
+OUT DOUBLE registerOutParameter(Types.SMALLINT) -- OK
+P2=cs.getShort=35 was null false
+P3=cs.getShort=66 was null false
+INOUT DOUBLE registerOutParameter(Types.INTEGER) -- OK
+OUT DOUBLE registerOutParameter(Types.INTEGER) -- OK
+P2=cs.getInt=35 was null false
+P3=cs.getInt=66 was null false
+INOUT DOUBLE registerOutParameter(Types.BIGINT) -- OK
+OUT DOUBLE registerOutParameter(Types.BIGINT) -- OK
+P2=cs.getLong=35 was null false
+P3=cs.getLong=66 was null false
+INOUT DOUBLE registerOutParameter(Types.REAL) -- OK
+OUT DOUBLE registerOutParameter(Types.REAL) -- OK
+P2=cs.getFloat=35.9 was null false
+P3=cs.getFloat=66.8 was null false
+INOUT DOUBLE registerOutParameter(Types.FLOAT) -- OK
+OUT DOUBLE registerOutParameter(Types.FLOAT) -- OK
+P2=cs.getDouble=35.9 was null false
+P3=cs.getDouble=66.8 was null false
+INOUT DOUBLE registerOutParameter(Types.DOUBLE) -- OK
+OUT DOUBLE registerOutParameter(Types.DOUBLE) -- OK
+P2=cs.getDouble=35.9 was null false
+P3=cs.getDouble=66.8 was null false
+INOUT DOUBLE registerOutParameter(Types.DECIMAL) -- OK
+OUT DOUBLE registerOutParameter(Types.DECIMAL) -- OK
+P2=cs.getBigDecimal=35.9 was null false
+P3=cs.getBigDecimal=66.8 was null false
+INOUT DOUBLE registerOutParameter(Types.NUMERIC) -- OK
+OUT DOUBLE registerOutParameter(Types.NUMERIC) -- OK
+INOUT DOUBLE registerOutParameter(Types.BIT) -- OK
+OUT DOUBLE registerOutParameter(Types.BIT) -- OK
+P2=cs.getBoolean=true was null false
+P3=cs.getBoolean=true was null false
+INOUT DOUBLE registerOutParameter(Types.CHAR) -- OK
+OUT DOUBLE registerOutParameter(Types.CHAR) -- OK
+P2=cs.getString=35.9 was null false
+P3=cs.getString=66.8 was null false
+INOUT DOUBLE registerOutParameter(Types.VARCHAR) -- OK
+OUT DOUBLE registerOutParameter(Types.VARCHAR) -- OK
+P2=cs.getString=35.9 was null false
+P3=cs.getString=66.8 was null false
+INOUT DOUBLE registerOutParameter(Types.LONGVARCHAR) -- OK
+OUT DOUBLE registerOutParameter(Types.LONGVARCHAR) -- OK
+P2=cs.getString=35.9 was null false
+P3=cs.getString=66.8 was null false
+INOUT DOUBLE registerOutParameter(Types.VARBINARY) -- XCL25
+OUT DOUBLE registerOutParameter(Types.VARBINARY) -- XCL25
+INOUT DOUBLE registerOutParameter(Types.DATE) -- XCL25
+OUT DOUBLE registerOutParameter(Types.DATE) -- XCL25
+INOUT DOUBLE registerOutParameter(Types.TIME) -- XCL25
+OUT DOUBLE registerOutParameter(Types.TIME) -- XCL25
+INOUT DOUBLE registerOutParameter(Types.TIMESTAMP) -- XCL25
+OUT DOUBLE registerOutParameter(Types.TIMESTAMP) -- XCL25
+INOUT DOUBLE registerOutParameter(Types.CLOB) -- XCL25
+OUT DOUBLE registerOutParameter(Types.CLOB) -- XCL25
+INOUT DOUBLE registerOutParameter(Types.BLOB) -- XCL25
+OUT DOUBLE registerOutParameter(Types.BLOB) -- XCL25
+getXXX on : DECIMAL(10,5)
+ NULL VALUE
+ getByte=0 was null true JDBC MATCH(OK)
+ getShort=0 was null true JDBC MATCH(OK)
+ getInt=0 was null true JDBC MATCH(OK)
+ getLong=0 was null true JDBC MATCH(OK)
+ getFloat=0.0 was null true JDBC MATCH(OK)
+ getDouble=0.0 was null true JDBC MATCH(OK)
+ getBoolean=false was null true JDBC MATCH(OK)
+ getString=null was null true JDBC MATCH(OK)
+ getBytes=null was null true CLOUD EXT (OK)
+ getDate=null was null true CLOUD EXT (OK)
+ getTime=null was null true CLOUD EXT (OK)
+ getTimestamp=null was null true CLOUD EXT (OK)
+ getAsciiStream=SPECIFIC CHECK OK
+ getBinaryStream=SPECIFIC CHECK OK
+ getCharacterStream=SPECIFIC CHECK OK
+ getClob=SPECIFIC CHECK OK
+ getBlob=SPECIFIC CHECK OK
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=ResultSet.getObject not called for DECIMAL type for JSR169 was null false
+ VALID VALUE
+ getByte=32 was null false JDBC MATCH(OK)
+ getShort=32 was null false JDBC MATCH(OK)
+ getInt=32 was null false JDBC MATCH(OK)
+ getLong=32 was null false JDBC MATCH(OK)
+ getFloat=32.0 was null false JDBC MATCH(OK)
+ getDouble=32.0 was null false JDBC MATCH(OK)
+ getBoolean=true was null false JDBC MATCH(OK)
+ getString=32.00000 was null false JDBC MATCH(OK)
+ getBytes=IC JDBC MATCH (INVALID)
+ getDate=IC JDBC MATCH (INVALID)
+ getTime=IC JDBC MATCH (INVALID)
+ getTimestamp=IC JDBC MATCH (INVALID)
+ getAsciiStream=IC JDBC MATCH (INVALID)
+ getBinaryStream=IC JDBC MATCH (INVALID)
+ getCharacterStream=IC JDBC MATCH (INVALID)
+ getClob=IC JDBC MATCH (INVALID)
+ getBlob=IC JDBC MATCH (INVALID)
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=ResultSet.getObject not called for DECIMAL type for JSR169 was null false
+setNull() with all JDBC Types on DECIMAL(10,5)
+ setNull(Types.TINYINT) getBigDecimal=null was null true
+ setNull with batching support(Types.TINYINT) IC
+ setNull(SMALLINT) getBigDecimal=null was null true
+ setNull with batching support(SMALLINT) IC
+ setNull(INTEGER) getBigDecimal=null was null true
+ setNull with batching support(INTEGER) IC
+ setNull(BIGINT) getBigDecimal=null was null true
+ setNull with batching support(BIGINT) IC
+ setNull(REAL) getBigDecimal=null was null true
+ setNull with batching support(REAL) IC
+ setNull(Types.FLOAT) getBigDecimal=null was null true
+ setNull with batching support(Types.FLOAT) IC
+ setNull(DOUBLE) getBigDecimal=null was null true
+ setNull with batching support(DOUBLE) IC
+ setNull(DECIMAL) getBigDecimal=null was null true
+ setNull with batching support(DECIMAL) IC
+ setNull(Types.NUMERIC) getBigDecimal=null was null true
+ setNull with batching support(Types.NUMERIC) IC
+ setNull(Types.BIT) getBigDecimal=null was null true
+ setNull with batching support(Types.BIT) IC
+ setNull(CHAR) getBigDecimal=null was null true
+ setNull with batching support(CHAR) IC
+ setNull(VARCHAR) getBigDecimal=null was null true
+ setNull with batching support(VARCHAR) IC
+ setNull(LONG VARCHAR) getBigDecimal=null was null true
+ setNull with batching support(LONG VARCHAR) IC
+ setNull(VARCHAR () FOR BIT DATA) IC
+ setNull with batching support(VARCHAR () FOR BIT DATA) IC
+ setNull(DATE) IC
+ setNull with batching support(DATE) IC
+ setNull(TIME) IC
+ setNull with batching support(TIME) IC
+ setNull(TIMESTAMP) IC
+ setNull with batching support(TIMESTAMP) IC
+ setNull(CLOB) IC
+ setNull with batching support(CLOB) IC
+ setNull(BLOB) IC
+ setNull with batching support(BLOB) IC
+ setNull(Types.NULL) IC
+ setNull with batching support(Types.NULL) IC
+ setNull(235350345) IC
+ setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on DECIMAL(10,5)
+For setXXX() methods that pass an object, a null and valid values are checked
+ setByte() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+ setByte() as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setShort() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+ setShort() as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setInt() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+ setInt() as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setLong() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+ setLong() as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setFloat() getBigDecimal=98.40000 was null false JDBC MATCH(OK)
+ setFloat() as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setDouble() getBigDecimal=98.50000 was null false JDBC MATCH(OK)
+ setDouble() as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setBoolean() getBigDecimal=1.00000 was null false JDBC MATCH(OK)
+ setBoolean() as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setString() getBigDecimal=97.00000 was null false JDBC MATCH(OK)
+ setString() as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setString(null) getBigDecimal=null was null true JDBC MATCH(OK)
+ setString(null) as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setString("Invalid Value") IC (Expected)
+ setBytes() IC JDBC MATCH (INVALID)
+ setBytes() as batchIC JDBC MATCH (INVALID)
+ setBytes(null) IC JDBC MATCH (INVALID)
+ setBytes(null) as batchIC JDBC MATCH (INVALID)
+ setDate() IC JDBC MATCH (INVALID)
+ setDate() as batch IC JDBC MATCH (INVALID)
+ setDate(null) IC JDBC MATCH (INVALID)
+ setDate(null) as batch IC JDBC MATCH (INVALID)
+ setTime() IC JDBC MATCH (INVALID)
+ setTime() as batch IC JDBC MATCH (INVALID)
+ setTime(null) IC JDBC MATCH (INVALID)
+ setTime(null) as batch IC JDBC MATCH (INVALID)
+ setTimestamp() IC JDBC MATCH (INVALID)
+ setTimestamp() as batch IC JDBC MATCH (INVALID)
+ setTimestamp(null) IC JDBC MATCH (INVALID)
+ setTimestamp(null) as batch IC JDBC MATCH (INVALID)
+ setAsciiStream() IC JDBC MATCH (INVALID)
+ setAsciiStream() as batch IC JDBC MATCH (INVALID)
+ setAsciiStream(null) IC JDBC MATCH (INVALID)
+ setAsciiStream(null) as batch IC JDBC MATCH (INVALID)
+ setBinaryStream() IC JDBC MATCH (INVALID)
+ setBinaryStream() as batch IC JDBC MATCH (INVALID)
+ setBinaryStream(null) IC JDBC MATCH (INVALID)
+ setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
+ setCharacterStream() IC JDBC MATCH (INVALID)
+ setCharacterStream() as batch IC JDBC MATCH (INVALID)
+ setCharacterStream(null) IC JDBC MATCH (INVALID)
+ setCharacterStream(null) as batch IC JDBC MATCH (INVALID)
+ setClob() IC JDBC MATCH (INVALID)
+ setClob() as batch IC JDBC MATCH (INVALID)
+ setClob(null) IC JDBC MATCH (INVALID)
+ setClob(null) as batch IC JDBC MATCH (INVALID)
+ setBlob() IC JDBC MATCH (INVALID)
+ setBlob() as batch IC JDBC MATCH (INVALID)
+ setBlob(null) IC JDBC MATCH (INVALID)
+ setBlob(null) as batch IC JDBC MATCH (INVALID)
+ setUnicodeStream() ResultSet.setUnicodeStream not present - correct for JSR169
+ setUnicodeStream(null) ResultSet.setUnicodeStream not present - correct for JSR169
+ setObject(null) OK An attempt was made to get a data value of type 'DECIMAL' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'DECIMAL' from a data value of type 'null'.
+ setObject(java.lang.String) getBigDecimal=46.00000 was null false JDBC MATCH(OK)
+ setObject(java.lang.String) as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setObject(java.lang.Boolean) getBigDecimal=1.00000 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setObject(java.lang.Integer) getBigDecimal=74.00000 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setObject(java.lang.Long) getBigDecimal=79.00000 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setObject(java.lang.Float) getBigDecimal=76.30000 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setObject(java.lang.Double) getBigDecimal=12.33000 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) as batch (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. (22005):An attempt was made to get a data value of type 'java.lang.Object' from a data value of type 'DECIMAL'. JDBC FAIL DECIMAL(10,5)
+ setObject(byte[]) IC JDBC MATCH (INVALID)
+ setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Timestamp) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Blob) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Blob) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Clob) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Clob) as batch IC JDBC MATCH (INVALID)
+getXXX on : 2
+ skipping
+getXXX on : -7
+ skipping
+getXXX on : 0
+ skipping
+getXXX on : CHAR(60)
+ NULL VALUE
+ getByte=0 was null true JDBC MATCH(OK)
+ getShort=0 was null true JDBC MATCH(OK)
+ getInt=0 was null true JDBC MATCH(OK)
+ getLong=0 was null true JDBC MATCH(OK)
+ getFloat=0.0 was null true JDBC MATCH(OK)
+ getDouble=0.0 was null true JDBC MATCH(OK)
+ getBoolean=false was null true JDBC MATCH(OK)
+ getString=null was null true JDBC MATCH(OK)
+ getBytes=null was null true CLOUD EXT (OK)
+ getDate=null was null true JDBC MATCH(OK)
+ getTime=null was null true JDBC MATCH(OK)
+ getTimestamp=null was null true JDBC MATCH(OK)
+ getAsciiStream=null was null true JDBC MATCH(OK)
+ getBinaryStream=SPECIFIC CHECK OK
+ getCharacterStream=null was null true JDBC MATCH(OK)
+ getClob=SPECIFIC CHECK OK
+ getBlob=SPECIFIC CHECK OK
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=null was null true
+ VALID VALUE
+ getByte=32 was null false JDBC MATCH(OK)
+ getShort=32 was null false JDBC MATCH(OK)
+ getInt=32 was null false JDBC MATCH(OK)
+ getLong=32 was null false JDBC MATCH(OK)
+ getFloat=32.0 was null false JDBC MATCH(OK)
+ getDouble=32.0 was null false JDBC MATCH(OK)
+ getBoolean=true was null false JDBC MATCH(OK)
+ getString=32 was null false JDBC MATCH(OK)
+ getBytes=IC JDBC MATCH (INVALID)
+ getDate=22007 JDBC MATCH(OK)
+ getTime=22007 JDBC MATCH(OK)
+ getTimestamp=22007 JDBC MATCH(OK)
+ getAsciiStream=0x33,0x32 was null false JDBC MATCH(OK)
+ getBinaryStream=IC JDBC MATCH (INVALID)
+ getCharacterStream=0x33,0x32 was null false JDBC MATCH(OK)
+ getClob=IC JDBC MATCH (INVALID)
+ getBlob=IC JDBC MATCH (INVALID)
+ getUnicodeStream=ResultSet.getUnicodeStream not present - correct for JSR169
+ getObject=CORRECT :java.lang.String was null false
+setNull() with all JDBC Types on CHAR(60)
+ setNull(Types.TINYINT) getString=null was null true
+ setNull with batching support(Types.TINYINT) getString=null was null true
+ setNull(SMALLINT) getString=null was null true
+ setNull with batching support(SMALLINT) getString=null was null true
+ setNull(INTEGER) getString=null was null true
+ setNull with batching support(INTEGER) getString=null was null true
+ setNull(BIGINT) getString=null was null true
+ setNull with batching support(BIGINT) getString=null was null true
+ setNull(REAL) getString=null was null true
+ setNull with batching support(REAL) getString=null was null true
+ setNull(Types.FLOAT) getString=null was null true
+ setNull with batching support(Types.FLOAT) getString=null was null true
+ setNull(DOUBLE) getString=null was null true
+ setNull with batching support(DOUBLE) getString=null was null true
+ setNull(DECIMAL) getString=null was null true
+ setNull with batching support(DECIMAL) getString=null was null true
+ setNull(Types.NUMERIC) getString=null was null true
+ setNull with batching support(Types.NUMERIC) getString=null was null true
+ setNull(Types.BIT) getString=null was null true
+ setNull with batching support(Types.BIT) getString=null was null true
+ setNull(CHAR) getString=null was null true
+ setNull with batching support(CHAR) getString=null was null true
+ setNull(VARCHAR) getString=null was null true
+ setNull with batching support(VARCHAR) getString=null was null true
+ setNull(LONG VARCHAR) getString=null was null true
+ setNull with batching support(LONG VARCHAR) getString=null was null true
+ setNull(VARCHAR () FOR BIT DATA) IC
+ setNull with batching support(VARCHAR () FOR BIT DATA) IC
+ setNull(DATE) getString=null was null true
+ setNull with batching support(DATE) getString=null was null true
+ setNull(TIME) getString=null was null true
+ setNull with batching support(TIME) getString=null was null true
+ setNull(TIMESTAMP) getString=null was null true
+ setNull with batching support(TIMESTAMP) getString=null was null true
+ setNull(CLOB) IC
+ setNull with batching support(CLOB) IC
+ setNull(BLOB) IC
+ setNull with batching support(BLOB) IC
+ setNull(Types.NULL) IC
+ setNull with batching support(Types.NULL) IC
+ setNull(235350345) IC
+ setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on CHAR(60)
+For setXXX() methods that pass an object, a null and valid values are checked
+ setByte() getString=98 was null false JDBC MATCH(OK)
+ setByte() as batch getString=98 was null false JDBC MATCH(OK)
+ setShort() getString=98 was null false JDBC MATCH(OK)
+ setShort() as batch getString=98 was null false JDBC MATCH(OK)
+ setInt() getString=98 was null false JDBC MATCH(OK)
+ setInt() as batch getString=98 was null false JDBC MATCH(OK)
[... 1732 lines stripped ...]