• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Knute Snortum
  • Paul Clapham
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Frits Walraven
Bartenders:
  • Ganesh Patekar
  • Tim Holloway
  • salvin francis

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

 
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
 
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 L 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...
 
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 L 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

Wendy Gibbons wrote:from stack overflow
http://stackoverflow.com/questions/7839907/no-more-data-to-read-from-socket-error




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 L 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
Boost this thread!