parametermapping.out

derby database source code.good for you.

  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)
  setBigDecimal() getDouble=99.0 was null false JDBC MATCH(OK)
  setBigDecimal() as batch getDouble=99.0 was null false JDBC MATCH(OK)
  setBigDecimal(null) getDouble=0.0 was null true JDBC MATCH(OK)
  setBigDecimal(null) as batch getDouble=0.0 was null true 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()  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
  setUnicodeStream(null)  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
  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.math.BigDecimal) getDouble=72.0 was null false JDBC MATCH(OK)
  setObject(java.math.BigDecimal) as batch getDouble=72.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.ProcedureTest.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)
  getBigDecimal=null 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= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
  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)
  getBigDecimal=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= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
  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
  s