java.sql.SQLException

[rewati raman]

Hi i have finally changed something in my code and got connectivity with the oracle but still there are some error. i dont know why
here is my code

   
import java.io.*;
import java.sql.*;
import oracle.jdbc.driver.*;

public class data {
  public static void main(String[] args) throws ClassNotFoundException, SQLException{
    
      Connection con=null;
      Class.forName("oracle.jdbc.driver.OracleDriver");
      con=DriverManager.getConnection(
      	      "jdbc:oracle:thin:@localhost:1521:PLSExtProc","rew","happy");
      Statement s=con.createStatement();
      s.execute("select * from account;");
      s.close();
      con.close();

 }
}
 

and the errors are:

 

Exception in thread "main" java.sql.SQLException: No more data to read from socket
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161)
	at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:884)
	at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:993)
	at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:950)
	at oracle.jdbc.driver.T4C8TTIpro.receive(T4C8TTIpro.java:121)
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:725)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:227)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:360)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:150)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595)
	at java.sql.DriverManager.getConnection(DriverManager.java:620)
	at java.sql.DriverManager.getConnection(DriverManager.java:200)
	at data.main(data.java:10)

   

[Tom Reilly]

I Googled

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

How did your search go?

[rewati raman]

i didnt get you

[Christophe Verré]

rewati raman wrote:i didnt get you

Tom is asking you if you searched first ?

[rewati raman]

I tried and i didnt got much.
I have been working on it for more than 4 hrs now.

[rewati raman]

i need help is there anybody who have faced the same problem

[Rob Spoor]

PatienceIsAVirtue. 5 hours, really?

Anyway, with oracle "No more data to read from socket" I find plenty of results.

Moving to our JDBC forum.