Just guesses as I am not currently using Oracle...
Check the data type of the relevant column in the JDBC2INFO. It might
have some definition that is causing Oracle to do this and a different
data type (or value type!) might avoid this. Could it be a driver
version / Oracle version mismatch?
Chuck
On Dec 14, 2009, at 2:23 AM, Andrew Lindesay wrote:
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.
___
Andrew Lindesay
www.lindesay.co.nz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
This email sent to ch...@global-village.net
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
