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.".>
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
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.
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop