this class what i was talking about http://download-uk.oracle.com/docs/cd/B10501_01/java.920/a96654/oci_func.htm#1014118
On Mon, Jun 9, 2008 at 8:53 PM, Youssef Mohammed <[EMAIL PROTECTED]> wrote: > 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 -- Regards, Youssef
