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 the statement and the connection. I found out that it is also a good approach to close the result set. Ok, I also do this now but the problem still exists. I checked it with PL/SQL Client from that a lot of cursors are still open after closing.
So, my question is, is there a flag to be set in server.xml where I can say please close all open cursor after connection closing? Thanks in advance. -- mfg Hans Sowa mailto:[EMAIL PROTECTED]
