Hi.. I am getting following error in an event of a webpage.
Oracle SQLException: No more data to read from socket
java.sql.SQLException: No more data to read from socket
Its happening for a specific single event in our web application. Can anybody pin point the problem area.. (11g DB)
Thanks in Advance..!! Cheers.!!
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..?
My Oracle version is :-
Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production
can anybody please suggest what would be the comaptible jdbc driver ?
Thanks in advance .!!
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.