Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Tapan Prajapati
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


m using Windows Vista 32 bit Business version and installed softwares : jdk 1.6, Oracle 11.0.1.0
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 344
Java Linux Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Did you look in the DBMS log file and see if there's any indication as to why the connection fails?
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
 
Tapan Prajapati
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 344
Java Linux Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator



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
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic