Connections could not be acquired from the underlying database

1 resposta
B

Boa noite pessoal,

Eu comprei um livro de jsf + spring + hibernate que veio com um projeto de um e-commerce de exemplo. Estou tentando rodar o exemplo mas está dando erro. Esse é o arquivo persistence.xml que está em META-INF:

<?xml version="1.0" encoding="UTF-8"?>

org.hibernate.ejb.HibernatePersistence

O nome da minha base é ecommerce_teste. Conferi o usuário e senha e estão corretos. A base também está no ar porque consigo logar nela via prompt de comando(mysql -u root -psenha -D ecommerce_teste). Segue o printStackTrace:

INFO: Added Library from: jar:file:/C:/Users/bruno/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/ProjEcommerce/WEB-INF/lib/trinidad-impl-1.2.7.jar!/META-INF/trh.taglib.xml

05/08/2013 06:57:12 com.sun.facelets.compiler.TagLibraryConfig loadImplicit

INFO: Added Library from: jar:file:/C:/Users/bruno/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/ProjEcommerce/WEB-INF/lib/trinidad-impl-1.2.7.jar!/META-INF/tr.taglib.xml

06:57:15,808 ERROR JDBCExceptionReporter:78 - Connections could not be acquired from the underlying database!

05/08/2013 06:57:15 com.sun.facelets.FaceletViewHandler handleRenderException

GRAVE: Error Rendering View[/home.xhtml]

javax.faces.el.EvaluationException: javax.el.ELException: /template/template.xhtml @113,64 value="#{lojaController.todasCat}": Error reading todasCat on type br.com.integrator.controller.LojaController

at javax.faces.component.ValueBindingValueExpressionAdapter.getValue(ValueBindingValueExpressionAdapter.java:106)

at com.sun.facelets.component.UIRepeat.getValue(UIRepeat.java:143)

at com.sun.facelets.component.UIRepeat.getDataModel(UIRepeat.java:121)

at com.sun.facelets.component.UIRepeat.setIndex(UIRepeat.java:305)

at com.sun.facelets.component.UIRepeat.process(UIRepeat.java:333)

at com.sun.facelets.component.UIRepeat.encodeChildren(UIRepeat.java:617)

at javax.faces.component.UIComponent.encodeAll(UIComponent.java:886)

at javax.faces.component.UIComponent.encodeAll(UIComponent.java:892)

at javax.faces.component.UIComponent.encodeAll(UIComponent.java:892)

at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:578)

at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:178)

at org.apache.myfaces.trinidadinternal.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:176)

at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)

at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)

at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)

at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)

at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)

at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)

at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:746)

at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:716)

at org.apache.jsp.index_jsp._jspService(index_jsp.java:68)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:112)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: javax.el.ELException: /template/template.xhtml @113,64 value="#{lojaController.todasCat}": Error reading todasCat on type br.com.integrator.controller.LojaController

at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:76)

at javax.faces.component.ValueBindingValueExpressionAdapter.getValue(ValueBindingValueExpressionAdapter.java:102)

 50 more

Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection

at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:375)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:377)

at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at $Proxy51.todos(Unknown Source)

at br.com.integrator.controller.LojaController.getTodasCat(LojaController.java:102)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at javax.el.BeanELResolver.getValue(BeanELResolver.java:87)

at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:67)

at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)

at org.apache.el.parser.AstValue.getValue(AstValue.java:183)

at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:185)

at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)

 51 more

Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection

at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:630)

at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:41)

at org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:70)

at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:330)

 68 more

Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection

at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)

at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)

at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)

at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)

at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:38)

 70 more

Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!

at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)

at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)

at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)

 75 more

Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.

at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)

at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)

at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)

 78 more

06:57:15,908 ERROR JDBCExceptionReporter:78 - Connections could not be acquired from the underlying database!

06:57:45,100 ERROR JDBCExceptionReporter:78 - Connections could not be acquired from the underlying database!

Alguém sabe o que pode ocasionar esse erro? Qualquer ajuda eu agradeço.

Abraço

1 Resposta

A

Bruno.
Amigo, provavelemnte seu problema são os dados de acesso a base de dados.
Revise: usuário, senha e etc.

da uma olhada aqui: https://confluence.atlassian.com/display/CONFKB/java.sql.SQLException+Connections+Could+not+be+Acquired+from+the+Underlying+Database

Criado 7 de agosto de 2013
Ultima resposta 6 de set. de 2013
Respostas 1
Participantes 2