Re: Tomcat Oracle timeout? oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)

[tyler <ro...@fastmail.fm>]

Looks to me like your oracle connections in the pool have timed out  due
to inactivity you might check your oracle configuration to confirm this.

Rob


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

--
To unsubscribe:   <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>