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
posted 10 years ago
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.