Application Returns Error "java.sql.SQLException Closed Connection" When Using A Datasource. (Doc ID 883326.1)

Last updated on MARCH 28, 2016

Applies to:

JDBC - Version 10.1.0.3 and later
Information in this document applies to any platform.

Symptoms

An application using a datasource to connect to the database returns the following error when trying to access database:

FINER: RMIServer.logError RMIServer acceptNewConnection() exception: java.net.SocketTimeoutException: Accept timed out
09/08/06 16:27:08 FINEST: EJBJoinPointImpl.invoke Invoking method public com.its.tabs.ptf.ugm.cmn.vo.user.UserVO 
com.its.tabs.ptf.ugm.biz.user.ejb.bean.UserEJB.updateUser(com.its.tabs.ptf.ugm.cmn.vo.user.UserVO,com.its.tabs.ptf.ugm.cmn.vo.user.CSUserVO) 
throws com.its.tabs.architecture.cmn.exception.TABSException
09/08/06 16:27:08 java.sql.SQLException: Closed Connection
09/08/06 16:27:08 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
09/08/06 16:27:08 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
09/08/06 16:27:08 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:240)
09/08/06 16:27:08 at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:778)
09/08/06 16:27:08 at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:752)
09/08/06 16:27:08 at oracle.jdbc.OracleConnectionWrapper.createStatement(OracleConnectionWrapper.java:70)
09/08/06 16:27:08 at oracle_jdbc_driver_LogicalConnection_Proxy.createStatement()
09/08/06 16:27:08 at com.its.tabs.ptf.ugm.biz.user.jdbc.bean.CSUserBusiness.getUserInfo(CSUserBusiness.java:392)
09/08/06 16:27:08 at com.its.tabs.ptf.ugm.biz.user.jdbc.bean.CSUserBusiness.editeCSUser(CSUserBusiness.java:196)
09/08/06 16:27:08 at com.its.tabs.ptf.ugm.biz.user.ejb.bean.UserBusiness.updateUser(UserBusiness.java:399)
09/08/06 16:27:08 at com.its.tabs.ptf.ugm.biz.user.ejb.bean.UserEJB.updateUser(UserEJB.java:126)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms