Re: tomcat issue with DBCP connection pool

2011-03-21 Thread Jorge Medina
Are you sure it is due to the stored procedure? You can get that error if you don't close all database objects. Make sure you close resultsets, statements, etc in a "finally" block throughout all your code. On Mon, Mar 21, 2011 at 4:59 PM, Propes, Barry L wrote: > And to thisis it absolute

RE: tomcat issue with DBCP connection pool

2011-03-21 Thread Propes, Barry L
And to thisis it absolutely necessary to use the SYS_REFCURSOR in Oracle? I use several packages and procesures and never use this! Granted, I may have many less records than you in your DB table, but I was just wondering. Perhaps it is. > BTW, my application calls a stored procedure which

Re: tomcat issue with DBCP connection pool

2011-03-21 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 To whom it may concern, On 3/21/2011 6:59 AM, the_biswa wrote: > I've written a thread program where in the run method I'm opening an > HTTPURLConnection and feeding a valid input and reading the server response. Do you launch this thread during norm