File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes  java.sql.SQLRecoverableException: 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 " java.sql.SQLRecoverableException: No more data to read from socket" Watch " java.sql.SQLRecoverableException: No more data to read from socket" New topic
Author

java.sql.SQLRecoverableException: No more data to read from socket

Tapan Prajapati
Greenhorn

Joined: Mar 05, 2010
Posts: 27


m using Windows Vista 32 bit Business version and installed softwares : jdk 1.6, Oracle 11.0.1.0
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

thanks for using code, tags, and including the exception, but I don't think the line numbers in the exception match those in the code sample (as I have never seen a finally statement throw an sql exception before )

As a few lines could have thrown the exception, could you adjust the code samplt to accuratly match the real code. or make the real code match the sample
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

Have you done any reseach into this issue, other than posting here, as I found a few intersting issues, involving db setup with certain oracle version, reporting this error.
Tapan Prajapati
Greenhorn

Joined: Mar 05, 2010
Posts: 27
Wendy Gibbons wrote:Have you done any research into this issue, other than posting here, as I found a few interesting issues, involving db setup with certain oracle version, reporting this error.



Ya i tried to find out , and one more thing i want to tell you , i unable to installed my oracle 11.1.0.1 in my computer so i installed it manually, but sq l is working.. nicely as well as oracle jdbc.odbc driver are also working nicely but problem with this only when i start to use oracle thin driver ... so i got this exception any idea ? then reply me soon....

Thanks...
Koen Aerts
Ranch Hand

Joined: Feb 07, 2012
Posts: 344

Did you look in the DBMS log file and see if there's any indication as to why the connection fails?
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

from stack overflow
http://stackoverflow.com/questions/7839907/no-more-data-to-read-from-socket-error
Tapan Prajapati
Greenhorn

Joined: Mar 05, 2010
Posts: 27
Koen Aerts wrote:Did you look in the DBMS log file and see if there's any indication as to why the connection fails?


Where will be located this file?
Koen Aerts
Ranch Hand

Joined: Feb 07, 2012
Posts: 344

Tapan Prajapati wrote:
Koen Aerts wrote:Did you look in the DBMS log file and see if there's any indication as to why the connection fails?

Where will be located this file?

If you're using a listener, then it's probably in listener.log in the $ORACLE_HOME/diag and/or $ORACLE_HOME/network/log directories, otherwise do a search for either alert.log or log.xml file. Since Oracle 11 there's also several new V$ views available to look at log data. Google for Oracle 11g ADR to find various log directories.
Tapan Prajapati
Greenhorn

Joined: Mar 05, 2010
Posts: 27
hi,
Here my alert.log file. i unable to understand if you then tell me how can i correct it? i attached the portion from alert file after my compilation time.



Tapan Prajapati
Greenhorn

Joined: Mar 05, 2010
Posts: 27



i seen this parameter java.lang.“_optim_peek_user_binds”=false but where i have to apply,? they also did not mention any location.
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

Do you need to use oracle?
if you are only trying to practice jdbc or writing applications for your own use MySQL is a much friendlier database to start with. A
s you had trouble doing the install of oracle it is not going to be an easy DB to maintain.

so my end advice is unless you are using oracle as work demands it SWAP NOW.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLRecoverableException: No more data to read from socket