• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Oracle and EOF with Timestamps
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Oracle and EOF with Timestamps


  • Subject: Re: Oracle and EOF with Timestamps
  • From: Chuck Hill <email@hidden>
  • Date: Mon, 14 Dec 2009 12:18:56 -0800

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      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden

-- 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      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


References: 
 >Oracle and EOF with Timestamps (From: Andrew Lindesay <email@hidden>)

  • Prev by Date: Re: Interesting
  • Next by Date: Re: Building for deployment
  • Previous by thread: Oracle and EOF with Timestamps
  • Next by thread: Re: Oracle and EOF with Timestamps
  • Index(es):
    • Date
    • Thread