tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "john bell" <jbell...@btclick.com>
Subject Tomcat Oracle timeout? oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
Date Sun, 10 Mar 2002 07:31:21 GMT
Hi,

I have a connection pool and use Oracle in a test environment.
Normally all is OK however, if left alone for many hours the following happens when the attempt
is made to connect.
Can anyone help please?

Entered article.display
POOL get connection numconnections = 2
********1
Oracle Error in article.display
java.sql.SQLException: Io exception: Connection reset by peer: socket write error
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
        at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:292)
        at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:307)
        at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:189)
        at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:172)
        at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:339)
        at control.Article.display(Article.java:245)
        at jsp.control.homecont_3._jspService(homecont_3.java:251)
        at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java)
        at org.apache.tomcat.facade.ServletHandler.doService(Unknown Source)
        at org.apache.tomcat.core.Handler.invoke(Unknown Source)
        at org.apache.tomcat.core.Handler.service(Unknown Source)
        at org.apache.tomcat.facade.ServletHandler.service(Unknown Source)
        at org.apache.tomcat.core.ContextManager.internalService(Unknown Source)
        at org.apache.tomcat.core.ContextManager.service(Unknown Source)
        at org.apache.tomcat.modules.server.Ajp13Interceptor.processConnection(Unknown Source)
        at org.apache.tomcat.util.net.TcpWorkerThread.runIt(Unknown Source)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown Source)
        at java.lang.Thread.run(Thread.java:484)
setting instacr null in article test
POOL free connection numconnections = 1
In connMgr.release
POOL new instance getInstance numpools = 2
POOL getInstance clients = 406
POOL getInstance numconnections = 1
hello from 2 Cat2SideBean
hello from 2 Cat3SideBean
POOL getInstance clients = 407

John

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message