Yes, connections timed out. You'd like a deamon process to periodically refresh pooled connections. Ev
On Sun, 10 Mar 2002 07:31:21 -0000 "john bell" <[EMAIL PROTECTED]> wrote: >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: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
