平时使用没什么问题。如果页面长时间没有操作,再次操作查询时,可能会出现如下错误:
ORA-02396: exceeded maximum idle time, please connect again
ORA-02063: preceding line from lt_b
或者
ORA-02068: following severe error from lt_b
ORA-01012: not logged on
我认为自己的程序是没有问题的。问题应该出在数据库链接之上。因为使用了连接池,web程序连接本地数据库可能是不会出问题的,而远程数据库链接就可能存在问题,超过一定时间没有操作,它是出现最大等待时间、没有登录等情况。
不知道这种情况有没有办法解决?
----------------------------------------------------------------------------------------------
网页上显示的错误信息: type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: javax.servlet.ServletException: java.sql.SQLException: ORA-02396: exceeded maximum idle time, please connect again
ORA-02063: preceding line from LT_B
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
javax.servlet.ServletException: java.sql.SQLException: ORA-02396: exceeded maximum idle time, please connect again
ORA-02063: preceding line from LT_B
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
java.sql.SQLException: ORA-02396: exceeded maximum idle time, please connect again
ORA-02063: preceding line from LT_B