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.
[EMAIL PROTECTED]
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
__________________________________________________
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
--
To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>
