This content has been marked as final. Show 21 replies
One more condition I would like to add that.. the entire appln is running fine. only a particular event of a specific page is giving above mentioned error. Please help.
The version of the Oracle JDBC driver you're using is very old... I would update that to the latest1 person found this helpful
appropriate one for your DBMS version.
Thanks for the clue.. !! We are using 11g database. Any idea tht which will be compatible for this? & one more question.. With that version all other Frontend forms are working great..!! only this form is having mentioned error? Then why all other forms are not giving same error..?
Just download the latest. It'll be perfect for an 11g DBMS. I have no idea about
anything else, and we're not sure the driver (or driver/DBMS compatibility) is the
Thnaks alot Joe !
I will let you know.
Hi All/ Joe
with respect to the above mentoned issue, we are using JDBC driver of 10.2.0.2.0 version. Its 11g standalone DB.
Is it the issue. then what will be the required version of JDBC ?
My Oracle version is :-
Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production
can anybody please suggest what would be the comaptible jdbc driver ?
Thanks in advance .!!
Just go to the driver download page. Just download the latest driver. 11.X will be fine.
We changed the version & updated the jdbc driver.. We really need some help to catch the error location!! but still problem remains same. Any other hint about this error..??
Thanks in advance..!!
Note: In the application log we are getting the below mentioned error:-- Any help will be welcome
<Jan 20, 2012 3:19:41 PM CET> <Error> <JDBC> <BEA-001112> <Test "select count(*) from Mod_gach_r" set up for pool "SciApp1" failed with exception: "java.sql.SQLException: OALL8 is in an inconsistent state".>
The error is happening somewhere in your code but you didn't post any of your code for us to see what it is doing.
Post your code that is giving the error and information about the event that is triggering the exception.
You apparently have code that is using a DML query of some sort
Ok , As u said I will get the code ASAP. Just to explain that situation.. the event is calling a Stored procedure which is having only select queries & via out parameter a value is being sent out to front end.
From the Weblogic server log, today I came to know that, the event is working fine when its dealing with small set of data. But whenver we are giving it large dataset fetching condition , its throwing error..!!!
Can you give me some clue on that.. is that because of smaller range of array..?
thnx in advance..
You should narrow down the problem, and ideally you should be able to duplicate
it in a small standalone program with no weblogic in the picture. This may be a
new driver bug, but at first blush, it sounds like a DBMS problem, so you need
a small duplicator to get progress with Oracle support. Have your DBA check
the DBMS error log to see if there is any hint of problems there, when you
have this happen to you.
Thanks Joe.. ok will try as u said. Yes we were in touch wuth Oracle support. they told us it may be only jdbc driver issue.
We did the same as they prescribed. but no change in the error.