Abgeschickt von Amie Bunchman am 02 Juni, 2006 um 23:08:41
Have been unable to get the sample XML config file to create an entry in Oracle 10.2 db. Trying now the example w/out config file, executing statements in java code. The following line creates a runtime error:
ja.setColumn("the_timestamp", JDBCLogType.TIMESTAMP, "", "TIMESTAMP", Types.TIMESTAMP);
log4j:ERROR JDBCAppender::flush_buffer(), :
java.sql.SQLException: Internal Error: Unable to construct a Datum from the specified input
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)
at oracle.sql.SQLUtil.makeDatum(SQLUtil.java:1100)
at oracle.sql.SQLUtil.makeOracleDatum(SQLUtil.java:1583)
at oracle.jdbc.driver.UpdatableResultSet.updateObject(UpdatableResultSet.java:1615)
at oracle.jdbc.driver.UpdatableResultSet.updateTimestamp(UpdatableResultSet.java:1492)
at oracle.jdbc.driver.OracleResultSet.updateTimestamp(OracleResultSet.java:2881)
I tried submitting SYSDATE for "" null string, but same result.
Has anyone found a work-around?
Amie Bunchman