Hello,

I am Mathi working as a webdeveloper in our company.While we developing a
Onlinetest website we faced some database problem.In which Our database is working
Properly upto Continue Accessing the database,but when the database
reaching idle state our connection closing automatically and the server
throwing the following error.

Our server configuration Is:

OS :Redhat Linux 7.3

Database :MySQL-4.1.0-0

Java :J2SDK1.4.0

Webserve :Tomcat4.1.18 integrated with apache1.3 using mod_jk-ap13-1.2.2-1.



HTTP Status 500 - Internal Server Error

--------------------------------------------------------------------------------

type Exception report

message Internal Server Error

description The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: No operations allowed after connection closed.

Connection was closed due to the following exception:

** BEGIN NESTED EXCEPTION **

java.sql.SQLException
MESSAGE: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream

** BEGIN NESTED EXCEPTION **
\
java.io.IOException
MESSAGE: Unexpected end of input stream

STACKTRACE:

java.io.IOException: Unexpected end of input stream
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:1455)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:1826)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:10 98)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1192)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 2051)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1680)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1527)
at com.pmrsoft.sparta.tasks.TestRemovalTask$UserTestR emovalPeer.deleteExpiredUnusedTests(TestRemovalTas k.java:60)
at com.pmrsoft.sparta.tasks.TestRemovalTask.doTask(Te stRemovalTask.java:128)
at com.pmrsoft.sparta.tasks.TaskBase****n(TaskBase.jav a:25)


** END NESTED EXCEPTION **



STACKTRACE:

java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream

** BEGIN NESTED EXCEPTION **

java.io.IOException
MESSAGE: Unexpected end of input stream

STACKTRACE:

java.io.IOException: Unexpected end of input stream
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:1455)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:1826)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:10 98)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1192)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 2051)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1680)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1527)
at com.pmrsoft.sparta.tasks.TestRemovalTask$UserTestR emovalPeer.deleteExpiredUnusedTests(TestRemovalTas k.java:60)
at com.pmrsoft.sparta.tasks.TestRemovalTask.doTask(Te stRemovalTask.java:128)
at com.pmrsoft.sparta.tasks.TaskBase****n(TaskBase.jav a:25)


** END NESTED EXCEPTION **


at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:1614)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:1826)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:10 98)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1192)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 2051)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1680)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1527)
at com.pmrsoft.sparta.tasks.TestRemovalTask$UserTestR emovalPeer.deleteExpiredUnusedTests(TestRemovalTas k.java:60)
at com.pmrsoft.sparta.tasks.TestRemovalTask.doTask(Te stRemovalTask.java:128)
at com.pmrsoft.sparta.tasks.TaskBase****n(TaskBase.jav a:25)


** END NESTED EXCEPTION **


at com.pmrsoft.sparta.topics.Topic.getAllTopics(Topic .java:271)
at org.apache.jsp.index12_jsp._jspService(index12_jsp .java:120)
at org.apache.jasper****ntime.HttpJspBase.service(Http JspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(St andardContext.java:2416)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp1 3Processor.java:466)
at org.apache.ajp.tomcat4.Ajp13Processor****n(Ajp13Pro cessor.java:585)
at java.lang.Thread****n(Thread.java:484)



--------------------------------------------------------------------------------

Apache Tomcat/4.1.27