Java Mailing List Archive

Home » user-java.ibatis »

Cause: java.sql.SQLException: Closed Connection

bhaarat Sharma


Replies: Find Java Web Hosting

Author LoginPost Reply

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
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback (
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList (
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList (
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList (
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList (
org.springframework.orm.ibatis.SqlMapClientTemplate.execute (
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult (
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?

Sent from the iBATIS - User - Java mailing list archive at

To unsubscribe, e-mail: user-java-unsubscribe@(protected)
For additional commands, e-mail: user-java-help@(protected)

©2008 - Jax Systems, LLC, U.S.A.