Cause: java.sql.SQLException: Closed Connection

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view

Cause: java.sql.SQLException: Closed Connection

I am getting java.sql.SQLException error and don't know where to turn.

Below is the stacktrace:-
Caused by: java.sql.SQLException: Closed Connection
        at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(
        at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
        at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(
        at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(
        at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(
        at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(
        at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(

After researching and asking around a lot...I got feedback that I am getting the error because even after the connection has been closed i am calling the resultset.  However, I am using iBatis + Spring across whole application and dont deal with ResultSet.  

My Sample code is below:

getSqlMapClientTemplate().queryForList("authentication.isUserDAO", parmMap);
List results = (List) parmMap.get("Result0");

I simply call the SP with parameters and get a resultSet back.  I saw a ticket opened in JIRA for iBatis that had similar error, however, I am not using proxyConnection.

Has anyone seen this type of message before ? any ideas/pointers?
Reply | Threaded
Open this post in threaded view

Re: Cause: java.sql.SQLException: Closed Connection

Larry Meadors
The ibatis project has moved and been renamed.

It is no longer being maintained as an Apache project, but has moved
(along with the development team) here:

Please join us at the new location by joining the mailing list here:


To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]