pool exhausted

[paolo]

Hi,
I get this error:
com.ibatis.dao.client.DaoException: Failed to execute queryForObject - id
[id] parameterObject 
Cause: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection,
pool exhausted
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a
connection, pool exhausted
at
com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDaoTemplate.java:164)

I don't know exactly when it occurs, I have a web application deployed and
sometimes
I see the error in log.

My configuration is:

  <transactionManager type="JDBC">
        <dataSource type="DBCP">
            <property name="driverClassName" value="${database.driver}"/>
            <property name="url" value="${database.url}"/>
            <property name="username" value="${database.username}"/>
            <property name="password" value="${database.password}"/>
            <property name="maxActive" value="10"/>
            <property name="maxIdle" value="5"/>
            <property name="maxWait" value="60000"/>
            <property name="logAbandoned" value="false"/>
            <property name="removeAbandoned" value="true"/>
            <property name="removeAbandonedTimeout" value="50000"/>
            <property name="Driver.DriverSpecificProperty"
value="SomeValue"/>
        </dataSource>
    </transactionManager>

I have to say that:
 everytime I use startTransaction() method I use endTransaction() in a
finally block.
I don't use openSession or other methods to open a session.
I execute all other queries using queryForObject() or queryForList() Ibatis
methods.
I tried to increase maxActive parameter but I don't know if this solve the
problem.
Any ideas?

Thanks a lot in advance

 
-- 
View this message in context: 
http://www.nabble.com/pool-exhausted-tf3536048.html#a9870107
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.