java.sql.SQLException: Io exception: Connection reset
606094Oct 31 2007 — edited Dec 12 2007While connection to db from java application I get the following error and I find that the OracleOraHome92TNSListener service stopped altogether before producing the following exception.But I am able to connect to db using sqlplus.Please help
Caused by: java.sql.SQLException: Io exception: Connection reset
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:115)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getNewPoolOrXAConnection(OracleConnectionCacheImpl.java:547)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getPooledConnection(OracleConnectionCacheImpl.java:423)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:259)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:237)
at com.sabre.fltsked.util.DefaultDatabaseConnectionFactory.createConnection(DefaultDatabaseConnectionFactory.java:66)
at com.sabre.fltsked.util.FSDatabaseConnectionCache.getConnectionFromCache(FSDatabaseConnectionCache.java:17)
at com.sabre.fltsked.util.FSDatabaseConnectionFactory.getConnectionForNONEJB(FSDatabaseConnectionFactory.java:108)
... 18 more