Re: problem with connection pooling tomcat 5.0

2006-05-05 Thread Sreenivasulu R Gaddam
I am not aware of such option in the tomcat. But you can try with the removeAbandonedTimeout set to '0' and maxActive set 1. That's equalent to disabling pooling. Another option is to use the DriverManager instead of datasource to get the connection. In this case, you have your own connection hand

Re: problem with connection pooling tomcat 5.0

2006-05-05 Thread Hans Sowa
Thanks a lot. I have a further question. Do you know how I can create a JNDI DataResource without connection-pooling? Thanks in advance. On 5/5/06, Sreenivasulu R Gaddam <[EMAIL PROTECTED]> wrote: Most probably this is the problem with your database jobs or stored procedures, which are leavin

Re: problem with connection pooling tomcat 5.0

2006-05-04 Thread Sreenivasulu R Gaddam
Most probably this is the problem with your database jobs or stored procedures, which are leaving the cursors around before exiting. As I know, there is no such flag to say to tomcat. Another thing is, whether you are trying with load test, then that may be resonable. In that case, you can increa

problem with connection pooling tomcat 5.0

2006-05-04 Thread Hans Sowa
Hi all I'm not sure if this is realy the right user list for it but I try it. My Problem is that I use connection pooling with tomcat 5.0 and a oracle database. My Problem is now I got the error message "maximum open cursors exceeded after a while. So I checked this and actually I always close th