java.sql.SQLException: Closed Connection

[Bhaarat Sharma]

I was forwared to this list by Larry (thanks).

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

Below is the stacktrace:-
[#|2010-06-01T11:45:14.469-0400|SEVERE|sun-appserver2.1|
javax.enterprise.system.container.web|
_ThreadID=62;_ThreadName=httpSSLWorkerThread-7310-36;_RequestID=7e901857-88d2-4c5f-
a29b-56e6b4689874;|StandardWrapperValve[jsp]: PWC1406:
Servlet.service() for servlet jsp threw exception
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient
operation; uncategorized SQLException for SQL []; SQL state [null];
error code [17008];
--- The error occurred in admin.xml.
--- The error occurred while executing query procedure.
--- Check the {call check_uri (?,?) }.
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Closed Connection; nested exception
is com.ibatis.common.jdbc.exception.NestedSQLException:

Caused by: java.sql.SQLException: Closed Connection
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:
185)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:
123)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:
614)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:
588)
at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:
118)
at org.springframework.orm.ibatis.SqlMapClientTemplate
$3.doInSqlMapClient(SqlMapClientTemplate.java:268)
at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:
193)
at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:
219)
at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:
266)

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. In the first line of
the error, I notice that SQL error code 17008 is coming..which is
ORA-17008 = Closed Connection.

My Sample code is below:

this.setSqlMapClientTemplate(getSqlTempl());
getSqlMapClientTemplate().queryForList("authentication.isUserDAO",
parmMap);
this.setSqlMapClientTemplate(getSqlTemplDW());
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. https://issues.apache.org/jira/browse/IBATIS-539

Has anyone seen this type of message before ? any ideas/pointers?