Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Anyone knows the reasons of SQLEXCEPTION: CLOSED CONNECTION

442423Apr 20 2005 — edited Apr 20 2005
We are using Oracle JDBC thin driver 8.1.7.1.0 connected to DB version 8.1.7.4. Application server is JRun 4 but implement our own connection pooling. Our application is multithreaded.

Recently, we encountered error message 'JAVA.SQL.SQLEXCEPTION: CLOSED CONNECTION' in our application server, details as below:
Error -- java.sql.SQLException: Closed Connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:274)
at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:880)
at .....db.jdbcPoolMgr.WrappedConn.rollback(WrappedConn.java:144)
at .....db.sqlStore.SqlInstruction.executesqls(SqlInstruction.java:600)
at .....db.sqlStore.SqlInstruction.executeBatch(SqlInstruction.java:718)
at .....db.sqlStore.SqlStore.executeNoCommitRollback(SqlStore.java:274)
at .....db.sqlStore.SqlStore.execute(SqlStore.java:331)

Can anyone help?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2005
Added on Apr 20 2005
1 comment
353 views