Re: tomcat connection pooling problem

2008-06-09 Thread Youssef Mohammed
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 Dat

Re: tomcat connection pooling problem

2008-06-09 Thread Htin Kyaw Nyo
yes, i believe my oracle db reboot once in a while, but I have no control over rebooting db server since its for weekly maintenance. I will try to use validationQuery as Thomas mentioned. Thanks On Mon, Jun 9, 2008 at 1:43 PM, Propes, Barry L <[EMAIL PROTECTED]> wrote: > is this possibly Oracle r

Re: tomcat connection pooling problem

2008-06-09 Thread Htin Kyaw Nyo
Thanks Thomas, validationQuery method seems promising. I will configure and see if the issue is still there when the db server reboot. Thanks a lot. On Mon, Jun 9, 2008 at 1:21 PM, Mark Thomas <[EMAIL PROTECTED]> wrote: > > Htin Kyaw Nyo wrote: > >> Hi >> >> I am using tomcat55 and ojdbc14_g an

Re: tomcat connection pooling problem

2008-06-09 Thread Youssef Mohammed
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 tomca

RE: tomcat connection pooling problem

2008-06-09 Thread Propes, Barry L
is this possibly Oracle rebooting by its own settings? -Original Message- From: Htin Kyaw Nyo [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2008 9:27 AM To: Tomcat Users List Subject: tomcat connection pooling problem Hi I am using tomcat55 and ojdbc14_g and tomcat connection pooling

Re: tomcat connection pooling problem

2008-06-09 Thread Mark Thomas
Htin Kyaw Nyo 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.SQLExcept