wood burning stoves 2.0*
The moose likes JDBC and the fly likes No more data to read from socket Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "No more data to read from socket" Watch "No more data to read from socket" New topic
Author

No more data to read from socket

Srinivas Rao
Greenhorn

Joined: Aug 05, 2004
Posts: 14
When I am trying to access a Ref cursor in oracle through Java using oracle thin driver, some times we are getting error : No more data to read from socket. This is making that particular connection invalid for further DB operations.

Actually what does it mean by No more data to read from socket. What are all the things will result those error (bad SQL in SP, driver problem or improper java code)?

Please provide reasons of that error and corrective measures
Makarand Parab
Ranch Hand

Joined: Dec 10, 2004
Posts: 121
Hi
I had a same problem when working for project. There can be two reason
1. Either there is a long connectivity time between the application and the database.
2. Most important, please check your n/w connectivity between the application server and the database. This message is thrown when there are n/w problems.

Regards
Makarand Parab
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: No more data to read from socket
 
Similar Threads
java.sql.SQLRecoverableException: No more data to read from socket
java.sql.SQLException
anybody know what this error message mean?
Error establising socket for Weblogic81 to Oracle9i
Not able to connect to db2 from java