search

AMT-Project / project_1

0 stars 1 forks source link

jdbc #14

Closed pabloheigvd closed 3 years ago

pabloheigvd commented 3 years ago

https://www.jetbrains.com/help/idea/connecting-to-a-database.html#connect-to-mysql-database

install mysql depuis intellij, probablement efficace

pabloheigvd commented 3 years ago

./runDocker.sh

on tente d'enregistrer un utilisateur (a avec mail a@a.ch) et cela produit

stackoverflow | [err] java.sql.SQLRecoverableException: Communications link failure
stackoverflow | 
stackoverflow | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. DSRA0010E: SQL State = 08S01, Error Code = 0
stackoverflow | [err]   at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
stackoverflow | [err]   at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
stackoverflow | [err]   at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)
stackoverflow | [err]   at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
stackoverflow | [err]   at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
stackoverflow | [err]   at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
stackoverflow | [err]   at com.mysql.cj.jdbc.MysqlDataSource.getConnection(MysqlDataSource.java:402)
stackoverflow | [err]   at com.mysql.cj.jdbc.MysqlDataSource.getConnection(MysqlDataSource.java:125)
stackoverflow | [err]   at com.mysql.cj.jdbc.MysqlDataSource.getConnection(MysqlDataSource.java:110)
stackoverflow | [err]   at com.mysql.cj.jdbc.MysqlConnectionPoolDataSource.getPooledConnection(MysqlConnectionPoolDataSource.java:48)
stackoverflow | [err]   at com.ibm.ws.rsadapter.impl.DatabaseHelper$1.run(DatabaseHelper.java:967)
stackoverflow | [err]   at [internal classes]
stackoverflow | [err]   at java.base/java.security.AccessController.doPrivileged(AccessController.java:770)
stackoverflow | [err]   at java.base/java.security.AccessController.doPrivilegedWithCombiner(AccessController.java:826)
stackoverflow | [err]   at com.ibm.ws.rsadapter.impl.DatabaseHelper.getPooledConnection(DatabaseHelper.java:953)
stackoverflow | [err]   at [internal classes]
stackoverflow | [err]   at ch.heigvd.amt.stack.infrastructure.persistence.jdbc.JdbcPersonRepository.save(JdbcPersonRepository.java:37)
stackoverflow | [err]   at ch.heigvd.amt.stack.infrastructure.persistence.jdbc.JdbcPersonRepository.save(JdbcPersonRepository.java:20)
stackoverflow | [err]   at ch.heigvd.amt.stack.infrastructure.persistence.jdbc.JdbcPersonRepository$Proxy$_$$_WeldClientProxy.save(Unknown Source)
stackoverflow | [err]   at ch.heigvd.amt.stack.application.identitymgmt.IdentityManagementFacade.register(IdentityManagementFacade.java:32)
stackoverflow | [err]   at ch.heigvd.amt.stack.ui.web.login.RegisterCommandEndpoint.doPost(RegisterCommandEndpoint.java:40)
stackoverflow | [err]   at javax.servlet.http.HttpServlet.service(HttpServlet.java:706)
stackoverflow | [err]   at [internal classes]
stackoverflow | [err]   at ch.heigvd.amt.stack.ui.web.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:24)
stackoverflow | [err]   at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201)
stackoverflow | [err]   at [internal classes]
stackoverflow | [err]   at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
stackoverflow | [err]   at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
stackoverflow | [err]   at java.base/java.lang.Thread.run(Thread.java:836)
stackoverflow | [err] Caused by: 
stackoverflow | [err] com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
stackoverflow | 
stackoverflow | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
stackoverflow | [err]   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
stackoverflow | [err]   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
stackoverflow | [err]   at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
stackoverflow | [err]   at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
stackoverflow | [err]   at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
stackoverflow | [err]   at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
stackoverflow | [err]   at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
stackoverflow | [err]   at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
stackoverflow | [err]   at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
stackoverflow | [err]   at com.mysql.cj.NativeSession.connect(NativeSession.java:144)
stackoverflow | [err]   at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:956)
stackoverflow | [err]   at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826)
stackoverflow | [err]   ... 60 more
stackoverflow | [err] Caused by: 
stackoverflow | [err] java.net.ConnectException: Connection refused (Connection refused)
stackoverflow | [err]   at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
stackoverflow | [err]   at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399)
stackoverflow | [err]   at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242)
stackoverflow | [err]   at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224)
stackoverflow | [err]   at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)
stackoverflow | [err]   at java.base/java.net.Socket.connect(Socket.java:609)
stackoverflow | [err]   at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
stackoverflow | [err]   at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
stackoverflow | [err]   ... 63 more

Plusieurs solutions peuvent être essayé dans cette réponse stackoverflow: https://stackoverflow.com/questions/6865538/solving-a-communications-link-failure-with-jdbc-and-mysql