aspose file tools*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle 10g driver throws java.sql.SQLException: OALL8 is in an inconsistent state Web
 
Similar Threads
Looking for a good design for performance
Oracle 10g driver throws java.sql.SQLException: OALL8 is in an inconsistent state
Oracle 10g JDBC Error
java.sql.SQLException: ORA-00028: your session has been killed
Merge statement for merging data of tables from two different databases