QUOTE (brutus.i @ May 26 2009, 05:43 AM)
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