Erro ao tentar acessar o usuario e senha

2 respostas
java
G

Boa Tarde, meu primeiro emprego, muito amador ainda, se alguem puder me dar o caminho ,
do start no tomcat, acesso o site, mais qnd digito o usuario e senha me vem esse erro ,

Caused by: br.com.g2b.merp.dao.DaoException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)

at br.com.g2b.merp.dao.DatabaseManager.getJndiConnection(DatabaseManager.java:65)

at br.com.g2b.merp.dao.DatabaseManager.getConnection(DatabaseManager.java:34)

at br.com.g2b.merp.dao.DatabaseDao.getConnection(DatabaseDao.java:33)

at br.com.g2b.merp.dao.SecurityDaoImpl.login(SecurityDaoImpl.java:56)

at br.com.g2b.merp.api.SecurityApiImpl.login(SecurityApiImpl.java:18) 49 more

Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)

at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:669)

at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:544)

at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:753)

at br.com.g2b.merp.dao.DatabaseManager.getJndiConnection(DatabaseManager.java:62) 53 more

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

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

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

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

at com.mysql.jdbc.Util.getInstance(Util.java:408)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)

at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2097)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2022)

at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:779)

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

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

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

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)

at org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:55)

at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355)

at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:115)

at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:665) 56 more

Caused by: java.sql.SQLException: Access denied for user merp’@‘localhost (using password: YES)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)

at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2191)

at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2038)

oq posso fazer? obrigado

2 Respostas

F

Falai @gubanin bom primeiro voce deve postar o seu código aqui, para que os demais colegas possam analisa-lo e dai poder te dar uma mao.

No aguardo
Att
Max

L

Parece um problema com permissão mesmo. Vc tem certeza que esse usuário está com os privilégios de acessar esse banco? Tente usar o mesmo usuário e senha para acessar o banco usando algum cliente (como o MySql Workbench, por exemplo).

Criado 2 de fevereiro de 2020
Ultima resposta 3 de fev. de 2020
Respostas 2
Participantes 3