大家帮我看看SYBASE下数据源的问题。

buyi

大家好！
  我们开发的应用采用WAS 4.1（WINDOWS 2000 SERVER）+SYBASE12.5（AIX 5）， 其中数据的连接采用DATASOURCE方式，我的应用程序如果过很常时间没有运行，再一次运行的时候，总是报以下错误，然后再次刷新次页面就很正常了。请问各位，这可能的原因是什么？ 谢谢！


     Error page exception
The server cannot use the error page specified for your application to handle the Original Exception printed below. Please see the Error Page Exception below for a description of the problem with the specified error page.


Original Exception:
Error Message: JZ006: 捕获到 IO 例外:com.sybase.jdbc2.jdbc.SybConnectionDeadException: JZ0C0: 连接已关闭。
Error Code: 500
Target Servlet: null
Error Stack:
com.ibm.websphere.ce.cm.StaleConnectionException: JZ006: 捕获到 IO 例外:com.sybase.jdbc2.jdbc.SybConnectionDeadException: JZ0C0: 连接已关闭。
     at java.lang.reflect.Constructor.newInstance(Native Method)
     at com.ibm.ejs.cm.portability.PortabilityLayerImpl.translateException(PortabilityLayerImpl.java:184)
     at com.ibm.ejs.cm.pool.ConnectO.translateException(ConnectO.java:1690)
     at com.ibm.ejs.cm.proxy.ConnectionProxy.translateException(ConnectionProxy.java:142)
     at com.ibm.ejs.cm.proxy.StatementProxy.translateException(StatementProxy.java:274)
     at com.ibm.ejs.cm.proxy.StatementProxy.executeQuery(StatementProxy.java:17
     at index_jsp_0._jspService(index_jsp_0.java:154)
     at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:139)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
     at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:286)
     at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:415)
     at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:544)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
     at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
     at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:159)
     at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:286)
     at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:106)
     at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
     at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
     at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
     at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:499)
     at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:27
     at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:105)
     at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:67)
     at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:123)
     at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
     at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:122)
     at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:315)
     at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
     at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:313)
     at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:242)
     at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)

alex2003

提示说连接已关闭，我觉得是因为websphere设置了连接的timeout时间，超过时间后连接关闭，刷新后，系统会再次请求一个新的连接，就正常了。