No more data to read from socket Options

[brutus.i]

Hi all.
I have an application running in weglodic server with oracle 10g enterprise edition database.
When ever i perform a particular task in a particular page , iam getting an error " No more data to read from socket".
This error is not occuring when i do the same from the backend procedure instead of java calling the procedure.

when i googled "No more data to read from socket" , it says that the db session java makes is getting stale or useless.

This db procedure uses a big object with numberous collection objects inside. When i comment out a particular piece of code ( 15 to 20 lines) where a particular collection object is getting populated , this error is not occuring.

The database server gets restarted every day so as the weglogic server.

If this is a problem with database,
could anybody tell me the diagnosis , this is actaully urgent and its only in production , and develpoment and QA environments are running fine.

[dave]

Hi all.
I have an application running in weglodic server with oracle 10g enterprise edition database.
When ever i perform a particular task in a particular page , iam getting an error " No more data to read from socket".
This error is not occuring when i do the same from the backend procedure instead of java calling the procedure.

when i googled "No more data to read from socket" , it says that the db session java makes is getting stale or useless.

This db procedure uses a big object with numberous collection objects inside. When i comment out a particular piece of code ( 15 to 20 lines) where a particular collection object is getting populated , this error is not occuring.

The database server gets restarted every day so as the weglogic server.

If this is a problem with database,
could anybody tell me the diagnosis , this is actaully urgent and its only in production , and develpoment and QA environments are running fine.

its not a database error, so you need to look at your application

[gwest1972]

I posted this comment along with another thread as well... in part because I couldn't find much help for my problem in the www.

One of my companies reports developer had a similar issue: " No more data to read from socket" and the alert log specifies "Address not mapped to object"... was related specifically to selecting from a view, whose select statement had a column select, which used DISTINCT (using UNIQUE in that select caused the same issue).

Something like:
[View Select]
select column1, column2,
(select distinct mycolumn from tableX where uid = pid)
from tableY

The client side error was "java.sql.SQLRecoverableException: No more data to read from socket". Sql Developer experienced the same error.

Although the restriction of the developer's query guaranteed a single return row, there wasn't a restriction on tableX requiring it to be unique, therefore the potential to return multiple rows (which causes a separate exception) ... so, to ensure a single row return, I also had him add 'and rownum < 2' (or you can use 'and rownum = 1').

The removal of the DISTINCT keyword resolved the issue.

[burleson]

With ORA-03113: No more data to read from socket, there are known bugs, check MOSC.