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
