parametermapping.out

derby database source code.good for you.

  setNull with batching support(235350345) getDouble=0.0 was null true
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.4 was null false JDBC MATCH(OK)
  setFloat() as batch getDouble=98.4 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) getDouble=0.0 was null true CLOUD EXT (OK)
  setBytes(null) as batchgetDouble=0.0 was null true CLOUD EXT (OK)
  setDate() IC JDBC MATCH (INVALID)
  setDate() as batch IC JDBC MATCH (INVALID)
  setDate(null) getDouble=0.0 was null true CLOUD EXT (OK)
  setDate(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
  setTime() IC JDBC MATCH (INVALID)
  setTime() as batch IC JDBC MATCH (INVALID)
  setTime(null) getDouble=0.0 was null true CLOUD EXT (OK)
  setTime(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
  setTimestamp() IC JDBC MATCH (INVALID)
  setTimestamp() as batch IC JDBC MATCH (INVALID)
  setTimestamp(null) getDouble=0.0 was null true CLOUD EXT (OK)
  setTimestamp(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
  setAsciiStream() IC JDBC MATCH (INVALID)
  setAsciiStream() as batch IC JDBC MATCH (INVALID)
  setAsciiStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
  setAsciiStream(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
  setBinaryStream() IC JDBC MATCH (INVALID)
  setBinaryStream() as batch IC JDBC MATCH (INVALID)
  setBinaryStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
  setBinaryStream(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
  setCharacterStream() IC JDBC MATCH (INVALID)
  setCharacterStream() as batch IC JDBC MATCH (INVALID)
  setCharacterStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
  setCharacterStream(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
  setClob() IC JDBC MATCH (INVALID)
  setClob() as batch IC JDBC MATCH (INVALID)
  setClob(null) getDouble=0.0 was null true CLOUD EXT (OK)
  setClob(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
  setBlob() IC JDBC MATCH (INVALID)
  setBlob() as batch IC JDBC MATCH (INVALID)
  setBlob(null) getDouble=0.0 was null true CLOUD EXT (OK)
  setBlob(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
  setUnicodeStream() IC JDBC MATCH (INVALID)
  setUnicodeStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
  setObject(null)  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
  setObject(null) as batch  OK Invalid data conversion: Parameter object type is invalid for requested conversion.
  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.3 was null false JDBC MATCH(OK)
  setObject(java.lang.Float) as batch getDouble=76.3 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)
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)
  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=null was null true CLOUD EXT (OK)
  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.00000 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=IC JDBC MATCH (INVALID)
  getObject=CORRECT :java.math.BigDecimal 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) getBigDecimal=null was null true
  setNull(SMALLINT) getBigDecimal=null was null true
  setNull with batching support(SMALLINT) getBigDecimal=null was null true
  setNull(INTEGER) getBigDecimal=null was null true
  setNull with batching support(INTEGER) getBigDecimal=null was null true
  setNull(BIGINT) getBigDecimal=null was null true
  setNull with batching support(BIGINT) getBigDecimal=null was null true
  setNull(REAL) getBigDecimal=null was null true
  setNull with batching support(REAL) getBigDecimal=null was null true
  setNull(Types.FLOAT) getBigDecimal=null was null true
  setNull with batching support(Types.FLOAT) getBigDecimal=null was null true
  setNull(DOUBLE) getBigDecimal=null was null true
  setNull with batching support(DOUBLE) getBigDecimal=null was null true
  setNull(DECIMAL) getBigDecimal=null was null true
  setNull with batching support(DECIMAL) getBigDecimal=null was null true
  setNull(Types.NUMERIC) getBigDecimal=null was null true
  setNull with batching support(Types.NUMERIC) getBigDecimal=null was null true
  setNull(Types.BIT) getBigDecimal=null was null true
  setNull with batching support(Types.BIT) getBigDecimal=null was null true
  setNull(CHAR) getBigDecimal=null was null true
  setNull with batching support(CHAR) getBigDecimal=null was null true
  setNull(VARCHAR) getBigDecimal=null was null true
  setNull with batching support(VARCHAR) getBigDecimal=null was null true
  setNull(LONG VARCHAR) getBigDecimal=null was null true
  setNull with batching support(LONG VARCHAR) getBigDecimal=null was null true
  setNull(VARCHAR () FOR BIT DATA) getBigDecimal=null was null true
  setNull with batching support(VARCHAR () FOR BIT DATA) getBigDecimal=null was null true
  setNull(DATE) getBigDecimal=null was null true
  setNull with batching support(DATE) getBigDecimal=null was null true
  setNull(TIME) getBigDecimal=null was null true
  setNull with batching support(TIME) getBigDecimal=null was null true
  setNull(TIMESTAMP) getBigDecimal=null was null true
  setNull with batching support(TIMESTAMP) getBigDecimal=null was null true
  setNull(CLOB) getBigDecimal=null was null true
  setNull with batching support(CLOB) getBigDecimal=null was null true
  setNull(BLOB) getBigDecimal=null was null true
  setNull with batching support(BLOB) getBigDecimal=null was null true
  setNull(Types.NULL) getBigDecimal=null was null true
  setNull with batching support(Types.NULL) getBigDecimal=null was null true
  setNull(235350345) getBigDecimal=null was null true
  setNull with batching support(235350345) getBigDecimal=null was null true
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 getBigDecimal=98.00000 was null false JDBC MATCH(OK)
  setShort() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
  setShort() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
  setInt() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
  setInt() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
  setLong() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
  setLong() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
  setFloat() getBigDecimal=98.40000 was null false JDBC MATCH(OK)
  setFloat() as batch getBigDecimal=98.40000 was null false JDBC MATCH(OK)
  setDouble() getBigDecimal=98.50000 was null false JDBC MATCH(OK)
  setDouble() as batch getBigDecimal=98.50000 was null false JDBC MATCH(OK)
  setBigDecimal() getBigDecimal=99.00000 was null false JDBC MATCH(OK)
  setBigDecimal() as batch getBigDecimal=99.00000 was null false JDBC MATCH(OK)
  setBigDecimal(null) getBigDecimal=null was null true JDBC MATCH(OK)
  setBigDecimal(null) as batch getBigDecimal=null was null true JDBC MATCH(OK)
  setBoolean() getBigDecimal=1.00000 was null false JDBC MATCH(OK)
  setBoolean() as batch getBigDecimal=1.00000 was null false JDBC MATCH(OK)
  setString() getBigDecimal=97.00000 was null false JDBC MATCH(OK)
  setString() as batch getBigDecimal=97.00000 was null false JDBC MATCH(OK)
  setString(null) getBigDecimal=null was null true JDBC MATCH(OK)
  setString(null) as batch getBigDecimal=null was null true JDBC MATCH(OK)
 setString("Invalid Value")  IC (Expected)
  setBytes() IC JDBC MATCH (INVALID)
  setBytes() as batchIC JDBC MATCH (INVALID)
  setBytes(null) getBigDecimal=null was null true CLOUD EXT (OK)
  setBytes(null) as batchgetBigDecimal=null was null true CLOUD EXT (OK)
  setDate() IC JDBC MATCH (INVALID)
  setDate() as batch IC JDBC MATCH (INVALID)
  setDate(null) getBigDecimal=null was null true CLOUD EXT (OK)
  setDate(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
  setTime() IC JDBC MATCH (INVALID)
  setTime() as batch IC JDBC MATCH (INVALID)
  setTime(null) getBigDecimal=null was null true CLOUD EXT (OK)
  setTime(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
  setTimestamp() IC JDBC MATCH (INVALID)
  setTimestamp() as batch IC JDBC MATCH (INVALID)
  setTimestamp(null) getBigDecimal=null was null true CLOUD EXT (OK)
  setTimestamp(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
  setAsciiStream() IC JDBC MATCH (INVALID)
  setAsciiStream() as batch IC JDBC MATCH (INVALID)
  setAsciiStream(null) getBigDecimal=null was null true CLOUD EXT (OK)
  setAsciiStream(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
  setBinaryStream() IC JDBC MATCH (INVALID)
  setBinaryStream() as batch IC JDBC MATCH (INVALID)
  setBinaryStream(null) getBigDecimal=null was null true CLOUD EXT (OK)
  setBinaryStream(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
  setCharacterStream() IC JDBC MATCH (INVALID)
  setCharacterStream() as batch IC JDBC MATCH (INVALID)
  setCharacterStream(null) getBigDecimal=null was null true CLOUD EXT (OK)
  setCharacterStream(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
  setClob() IC JDBC MATCH (INVALID)
  setClob() as batch IC JDBC MATCH (INVALID)
  setClob(null) getBigDecimal=null was null true CLOUD EXT (OK)
  setClob(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
  setBlob() IC JDBC MATCH (INVALID)
  setBlob() as batch IC JDBC MATCH (INVALID)
  setBlob(null) getBigDecimal=null was null true CLOUD EXT (OK)
  setBlob(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
  setUnicodeStream() IC JDBC MATCH (INVALID)
  setUnicode