Re: Oracle driver...
Re: Oracle driver...
- Subject: Re: Oracle driver...
- From: Chuck Hill <email@hidden>
- Date: Tue, 19 May 2009 12:49:20 -0700
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 (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/
_______________________________________________
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