Oracle JDBC intermittent Connection Issue

Posted by Lipska on Stack Overflow See other posts from Stack Overflow or by Lipska
Published on 2010-02-24T15:38:57Z Indexed on 2010/03/25 10:43 UTC
Read the original article Hit count: 520

Filed under:
|
|

I am experiencing a very strange problem This is a very simple use of JDBC connecting to an Oracle database OS: Ubuntu Java Version: 1.5.0_16-b02 1.6.0_17-b04 Database: Oracle 11g Release 11.1.0.6.0 When I make use of the jar file JODBC14.jar it connects to the database everytime When I make use of the jar file JODBC5.jar it connects some times and other times it throws an error ( shown below) If I recompile with Java 6 and use JODBC6.jar I get the same results as JODBC5.jar

I need specific features in JODB5.jar that are not available in JODBC14.jar

Any ideas

Error

Connecting to oracle java.sql.SQLException: Io exception: Connection reset at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:494) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:490) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:202) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:474) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at TestConnect.main(TestConnect.java:13)

Code

Below is the code I am using import java.io.; import java.sql.; public class TestConnect { public static void main(String[] args) {

try {
   System.out.println("Connecting to oracle"); 
   Connection con=null;
   Class.forName("oracle.jdbc.driver.OracleDriver");
   con=DriverManager.getConnection(
     "jdbc:oracle:thin:@172.16.48.100:1535:sample",
     "JOHN",
     "90009000");
   System.out.println("Connected to oracle"); 
   con.close();
   System.out.println("Goodbye");
} catch(Exception e){e.printStackTrace();}

} }

© Stack Overflow or respective owner

Related posts about java

Related posts about Oracle