aspose file tools*
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
 
wood burning stoves
 
subject: No more data to read from socket