Hi, i am having problem with connections, i am getting this log
---beging log--
java.sql.SQLException: Timed out waiting for an available connection after 30
seconds (connection pool reached max-connections which was set to 10)
at
com.evermind.sql.OrionPooledDataSource.waitForConnection(OrionPooledDataSource.java:846)
at
com.evermind.sql.OrionPooledDataSource.getPooledInstance(OrionPooledDataSource.java:489)
at
com.evermind.sql.OrionPooledDataSource.getTheConnection(OrionPooledDataSource.java:253)
at
com.evermind.sql.OrionPooledDataSource.getOPDSConnection(OrionPooledDataSource.java:329)
at
com.evermind.sql.OrionCMTConnection.getConnection(OrionCMTConnection.java:206)
at
com.evermind.sql.OrionCMTConnection.<init>(OrionCMTConnection.java:146)
at
com.evermind.sql.OrionCMTConnectionFinalize.<init>(OrionCMTConnectionFinalize.java:42)
at
com.evermind.util.ClassOptimizerFactory.getOrionCMTConnection(ClassOptimizerFactory.java:80)
at
com.evermind.sql.OrionCMTDataSource.getConnection(OrionCMTDataSource.java:237)
at
com.evermind.sql.OrionCMTDataSource.getConnection(OrionCMTDataSource.java:217)
at
com.ibatis.sqlmap.engine.transaction.jta.JtaTransaction.init(JtaTransaction.java:68)
at
com.ibatis.sqlmap.engine.transaction.jta.JtaTransaction.getConnection(JtaTransaction.java:131)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:561)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:536)
at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:93)
at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:70)
at
mx.gob.shf.ice.dao.ServiciosDatosGeneralesDAO.getCdUniecoForSEPS(ServiciosDatosGeneralesDAO.java:3015)
--end log-
when i am calling a queryForObject, i obtaining this error, i am think that the
connection was not returned to the pool.
How i close the connection in ibatis, or return conection to the pool?.
I know that connection was not closed beacuse i set up max 10 connection in
DATA SOURCE, so i am running 11 proces, but 5 minutes later i run another
process and is the same result, the first 9 process run very well but the other
proces are not running and obtaining the error.
I am in a OC4j or OAS 10.1.2 environment, oracle 10g data base environment and
i am using connection pooling and the JNDI
<dataSource> and JTA transaction manager.
____________________________________________________________________________________
Yahoo! Deportes Beta
¡No te pierdas lo último sobre el torneo clausura 2008! Entérate aquí
http://deportes.yahoo.com
