Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: Closed Connection  RSS feed

 
Shyam Hai
Ranch Hand
Posts: 68
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator




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
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Any code to show us?
 
Paul Clapham
Sheriff
Posts: 22185
38
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!