for oracle database, you can just use their native driver (oci driver), they have a Pooled DataSource that will manage the pooling natively ... you don't need dbcp then.
On Mon, Jun 9, 2008 at 5:26 PM, Htin Kyaw Nyo <[EMAIL PROTECTED]> wrote: > Hi > > I am using tomcat55 and ojdbc14_g and tomcat connection pooling. I am > getting this error when i leave tomcat run for a couple of days. I searched > around the internet and people blaming firewall and connection issues by db > server. here is a brief error: > java.sql.SQLException: Io exception: Connection reset by peer: socket write > error > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158) > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:382) > at > > oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:521) > at > > oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:979) > at > > oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:552)... > ....................................... > > I am pretty sure it is the connection issue from db server, since it can be > resolved by restarting tomcat. but this solution is not acceptable for our > production system. Is there anyway that I can systematically resolve the > issue (from my source code using try catch) OR tomcat connection pooling > configuration? I need to resolve without restarting tomcat. Thanks in > advance. > > Nick > -- Regards, Youssef
