This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes java.sql.SQLException: Closed Connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "java.sql.SQLException: Closed Connection" Watch "java.sql.SQLException: Closed Connection" New topic
Author

java.sql.SQLException: Closed Connection

Shyam Hai
Ranch Hand

Joined: Feb 04, 2009
Posts: 68




I got this Exception.
how can i rectify.please...


java.sql.SQLException: Closed Connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.pool.OraclePooledConnection.getConnection(OraclePooledConnection.java:300)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:302)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCacheImpl.java:268)
at com.dizlee.clistwat.util.ConnectionFactory.getTeleClubConnection(ConnectionFactory.java:166)
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
Any code to show us?
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

You went to get a connection from the connection pool, but you got an exception. So check out these things: is there code which is taking connections but not returning them to the pool? Was the database server restarted, or did the database manager kill some sessions which corresponded to connections in the pool? Do you just not have enough connections in the pool to support the number of users you have now?

As you see, all kinds of things could be wrong.
 
 
subject: java.sql.SQLException: Closed Connection
 
Similar Threads
Exhausted Resultset Exception
Closed Connection
jdbc in Unix
Closed Connection
Statement object