Erro 500 Cannot open connection - Hibernate

0 respostas
A

Sou iniciante no desenvolvimento java e estou tendo dificuldade em configurar o hibernate com o SQL Server 2008 Express. Alguem poderia me dar um auxilio?

Segue abaixo o código do erro:

exception

javax.servlet.ServletException: #{daoTeste.salvar}: org.hibernate.exception.GenericJDBCException: Cannot open connection

javax.faces.webapp.FacesServlet.service(FacesServlet.java:256)

org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)

org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)

root cause

javax.faces.FacesException: #{daoTeste.salvar}: org.hibernate.exception.GenericJDBCException: Cannot open connection

com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:107)

javax.faces.component.UICommand.broadcast(UICommand.java:383)

org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:186)

org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:164)

org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:352)

com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)

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

com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)

org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)

org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)

root cause

javax.faces.el.EvaluationException: org.hibernate.exception.GenericJDBCException: Cannot open connection

javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:91)

com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)

javax.faces.component.UICommand.broadcast(UICommand.java:383)

org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:186)

org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:164)

org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:352)

com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)

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

com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)

org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)

org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)

root cause

org.hibernate.exception.GenericJDBCException: Cannot open connection

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

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

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

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

org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)

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

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

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

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

controle.daoTeste.salvar(daoTeste.java:23)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

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

org.apache.el.parser.AstValue.invoke(AstValue.java:172)

org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)

org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:68)

javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)

com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)

javax.faces.component.UICommand.broadcast(UICommand.java:383)

org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:186)

org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:164)

org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:352)

com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)

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

com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)

org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)

org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)

root cause

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

com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)

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

com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)

org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:35)

org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)

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

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

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

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

controle.daoTeste.salvar(daoTeste.java:23)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

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

org.apache.el.parser.AstValue.invoke(AstValue.java:172)

org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)

org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:68)

javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)

com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)

javax.faces.component.UICommand.broadcast(UICommand.java:383)

org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:186)

org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:164)

org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:352)

com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)

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

com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)

org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)

org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)

root cause

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

com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970)

com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208)

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

com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)

org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:35)

org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)

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

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

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

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

controle.daoTeste.salvar(daoTeste.java:23)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

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

org.apache.el.parser.AstValue.invoke(AstValue.java:172)

org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)

org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:68)

javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)

com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)

javax.faces.component.UICommand.broadcast(UICommand.java:383)

org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:186)

org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:164)

org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:352)

com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)

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

com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)

org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)

org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)
Criado 19 de julho de 2011
Respostas 0
Participantes 1