Closed Connection ERROR

Ask around here!

Closed Connection ERROR

Postby Dharma » Thu Mar 08, 2012 9:32 am

Hi,

i am often getting, java.sql.SQLException: Closed Connection.
i have enabled the CloseConnectionWatch feature to find out connection leak in my application.
Here is the complete stack trace

java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)
at oracle.jdbc.driver.PhysicalConnection.setAutoCommit(PhysicalConnection.java:3229)
at com.jolbox.bonecp.ConnectionHandle.setAutoCommit(ConnectionHandle.java:1316)
at com.report.utilities.ConnectionPool.getConnection(ConnectionPool.java:216)

Here is my connection pool utility code to obtain connection from BoneCp

public Connection getConnection(boolean autoCommit)
{
Connection connection = connectionPool.getConnection();
connection.setAutoCommit(autoCommit)
return connection;
}
Dharma
 
Posts: 2
Joined: Wed Mar 07, 2012 10:53 am

Return to BoneCP - Help, Q&A, Whatever!

Who is online

Users browsing this forum: No registered users and 0 guests