Erro Conexão Banco de Dados [RESOLVIDO]

Front-end
#1

Feras,

de vez em quando recebe este erro de conexão em minha aplicação ai sou obrigado a dar um restart na minha aplicação,

o que e isso ?

11:49:40,742 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http--127.0.0.1-8089-1) SQL Error: 0, SQLState: null
11:49:40,742 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http--127.0.0.1-8089-1) javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/CONEXACAO
11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1361)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1289)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:261)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at br.com.getnet.retaguardabo121.parametrizacao.dao.ParametrizacaoImplDAO.listarParametrizacao(ParametrizacaoImplDAO.java:155)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at br.com.getnet.retaguardabo121.parametrizacao.bo.ParametrizacaoBO.listarParametrizacao(ParametrizacaoBO.java:85)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at br.com.getnet.retaguardabo121.parametrizacao.delegate.ParametrizacaoDelegate.listarParametrizacao(ParametrizacaoDelegate.java:101)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at java.lang.reflect.Method.invoke(Method.java:601)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.el.parser.AstValue.invoke(AstValue.java:262)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)

11:49:40,743 ERROR [stderr] (http--127.0.0.1-8089-1) 	at javax.faces.component.UICommand.broadcast(UICommand.java:315)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at javax.faces.component.UIViewRoot.processDecodes(UIViewRoot.java:935)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at com.sun.faces.lifecycle.ApplyRequestValuesPhase.execute(ApplyRequestValuesPhase.java:78)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at br.com.getnet.retaguardabo121.filter.SecurityFilter.doFilter(SecurityFilter.java:42)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

11:49:40,775 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at java.lang.Thread.run(Thread.java:722)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) Caused by: org.hibernate.exception.GenericJDBCException: Could not open connection

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:52)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:304)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:169)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.extractPhysicalConnection(ConnectionProxyHandler.java:82)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:138)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at com.sun.proxy.$Proxy65.prepareStatement(Unknown Source)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:147)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:166)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:145)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1739)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.loader.Loader.doQuery(Loader.java:828)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.loader.Loader.doList(Loader.java:2463)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.loader.Loader.doList(Loader.java:2449)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2279)

11:49:40,790 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.loader.Loader.list(Loader.java:2274)

11:49:40,806 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:470)

11:49:40,806 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)

11:49:40,806 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:196)

11:49:40,806 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1115)

11:49:40,806 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)

11:49:40,806 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:252)

11:49:40,806 ERROR [stderr] (http--127.0.0.1-8089-1) 	... 36 more

11:49:40,806 ERROR [stderr] (http--127.0.0.1-8089-1) Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/CONEXACAO

11:49:40,806 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:137)

11:49:40,806 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)

11:49:40,806 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:276)

11:49:40,806 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:297)

11:49:40,806 ERROR [stderr] (http--127.0.0.1-8089-1) 	... 57 more

11:49:40,806 ERROR [stderr] (http--127.0.0.1-8089-1) Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/CONEXACAO

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:390)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:368)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	... 60 more

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) Caused by: javax.resource.ResourceException: IJ000655: No managed connections available within configured blocking timeout (30000 [ms])

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:377)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	... 63 more

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) java.lang.IllegalStateException: EntityManager is closed

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.hibernate.ejb.EntityManagerImpl.close(EntityManagerImpl.java:131)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at br.com.getnet.retaguardabo121.parametrizacao.dao.ParametrizacaoImplDAO.listarParametrizacao(ParametrizacaoImplDAO.java:162)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at br.com.getnet.retaguardabo121.parametrizacao.bo.ParametrizacaoBO.listarParametrizacao(ParametrizacaoBO.java:85)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at br.com.getnet.retaguardabo121.parametrizacao.delegate.ParametrizacaoDelegate.listarParametrizacao(ParametrizacaoDelegate.java:101)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at java.lang.reflect.Method.invoke(Method.java:601)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.el.parser.AstValue.invoke(AstValue.java:262)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)

11:49:40,821 ERROR [stderr] (http--127.0.0.1-8089-1) 	at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at javax.faces.component.UICommand.broadcast(UICommand.java:315)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at javax.faces.component.UIViewRoot.processDecodes(UIViewRoot.java:935)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at com.sun.faces.lifecycle.ApplyRequestValuesPhase.execute(ApplyRequestValuesPhase.java:78)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at br.com.getnet.retaguardabo121.filter.SecurityFilter.doFilter(SecurityFilter.java:42)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)

11:49:40,837 ERROR [stderr] (http--127.0.0.1-8089-1) 	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)

11:49:40,853 ERROR [stderr] (http--127.0.0.1-8089-1) 	at java.lang.Thread.run(Thread.java:722)
#2

Feras,

acho que está resolvido isso…irei postar para futuras duvidas
adicionei esses trecho no meu standalone.xml

	<pool>
		<min-pool-size>0</min-pool-size>
		<max-pool-size>300</max-pool-size>
		<prefill>true</prefill>
	</pool>

e

	<timeout>
		<blocking-timeout-millis>600000</blocking-timeout-millis>
		<idle-timeout-minutes>5</idle-timeout-minutes>
	</timeout>
<datasource jta="true" jndi-name="java:/BANCO-BLA-BLA-BLA" pool-name="DefaultDS_pool" enabled="true" use-java-context="true" use-ccm="true">
	<connection-url>STRING DE CONEXÃO</connection-url>
	<driver>oracle</driver>
	<pool>
		<min-pool-size>0</min-pool-size>
		<max-pool-size>300</max-pool-size>
		<prefill>true</prefill>
	</pool>
	<security>
		<user-name>USUARIO</user-name>
		<password>SENHA</password>
	</security>
	<timeout>
		<blocking-timeout-millis>600000</blocking-timeout-millis>
		<idle-timeout-minutes>5</idle-timeout-minutes>
	</timeout>
</datasource>
#3

Fala grande! Estou com o mesmo problema… sua solução resolveu defintivamente?

#4

Na verdade a infra esta servindo para esconder problemas desde modelagem de dados e como está estruturada a aplicação e o Banco de dados, simples assim meu amigo. Claro isso serve como solução temporario mas acaba ficando definitiva