Hello,

I've got a similar problem like Mr. Romianowksi.

First of all my connection is established by the promatter-Framework. But after the 8h of inactivity (like described in your documentation) I can't execute an query anymore.If I try to execute one after getting the connection (the connection-object returns, that it is opened!) it causes following exception:

SQLException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException

MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error

at java.net.SocketOutputStream.socketWrite0(Native Method)

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)

at java.net.SocketOutputStream.write(SocketOutputStream.java:136)

at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:66)

at java.io.BufferedOutputStream.write(BufferedOutputStream.java:110)

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2598)

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2531)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1499)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1609)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2234)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2159)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java: 1802)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:164 7)

at de.fourthproject.pms.servlets.PMSServlet.checkUser(PMSServlet.java:116)

at de.fourthproject.pms.servlets.frontend.PMSLogin.doPost(PMSLogin.java:64)

at de.fourthproject.pms.servlets.PMSServlet.doPost(PMSServlet.java:204)

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(Applica tionFilterChain.java:237)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:157)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:214)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 20)

at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCon textValve.java:198)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:152)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 20)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :137)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:104)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :118)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:102)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 20)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:109)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 20)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)

at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:79 9)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC onnection(Http11Protocol.java:705)

at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:57 7)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .java:683)

at java.lang.Thread.run(Thread.java:534)

** END NESTED EXCEPTION **