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
