Message: ORA-12570: TNS:packet reader failure
Hi,
when i execute the below program,getting "Message: ORA-12570: TNS:packet reader failure" error. java version is 1.3.1 and oracle
version is :9.1.
able to connect to database using sql plus with the same user-id and
password.
Any help in this regard is appreciated.
Thanks
Chat
import java.sql.*;
import java.io.*;
import java.util.Date;
class JdbcTest
{
publicstaticvoid main (String args [])
{
System.out.println ("Loading Oracle driver");
try
{
Class.forName ("oracle.jdbc.OracleDriver");
System.out.println ("Connecting to the local database");
Connection conn =
DriverManager.getConnection("jdbc:oracle:oci8:@orcl,scott,tiger");
System.out.println("debug 1 ....\n");
Statement stmt = conn.createStatement ();
System.out.println("debug 2 ....\n");
// Query the employee names
ResultSet rset = stmt.executeQuery ("select ename from emp");
while (rset.next ())
{
// Print the name out
System.out.println (rset.getString (1));
}
}catch (ClassNotFoundException cnfe){
System.out.println ("Could not load the driver");
cnfe.printStackTrace ();
}catch (SQLException sqle){
System.out.println("State : " + sqle.getSQLState() ) ;
System.out.println("Message: " + sqle.getMessage()) ;
System.out.println("Error : " + sqle.getErrorCode() ) ;
}catch (Exception e){
System.out.println ("Could not load the driver");
e.printStackTrace ();
}
}
}
C:\mjava>java JdbcTest
Loading Oracle driver
Connecting to the local database
State : 66000
Message: ORA-12570: TNS:packet reader failure
Error : 12570
C:\mjava>
