This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes java.sql.SQLException: No more data to read from socket Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: No more data to read from socket" Watch "java.sql.SQLException: No more data to read from socket" New topic
Author

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

rajkiran vadla
Greenhorn

Joined: Nov 26, 2011
Posts: 11
Hi,

I am getting exception from the following code

exception:java.sql.SQLException: No more data to read from socket
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19654
    
  18

Please UseCodeTags next time. It makes your code blocks easier to read.

What line does this SQL exception occur at? The stack trace will show you the file name and line number.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
rajkiran vadla
Greenhorn

Joined: Nov 26, 2011
Posts: 11
Hi, thank you for your replay.

The exception is at line no 2.At DriverManager.getConnection
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19654
    
  18

Are the Oracle server and JDBC driver compatible? I've seen one of the programs at work fail with a later JDBC driver where it worked just fine with an old driver, probably because our Oracle server is ancient (and no, we can't upgrade it; it's part of a third party solution).
rajkiran vadla
Greenhorn

Joined: Nov 26, 2011
Posts: 11


Hi,Thank you for your repaly.
I made a mistake that i have choosen wrong SID .I have verifed it with tnsnames.ora file in ORACLE.I have modefied the SID It worked.


Thanks
Rajkiran
 
 
subject: java.sql.SQLException: No more data to read from socket
 
Similar Threads
java.sql.SQLRecoverableException: No more data to read from socket
Data Abstract Class & MVC
jdbc connection for oracle 10g with JDK 1.6
JDBC doesn't retrieve all the results available in the MSSQL database
Need Code Review