Oracle and EOF with Timestamps
Oracle and EOF with Timestamps
- Subject: Oracle and EOF with Timestamps
- From: Andrew Lindesay <email@hidden>
- Date: Mon, 14 Dec 2009 23:23:41 +1300
Hello;
I'm communicating with an Oracle database through an EOF model.
It is working well except that I get this trace logging coming through when timestamp attributes are being SELECT'ed on;
SQLState(65000) vendor code(6502)
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_UTILITY", line 102
ORA-06512: at line 1
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:132)
at oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:185)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:438)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4693)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
at oracle.sql.TRANSDUMP.getTransitions(TRANSDUMP.java:79)
at oracle.sql.TIMEZONETAB.updateTable(TIMEZONETAB.java:548)
at oracle.jdbc.driver.OracleStatement.getDefaultTimeZone(OracleStatement.java:5831)
at oracle.jdbc.driver.DateCommonBinder.setOracleCYMD(OraclePreparedStatement.java:17474)
at oracle.jdbc.driver.TimestampBinder.bind(OraclePreparedStatement.java:17951)
at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:3014)
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:2247)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
at com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:263)
at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337) ...
The fetch still works fine, but this problem is consuming some capacity and I don't know why. It seems to be invoking a stored-procedure to fiddle timezones.
If I create a simple java program to fetch some data, I don't see this.
Has anybody else seen this one?
cheers. |
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden