Hello, i've developed a web application, it runs on Tomcat 5.5.4 and it uses MySQL. I have a problem when after i use the application, and then it remains idle for some hours. It seems that the connection with MySQL it's closed by the driver due to a timeout. The stacktrace is the follow:
javax.servlet.ServletException: No operations allowed after connection closed.Connection was implicitly closed by the driver. org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778) org.apache.jsp.aziende_jsp._jspService(org.apache.jsp.aziende_jsp:482) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed by the driver. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1160) com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1147) com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2486) com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2468) businessLogic.CommonInterface.getSpecializzazioni(CommonInterface.java:1538) businessLogic.CommonInterface.getSpecializzazione(CommonInterface.java:930) org.apache.jsp.aziende_jsp._jspService(org.apache.jsp.aziende_jsp:128) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) Can i configure Tomcat so that the connection with MySQL will be persistent? thank you in advice :) -- View this message in context: http://old.nabble.com/Tomcat-and-MySQL-tp26408387p26408387.html Sent from the Tomcat - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
