parametermapping.out

derby database source code.good for you.

  setObject(java.sql.Date) IC JDBC MATCH (INVALID)
  setObject(java.sql.Date) as batch  (?????):Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'SMALLINT'. JDBC MATCH (INVALID)
  setObject(java.sql.Time) IC JDBC MATCH (INVALID)
  setObject(java.sql.Time) as batch  (?????):Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Time' into a data value of type 'SMALLINT'. JDBC MATCH (INVALID)
  setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
  setObject(java.sql.Timestamp) as batch  (?????):Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'SMALLINT'. JDBC MATCH (INVALID)
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)
  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 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=IC JDBC MATCH (INVALID)
  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) getInt=0 was null true
  setNull with batching support(VARCHAR () FOR BIT DATA) getInt=0 was null true
  setNull(DATE) getInt=0 was null true
  setNull with batching support(DATE) getInt=0 was null true
  setNull(TIME) getInt=0 was null true
  setNull with batching support(TIME) getInt=0 was null true
  setNull(TIMESTAMP) getInt=0 was null true
  setNull with batching support(TIMESTAMP) getInt=0 was null true
  setNull(CLOB) getInt=0 was null true
  setNull with batching support(CLOB) getInt=0 was null true
  setNull(BLOB) getInt=0 was null true
  setNull with batching support(BLOB) getInt=0 was null true
  setNull(Types.NULL) getInt=0 was null true
  setNull with batching support(Types.NULL) getInt=0 was null true
  setNull(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
  setNull with batching support(235350345) SQLSTATE(null): org.apache.derby.client.am.SqlException: unrecognized sql type
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)
  setBigDecimal() getInt=99 was null false JDBC MATCH(OK)
  setBigDecimal() as batch getInt=99 was null false JDBC MATCH(OK)
  setBigDecimal(null) getInt=0 was null true JDBC MATCH(OK)
  setBigDecimal(null) as batch getInt=0 was null true 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 batch (?????):Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'byte[]' into a data value of type 'INTEGER'. JDBC MATCH (INVALID)
  setBytes(null) getInt=0 was null true CLOUD EXT (OK)
  setBytes(null) as batchgetInt=0 was null true CLOUD EXT (OK)
  setDate() IC JDBC MATCH (INVALID)
  setDate() as batch  (?????):Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'INTEGER'. JDBC MATCH (INVALID)
  setDate(null) getInt=0 was null true CLOUD EXT (OK)
  setDate(null) as batch getInt=0 was null true CLOUD EXT (OK)
  setTime() IC JDBC MATCH (INVALID)
  setTime() as batch  (?????):Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Time' into a data value of type 'INTEGER'. JDBC MATCH (INVALID)
  setTime(null) getInt=0 was null true CLOUD EXT (OK)
  setTime(null) as batch getInt=0 was null true CLOUD EXT (OK)
  setTimestamp() IC JDBC MATCH (INVALID)
  setTimestamp() as batch  (?????):Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'INTEGER'. JDBC MATCH (INVALID)
  setTimestamp(null) getInt=0 was null true CLOUD EXT (OK)
  setTimestamp(null) as batch getInt=0 was null true CLOUD EXT (OK)
  setAsciiStream()  (22018):Invalid character string format for type INTEGER. JDBC MATCH (INVALID)
  setAsciiStream() as batch  (?????):Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (22018):Error for batch element #0: Invalid character string format for type INTEGER. JDBC MATCH (INVALID)
  setAsciiStream(null) getInt=0 was null true CLOUD EXT (OK)
  setAsciiStream(null) as batch getInt=0 was null true CLOUD EXT (OK)
  setBinaryStream() IC JDBC MATCH (INVALID)
  setBinaryStream() as batch  (?????):Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'byte[]' into a data value of type 'INTEGER'. JDBC MATCH (INVALID)
  setBinaryStream(null) getInt=0 was null true CLOUD EXT (OK)
  setBinaryStream(null) as batch getInt=0 was null true CLOUD EXT (OK)
  setCharacterStream() getInt=89 was null false CLOUD EXT (OK)
  setCharacterStream() as batch getInt=89 was null false CLOUD EXT (OK)
  setCharacterStream(null) getInt=0 was null true CLOUD EXT (OK)
  setCharacterStream(null) as batch getInt=0 was null true CLOUD EXT (OK)
  setClob() getInt=72 was null false CLOUD EXT (OK)
  setClob() as batch getInt=72 was null false CLOUD EXT (OK)
  setClob(null) getInt=0 was null true CLOUD EXT (OK)
  setClob(null) as batch getInt=0 was null true CLOUD EXT (OK)
  setBlob() IC JDBC MATCH (INVALID)
  setBlob() as batch  (?????):Non-atomic batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'byte[]' into a data value of type 'INTEGER'. JDBC MATCH (INVALID)
  setBlob(null) getInt=0 was null true CLOUD EXT (OK)
  setBlob(null) as batch getInt=0 was null true CLOUD EXT (OK)
  setUnicodeStream()  (22018):Invalid character string format for type INTEGER. JDBC MATCH (INVALID)
  setUnicodeStream(null) getInt=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) getInt=46 was null false JDBC MATCH(OK)
  setObject(java.lang.String) as batch getInt=46 was null false JDBC MATCH(OK)
  setObject(java.math.BigDecimal) getInt=72 was null false JDBC MATCH(OK)
  setObject(java.math.BigDecimal) as batch getInt=72 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)