JNDI Connection

[Tushar Kherde <kh...@gmail.com>]

Hi All,

I am using JNDI, i think iBATIS internally handling all connection pooling
stuff.
I have small doubt, Is iBATIS closing connection? or do I need to close
connection explicitly?.
Because I am getting connection pool exhaust error.

JNDI Error

[Mar 12 13:23:01] ERROR (GenericModuleSecurity.java:169) - JNDI Exception
Cannot get a connection, pool exhausted
[Mar 12 13:23:01] INFO  (GenericModuleSecurity.java:82) -
GenericModuleSecurity
[Mar 12 13:23:01] INFO  (IceAppsGenericPortlet.java:118) -
IceAppsGenericPortlet userId null
[Mar 12 13:23:01] INFO  (GenericModuleSecurity.java:96) - JNDI_RESOURCE_NAME
= jdbc/app_cims
[Mar 12 13:23:11] ERROR (GenericModuleSecurity.java:169) - JNDI Exception
Cannot get a connection, pool exhausted
[Mar 12 13:23:37] INFO  (ApplicationContext.java:646) - Shutting down Log4J


Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a
connection, pool exhausted
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(
PoolingDataSource.java:103)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(
BasicDataSource.java:540)
        at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(
JdbcTransaction.java:48)
        at
com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(
JdbcTransaction.java:89)
        at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList
(GeneralStatement.java:123)
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList
(SqlMapExecutorDelegate.java:610)
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList
(SqlMapExecutorDelegate.java:584)
        at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(
SqlMapSessionImpl.java:101)
        at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(
SqlMapClientImpl.java:78)
        at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(
SqlMapDaoTemplate.java:203)
        ... 197 more



Thanks in Advance



-- 
With regards
Tushar Kherde