I'd rather figure out what is causing the problem. Does cursor == open statement? Open resultset? Are you using cmp? If bmp are you closing everything in finally blocks?
A known problem is that the jca-jdbc wrappers don't track open statements for you and close them when you close the connection handle. This is not hard to fix, but I haven't done it yet. You might be able to make a solution to this problem in any cvs version of jboss if you can come up with some sql that will fail if too many cursors are open on a connection. All cvs versions now have CheckValidConnectionSQL for you to set: if you set it, this statement is executed when a connection is taken out of the pool and before it is handed out to your application. If you can determine from some Oracle info which connection it is and how many cursors or how many times the statement has been called, you could throw some kind of exception that would force the connection to be destroyed. thanks david jencks On 2003.02.17 11:50 "Sonnek, Ryan" wrote: > i posted this request about a week ago, and would like to know any > developers thoughts on this. to summerize, i'd like to be able to force > a > datasource to timeout any connections in the pool after a period of time. > > > we're running jboss 3.0.6 with oracle 8i and right now and we're > constantly > running into an error "Maximum number of cursors exceeded." being able > to > timeout connections that have been used heavily to restore those cursors > is > the only idea i had to get around this error. > > unfortunately this is a MAJOR problem for us right now, since we can't > get > our application up with 24/7 reliability. it only takes a matter of > minutes > of heavy activity to exceed 300 cursors on oracle. if there is some > other > way to get around this error, i would appreciate any feedback. or, if > this > is a planned enhancement, when would it be integrated? > > thanks in advance. > Ryan > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Jboss-development mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-development > > ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
