Bon je suis exposé à un probleme depuis un bon moment maintenant je suis censé mettre en prod un appli web (JSP Servlet - Tomcat - MySQL).
Je tourne en rond depuis 3 semaines et la j'arrive à la date d'échéance...
Le problème est quau bout de 8 heures de connexion la base de donnée ferme la connexion, j'ai tout essayé -> pool de connexion DBCP (idem déco au bout de 8 heures) -> je suis actuellement sur c3p0 (mais c'est toujours pareil déco au bout de 8 heures).
J'ai donc bien l'impression que l'autoReconnect ne marche pas .
Bref la je sais vraiment plus ou chercher, je vous met l'exception renvoyé par Tomcat et ma configuration de c3p0 qui fonctionne mais qui ne semble pas assurer l'autoReconnect.
Sinon si vous pouviez m'orienter vers d'autre forum spécialisé sur Tomcat.
Exception :
Code :
- servletGST.domaine.RuntimeGSTException: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
- ** BEGIN NESTED EXCEPTION **
- java.net.SocketException
- MESSAGE: Software caused connection abort: recv failed
- STACKTRACE:
- java.net.SocketException: Software caused connection abort: recv failed
- at java.net.SocketInputStream.socketRead0(Native Method)
- at java.net.SocketInputStream.read(Unknown Source)
- at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
- at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
- at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
- at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1902)
- at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
- at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
- at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
- at com.mysql.jdbc.Statement.executeQuery(Statement.java:824)
- at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
- at servletGST.mapping.PersistanceManagerDB.findUtilisateurByLogin(PersistanceManagerDB.java:1173)
- at servletGST.web.ServletGST.doPost(ServletGST.java:69)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
- at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
- at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
- at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
- at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
- at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
- at java.lang.Thread.run(Unknown Source)
- ** END NESTED EXCEPTION **
- Last packet sent to the server was 844 ms ago.
- servletGST.mapping.PersistanceManagerDB.findUtilisateurByLogin(PersistanceManagerDB.java:1181)
- servletGST.web.ServletGST.doPost(ServletGST.java:69)
- javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
- javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
|
Config c3p0 :
méthode init :
Code :
- public void init() throws ServletException{
- try {
- //récupération de la source de donnée
- //Pool de connexions c3p0
- Context initCtx = new InitialContext();
- ds = (DataSource) initCtx.lookup("java:comp/env/jdbc/c3p0Pool" );
- } catch (Exception e) {
- throw new RuntimeGSTException(
- "ERREUR - chargement data source. \n" + e);
- }
|
Config server.xml :
Code :
- <Resource
- auth="Container"
- description="DB Connection"
- driverClass="com.mysql.jdbc.Driver"
- maxPoolSize="4"
- minPoolSize="2"
- acquireIncrement="1"
- name="jdbc/c3p0Pool"
- user="root"
- password="admin"
- factory="org.apache.naming.factory.BeanFactory"
- type="com.mchange.v2.c3p0.ComboPooledDataSource"
- jdbcUrl="jdbc:mysql://localhost:3306/db_support?autoReconnect=true" />
-
- <Context
- path="/SGST-0.7"
- reloadable="true">
- <ResourceLink
- global="jdbc/c3p0Pool"
- name="jdbc/c3p0Pool"
- type="javax.sql.DataSource"/>
- </Context>
|
