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 protected]> 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 protected]



_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/rparada%40mac.com

This email sent to [email protected]

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca

This email sent to [email protected]


-------------------------------------------------------
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/pccdonl
%40mac.com

This email sent to [email protected]

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

http://lists.apple.com/mailman/options/webobjects-dev/jbrook%40upcbroadband.co >
m

This email sent to [email protected]

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/slk24%40outreach.psu.edu

This email sent to [email protected]

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to