Pessoal, to precisando muito da ajuda de vcs. Estou desenvolvendo uma aplicacao com hibernate+jpa utilizando o c3p0. (Ainda sou novato em java) Mas ta acontecendo o seguinte: o pool de conexao funciona, so que o c3p0 nunca derruba as conexoes que ja deu timeout.
configuracao do persistence.xml
java:comp/env/jdbc/DB
contexto.xml
<Resource auth=“Container”
name=“jdbc/DB”
user=“zzzz”
password=“xxxxx”
factory=“org.apache.naming.factory.BeanFactory”
type=“com.mchange.v2.c3p0.ComboPooledDataSource”
description=“DB Connection”
driverClass=“com.mysql.jdbc.Driver”
jdbcUrl=“jdbc:mysql://localhost:3306/xxxxx?autoReconnect=true”
autoCommitOnClose=“false”
automaticTestTable=“con_test”
minPoolSize=“0”
maxPoolSize=“100”
maxIdleTime=“60”
maxStatements=“0”
acquireIncrement=“1”
idleConnectionTestPeriod=“15”
checkoutTimeout=“5000”
initialPoolSize=“0”
maxStatementsPerConnection=“20”
acquireRetryDelay=“1000”
acquireRetryAttempts=“5”
breakAfterAcquireFailure=“true”
maxIdleTimeExcessConnections=“30”
numHelperThreads=“3”
debugUnreturnedConnectionStackTraces=“false”
unreturnedConnectionTimeout=“0”
maxAdministrativeTaskTime=“0”
maxConnectionAge=“15”
propertyCycle=“0”
testConnectionOnCheckin=“false”
testConnectionOnCheckout=“false”
usesTraditionalReflectiveProxies=“false”/>
Preciso muito resolver isso…
