• 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 driver...
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Oracle driver...


  • Subject: Re: Oracle driver...
  • From: Chuck Hill <email@hidden>
  • Date: Wed, 20 May 2009 10:58:21 -0700

Hi Sherry,

This is controlled by log4j. If you are using log4j in your app, just add it to your configuration there. If you are not, try adding this to the Properties file in your app:

log4j.logger.er.extensions.eof.ERXEntityClassDescription=DEBUG


Chuck



On May 20, 2009, at 5:28 AM, Sherry Tirko wrote:


Hi Chuck,

Thanks for the information. Can you tell me how I would turn on debug level logging for the class? Or do you mean turn it on for the application that I'm getting this error from?

Sherry

On May 19, 2009, at 3:49 PM, Chuck Hill wrote:


On May 19, 2009, at 5:45 AM, Sherry Tirko wrote:


Here is one of the errors that we are getting...

Failed to change product flagsupdateValuesInRowDescribedByQualifier -- com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in database

That can have a few causes. Violating EOF commandments (http://wiki.objectstyle.org/confluence/display/WO/EOF-Using+EOF-The+EOF+Commandments ) can cause this. This can also be caused by using Java data types that don't match the Oracle datatypes correctly, or by using Oracle data types that don't have any exact match in Java. I don't know if Oracle has any of these, but MS SQL Server does. Dates/times are particularly suspect. Scale and precision differences can also cause this. If you log out the SQL you should be able to examine the WHERE clause and find the part(s) that did not match.




Here is the stack trace of another error we are getting, but I'm not sure it's related...

java.lang.ClassCastException: com.webobjects.eoaccess.EOAttribute
at er .extensions .ERXValidationFactory.convertException(ERXValidationFactory.java: 275)
at er .extensions .ERXEntityClassDescription .validateValueForKey(ERXEntityClassDescription.java:606)

That is a validation failure, but then it goes wrong. You are using an older version of Wonder so I can't tell exactly where. This might be a bug in Wonder that was fixed later. If you turn on Debug level logging for ERXEntityClassDescription you should at least be able to see the original validation failure.



Chuck



at com .webobjects .eocontrol.EOCustomObject.validateValueForKey(EOCustomObject.java: 1311)
at com.webobjects.foundation.NSValidation $Utility.validateValueForKey(NSValidation.java:478)
at com.webobjects.foundation.NSValidation $ DefaultImplementation .validateTakeValueForKeyPath(NSValidation.java:675)
at com .webobjects .eocontrol .EOCustomObject.validateTakeValueForKeyPath(EOCustomObject.java: 1335)
at com.webobjects.foundation.NSValidation $Utility.validateTakeValueForKeyPath(NSValidation.java:502)
at com.webobjects.foundation.NSValidation $ DefaultImplementation .validateTakeValueForKeyPath(NSValidation.java:687)
at com .webobjects .eocontrol .EOCustomObject.validateTakeValueForKeyPath(EOCustomObject.java: 1335)
at com.webobjects.foundation.NSValidation $Utility.validateTakeValueForKeyPath(NSValidation.java:502)
at com.webobjects.foundation.NSValidation $ DefaultImplementation .validateTakeValueForKeyPath(NSValidation.java:687)
at com .webobjects .appserver .WOComponent.validateTakeValueForKeyPath(WOComponent.java:1424)
at com .webobjects .appserver ._private .WOKeyValueAssociation.setValue(WOKeyValueAssociation.java:76)
at com .webobjects .appserver ._private.WOTextField.takeValuesFromRequest(WOTextField.java:94)
at com .webobjects .appserver ._private .WODynamicGroup.takeChildrenValuesFromRequest(WODynamicGroup.java: 84)
at com .webobjects .appserver ._private.WODynamicGroup.takeValuesFromRequest(WODynamicGroup.java: 93)
at com .webobjects .appserver ._private.WOConditional.takeValuesFromRequest(WOConditional.java:79)
at com .webobjects .appserver ._private .WODynamicGroup.takeChildrenValuesFromRequest(WODynamicGroup.java: 84)
at com .webobjects .appserver ._private.WODynamicGroup.takeValuesFromRequest(WODynamicGroup.java: 93)
at com .webobjects .appserver.WOComponent.takeValuesFromRequest(WOComponent.java:1051)
at com .webobjects .appserver ._private .WOComponentReference .takeValuesFromRequest(WOComponentReference.java:119)
at com .webobjects .appserver ._private .WODynamicGroup.takeChildrenValuesFromRequest(WODynamicGroup.java: 84)
at com .webobjects .appserver ._private.WODynamicGroup.takeValuesFromRequest(WODynamicGroup.java: 93)
at com .webobjects .appserver.WOComponent.takeValuesFromRequest(WOComponent.java:1051)
at com .webobjects .appserver ._private .WOComponentReference .takeValuesFromRequest(WOComponentReference.java:119)
at com .webobjects .appserver ._private .WODynamicGroup.takeChildrenValuesFromRequest(WODynamicGroup.java: 84)
at com .webobjects .appserver ._private.WODynamicGroup.takeValuesFromRequest(WODynamicGroup.java: 93)
at com .webobjects .appserver ._private.WOConditional.takeValuesFromRequest(WOConditional.java:79)
at com .webobjects .appserver ._private .WODynamicGroup.takeChildrenValuesFromRequest(WODynamicGroup.java: 84)
at com .webobjects .appserver ._private.WODynamicGroup.takeValuesFromRequest(WODynamicGroup.java: 93)
at com .webobjects .appserver._private.WOForm.takeValuesFromRequest(WOForm.java:122)
at com .webobjects .appserver ._private .WODynamicGroup.takeChildrenValuesFromRequest(WODynamicGroup.java: 84)
at com .webobjects .appserver ._private.WODynamicGroup.takeValuesFromRequest(WODynamicGroup.java: 93)
at com .webobjects .appserver ._private .WOComponentContent.takeValuesFromRequest(WOComponentContent.java: 26)
at com .webobjects .appserver ._private .WODynamicGroup.takeChildrenValuesFromRequest(WODynamicGroup.java: 84)
at com .webobjects .appserver ._private.WODynamicGroup.takeValuesFromRequest(WODynamicGroup.java: 93)
at com .webobjects .appserver.WOComponent.takeValuesFromRequest(WOComponent.java:1051)
at com .webobjects .appserver ._private .WOComponentReference .takeValuesFromRequest(WOComponentReference.java:119)
at com .webobjects .appserver ._private .WODynamicGroup.takeChildrenValuesFromRequest(WODynamicGroup.java: 84)
at com .webobjects .appserver ._private.WODynamicGroup.takeValuesFromRequest(WODynamicGroup.java: 93)
at com .webobjects .appserver.WOComponent.takeValuesFromRequest(WOComponent.java:1051)
at com .webobjects .appserver.WOSession.takeValuesFromRequest(WOSession.java:1331)
at com .webobjects .appserver.WOApplication.takeValuesFromRequest(WOApplication.java: 1724)
at com .webobjects .appserver ._private .WOComponentRequestHandler ._dispatchWithPreparedPage(WOComponentRequestHandler.java:199)
at com .webobjects .appserver ._private .WOComponentRequestHandler ._dispatchWithPreparedSession(WOComponentRequestHandler.java:298)
at com .webobjects .appserver ._private .WOComponentRequestHandler ._dispatchWithPreparedApplication(WOComponentRequestHandler.java: 332)
at com .webobjects .appserver ._private .WOComponentRequestHandler ._handleRequest(WOComponentRequestHandler.java:369)
at com .webobjects .appserver ._private .WOComponentRequestHandler .handleRequest(WOComponentRequestHandler.java:442)
at com .webobjects .appserver.WOApplication.dispatchRequest(WOApplication.java:1687)
at com .webobjects .appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:144)
at com .webobjects .appserver._private.WOWorkerThread.run(WOWorkerThread.java:226)
at java.lang.Thread.run(Thread.java:613)



On May 18, 2009, at 5:54 AM, Brook, James wrote:

We recently upgraded to ojdbc5.jar for 11i, we are still running 9i on the
server. The upgrade was to workaround an error that the old drivers were
causing when binding to varchars with multi-byte characters.


Since then we have occasionally been experiencing errors like these two:

OALL8 is in an inconsistent stateat
oracle .jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java: 70)
at oracle .jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at
oracle .jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java: 197)
at
oracle .jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java: 261)
at
oracle .jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java: 269)
at
oracle .jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java: 490)
at oracle.jdbc.driver.T4C8Oall.marshal(T4C8Oall.java:474) at



at java.lang.Thread.run(Thread.java:595) Caused by: Protocol violationat
oracle .jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java: 70)
at


Now we are rushing an upgrade of the server to 11i :-/

--
James

On 16/05/2009 06:41, "Don Lindsay" <email@hidden> wrote:

The Oracle 9i drivers are no longer supported or patched. Oracle
Support advises everyone to use the latest drivers, they are 100%
backwards compatible (wry smile). For Java 1.5 use the OJDBC5.jar
from 11i. For Java 1.6 use OJDBC6.jar. For java 1.4 use OJDBC14.jar,
for java earlier than 1.4 use classes12.jar.


Could you post the errors you are encountering so we can take a look
at them?


Don

On May 14, 2009, at 11:58 AM, Pascal Robert wrote:

For Oracle 9i, might be better to use one of the JDBC drivers that
match Oracle DB server version :


http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc9201
.html



If it helps we use WO 5.4.3 and ORACLE 10.2.0.4.0 with the
ojdbc14.jar driver that goes with that ...  I got it from here:

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10
201.html


On May 14, 2009, at 11:45 AM, Sherry Tirko wrote:


Hello All,

We just recently switched from WO 5.2.4 with Java 1.4 to WO 5.4.2
with Java 1.5. We are using Oracle 9i. With are previous setup
with used the classes12.jar for our jdbc connection. We were told
to use the ojdbc14.jar with our new setup. We were seeing some
jdbc adaptor errors before switching to the new driver. We are now
seeing more adaptor errors. Could we have corrupted something by
using the old driver or do we have the wrong driver now? Any
insight would be greatly appreciated.


Thanks,
Sherry


Sherry Tirko SOAR Project Outreach Technology Services 814-865-9068 email@hidden



_______________________________________________
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

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects- email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden


-------------------------------------------------------
Pascal Robert

http://www.macti.ca
http://www.aircourriel.com
http://www.linkedin.com/in/macti

Skype: MacTICanada
AIM/iChat : MacTICanada

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
@mac.com

This email sent to email@hidden

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription:

>
m

This email sent to email@hidden

_______________________________________________ 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

_______________________________________________ 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

Come to WOWODC'09 in San Fran this June!
http://www.wocommunity.org/wowodc09/




-- Chuck Hill Senior Consultant / VP Development

Come to WOWODC'09 in San Fran this June!
http://www.wocommunity.org/wowodc09/

_______________________________________________
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: 
 >Re: Oracle driver... (From: "Brook, James" <email@hidden>)
 >Re: Oracle driver... (From: Sherry Tirko <email@hidden>)
 >Re: Oracle driver... (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: Question on fetching theory
  • Next by Date: JavaFSAdaptor and non-working EO methods
  • Previous by thread: Re: Oracle driver...
  • Next by thread: WOHyperlink toString()?
  • Index(es):
    • Date
    • Thread