Re: Oracle driver...
Re: Oracle driver...
- Subject: Re: Oracle driver...
- From: "Brook, James" <email@hidden>
- Date: Mon, 18 May 2009 11:54:40 +0200
- Thread-topic: Oracle driver...
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