the simple way to make sure it is Connection problem is to
1) insert an output before and after jdbc call.
2) try to see how many connections you make and compare number to the max
connection setting in Oracle DB
Hope this helps
Zlin
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 28, 2001 10:55 AM
> To: [EMAIL PROTECTED]
> Subject: RE: JDBC connection failing
>
> Hi , are there any firewalls between server and the database ? if yes
> then
> u can check the firewall settings ..
>
> are u using connection pooling ?
>
> regards ?
>
>
> -----Original Message-----
> From: Barnabas Yohannes [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 28, 2001 6:40 PM
> To: [EMAIL PROTECTED]
> Subject: JDBC connection failing
>
>
> Folks,
> We have an xml page that runs on tomcat and apache server. After the xml
> application that uses a jdbc connection to the databse. After it runs for
> about 12 hours, the page does not reply, that is, we get a page that is
> trying to load but remains blank without any response for a very long
> period
> of time. We have a T1 connection, but till no response.
>
> We think that it is caused by the JDBC connection after accessing it for
> many times, it is failing to release the open connections. However, this
> is
> only our speculation. Is there any way that we can check the JDBC
> connection?
>
> There is nothing in error logs of both apache or tomcat that is really
> helpful.
>
> Any help will be highly appreciated.
>
> Salutations,
