bom dia
estou com problema de pool de conexoes utilizando SyBase, Hibernate e Spring
=======PRIMEIRO ERRO=========
2006-11-16 11:39:20,440 WARN SQL Error: 0, SQLState: 08S01
java.sql.SQLException: TDS Protocol error: Invalid packet type 0x43
2006-11-16 11:39:20,440 ERROR TDS Protocol error: Invalid TDS data type 0x52
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:1807)
at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:616)
at net.sourceforge.jtds.jdbc.JtdsStatement.close(JtdsStatement.java:533)
at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:165)
at org.apache.commons.dbcp.DelegatingConnection.passivate(DelegatingConnection.java:312)
at org.apache.commons.dbcp.DelegatingConnection.close(DelegatingConnection.java:150)
at org.apache.commons.dbcp.PoolableConnection.reallyClose(PoolableConnection.java:95)
at org.apache.commons.dbcp.PoolableConnectionFactory.destroyObject(PoolableConnectionFactory.java:301)
at org.apache.commons.pool.impl.GenericObjectPool.invalidateObject(GenericObjectPool.java:81
at org.apache.commons.dbcp.AbandonedObjectPool.invalidateObject(AbandonedObjectPool.java:112)
at org.apache.commons.dbcp.AbandonedObjectPool.removeAbandoned(AbandonedObjectPool.java:145)
at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:72)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)2006-11-16 11:39:20,440 WARN exception clearing maxRows/queryTimeout
===== SEGUNDO ERRO=========
2006-11-16 11:39:20,442 ERROR Could not close Hibernate session
java.sql.SQLException: Already closed.
at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:77)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:180)
at org.springframework.orm.hibernate.LocalDataSourceConnectionProvider.closeConnection(LocalDataSourceConnectionProvider.java:69)
at net.sf.hibernate.impl.BatcherImpl.closeConnection(BatcherImpl.java:30
at net.sf.hibernate.impl.SessionImpl.disconnect(SessionImpl.java:3387)
at net.sf.hibernate.impl.SessionImpl.close(SessionImpl.java:584)
at org.springframework.orm.hibernate.SessionFactoryUtils.doClose(SessionFactoryUtils.java:651)
at org.springframework.orm.hibernate.SessionFactoryUtils.closeSessionOrRegisterDeferredClose(SessionFactoryUtils.java:640)
at org.springframework.orm.hibernate.SessionFactoryUtils.closeSessionIfNecessary(SessionFactoryUtils.java:622)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:25
=======TERCEIRO ERRO===================
2006-11-16 10:42:18,605 ERROR [Thread-793] (Hibernate operation): encountered SQLException [Cannot get a connection, pool exhausted]; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
org.springframework.jdbc.UncategorizedSQLException: (Hibernate operation): encountered SQLException [Cannot get a connection, pool exhausted]; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
Na Configuracao do Spring utilizando BasicDataSource esta com no maximo 25 conexoes ativas, e ocorre de ter 2 … 3 vezes mais do que o configurado
Alguem já passou por isto???