Re: Oracle driver...
Re: Oracle driver...
- Subject: Re: Oracle driver...
- From: Sherry Tirko <email@hidden>
- Date: Tue, 19 May 2009 08:45:48 -0400
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
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)
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