This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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
Error establising socket for Weblogic81 to Oracle9i
java.sql.SQLException
Not able to connect to db2 from java
anybody know what this error message mean?
java.sql.SQLRecoverableException: No more data to read from socket