• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Oracle Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
from stack overflow
http://stackoverflow.com/questions/7839907/no-more-data-to-read-from-socket-error
 
Tapan Prajapati
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Oracle Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic