Problemas de conexão do Hibernate

1 resposta
M

Estou o problema a seguir, já refiz os códigos e não acho o problema, alguém poderia ajudar ?

type Exception report

message org.hibernate.exception.GenericJDBCException: Cannot open connection

description The server encountered an internal error (org.hibernate.exception.GenericJDBCException: Cannot open connection) that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: org.hibernate.exception.GenericJDBCException: Cannot open connection
financeiro.web.filter.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:26)

root cause

org.hibernate.exception.GenericJDBCException: Cannot open connection

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

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

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

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

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

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

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

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

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

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.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:344)

$Proxy12.beginTransaction(Unknown Source)

financeiro.web.filter.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:13)

root cause

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)

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

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

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

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

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

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.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:344)

$Proxy12.beginTransaction(Unknown Source)

financeiro.web.filter.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:13)

root cause

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

java.lang.reflect.Constructor.newInstance(Unknown Source)

com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

com.mysql.jdbc.Util.getInstance(Util.java:386)

com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014)

com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)

com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)

com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)

com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2299)

com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2220)

com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:813)

com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)

sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

java.lang.reflect.Constructor.newInstance(Unknown Source)

com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)

com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)

org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)

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

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

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

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

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

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.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:344)

$Proxy12.beginTransaction(Unknown Source)

financeiro.web.filter.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:13)

root cause

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

java.lang.reflect.Constructor.newInstance(Unknown Source)

com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)

com.mysql.jdbc.MysqlIO.(MysqlIO.java:350)

com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2393)

com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2238)

com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2220)

com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:813)

com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)

sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

java.lang.reflect.Constructor.newInstance(Unknown Source)

com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)

com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)

org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)

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

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

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

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

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

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.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:344)

$Proxy12.beginTransaction(Unknown Source)

financeiro.web.filter.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:13)

root cause

java.net.ConnectException: Connection refused: connect

java.net.DualStackPlainSocketImpl.connect0(Native Method)

java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)

java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)

java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)

java.net.AbstractPlainSocketImpl.connect(Unknown Source)

java.net.PlainSocketImpl.connect(Unknown Source)

java.net.SocksSocketImpl.connect(Unknown Source)

java.net.Socket.connect(Unknown Source)

java.net.Socket.connect(Unknown Source)

java.net.Socket.(Unknown Source)

java.net.Socket.(Unknown Source)

com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)

com.mysql.jdbc.MysqlIO.(MysqlIO.java:300)

com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2393)

com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2238)

com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2220)

com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:813)

com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)

sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

java.lang.reflect.Constructor.newInstance(Unknown Source)

com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)

com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)

org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)

org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)

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

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

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

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

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

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.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:344)

$Proxy12.beginTransaction(Unknown Source)

financeiro.web.filter.ConexaoHibernateFilter.doFilter(ConexaoHibernateFilter.java:13)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.29 logs.

1 Resposta

Hebert_Coelho

Veja se o caminho do banco está correto, se o firewall não está te travando ou então se o banco está habilitado para acesso remoto. [=

Criado 15 de agosto de 2012
Ultima resposta 15 de ago. de 2012
Respostas 1
Participantes 2