connection´s problem

[jose marcano <jo...@yahoo.com>]

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