This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Oracle 10g driver throws java.sql.SQLException: OALL8 is in an inconsistent state Web Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle 10g driver throws java.sql.SQLException: OALL8 is in an inconsistent state Web" Watch "Oracle 10g driver throws java.sql.SQLException: OALL8 is in an inconsistent state Web" New topic
Author

Oracle 10g driver throws java.sql.SQLException: OALL8 is in an inconsistent state Web

Vineet Solabannavar
Greenhorn

Joined: Aug 27, 2005
Posts: 14
Hi,

I am using Oracle 10g with WebLogic 8.1 SP3 connection pooling.
I am getting the below error.


Oracle 10g driver throws java.sql.SQLException: OALL8 is in an inconsistent state.

Please suggest a fix.
Rashid Darvesh
Ranch Hand

Joined: Feb 13, 2004
Posts: 189
We have the same problem, we were using oracle 9i and everyting was ok until we move to oracle 10 g. any help!!!
Reid M. Pinchback
Ranch Hand

Joined: Jan 25, 2002
Posts: 775
http://www.orindasoft.com/public/PL-SQL%20Recordstwo.php4


Reid - SCJP2 (April 2002)
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
Try the 10.2.0.1 version of ojdbc14.jar, the driver for Java 1.3 and 1.4

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

It is supposed to be cross-compatible with older versions of the database.
Rashid Darvesh
Ranch Hand

Joined: Feb 13, 2004
Posts: 189
i downloaded the latest Oracle Database 10g Release 2 (10.2.0.1.0) JDBC Drivers (ojdbc14.jar) but still i get the error. is there some problem with the weblogic server since i updated the library in my code and the database is 10g, but looks like there needs to be something done in
weblogic to check the connection pool which i am using to create the data source. it gives me the following message.
<Feb 7, 2006 12:09:46 PM PST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "CHARGER" failed with exception: "java.sql.SQLException: OA
LL8 is in an inconsistent state.".>

Any ideas,
Rashid
Alan Alan
Greenhorn

Joined: Feb 15, 2006
Posts: 1
can you tell me what you have set your "cursor_sharing" system parameter to ?
Roger Bly
Greenhorn

Joined: Feb 20, 2006
Posts: 1
In general, these OALL8 errors simply indicate a mismatch between the oracle driver, the oracle database version and the JDK version. Assuming you are running Weblogic on the Java 1.4 Sun JVM supplied by the BEA Weblogic installation, you should update the Oracle driver to match the database you are using. Give this a try:

Rename the file BEA_HOME/weblogic81/server/lib/ojdbc14.jar to ojdbc14.jar.old

If you are using Oracle 9.2:
Copy BEA_HOME/weblogic81/server/ext/jdbc/oracle/920/ojdbc14.jar to BEA_HOME/weblogic81/server/lib

If you are using Oracle 10g:
Copy BEA_HOME/weblogic81/server/ext/jdbc/oracle/10g/ojdbc14.jar to BEA_HOME/weblogic81/server/lib

Restart the Weblogic server.

If the problem still persists, you may want to download the latest Oracle 10.2 ojdbc14.jar driver jar from Oracle at: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html

This has fixed the problem every time we have seen it at customer sites.


Roger Bly<br />www.project.net<br />Open Source Project Management SW
Wim Folkerts
Greenhorn

Joined: Mar 10, 2010
Posts: 19

I've just solved this issue thanks to another post...

This problem is a result of 'stale' connections that generates an error when the application tries to retrieve an invalid connection from the pool. You can simply solve this by change the resource setup in your context.xml:


Don't forget to specify a valid validation query.
 
wood burning stoves
 
subject: Oracle 10g driver throws java.sql.SQLException: OALL8 is in an inconsistent state Web
 
Similar Threads
java.sql.SQLException: ORA-00028: your session has been killed
Looking for a good design for performance
Merge statement for merging data of tables from two different databases
Oracle 10g JDBC Error
Oracle 10g driver throws java.sql.SQLException: OALL8 is in an inconsistent state