Hi Peter, ped wrote:
The problem occurs if I set max threads to N and execute the above loop N+1 or more times (where N is a small number like 3 or 4). I see Tomcat threads sitting in c3p0 code waiting for a connection. There is no thread handling the incoming commit calls (step 3 above). The initial N iterations thru the loop all complete their DB transaction, they just hang while trying to commit the transaction.
When you issue N+1 requests you say "there is no thread handling the incoming . . . calls". Is Tomcat returning any errors to your client for the N+1th request? Is the connection being closed or anything?
Is it possible to reproduce the error by making a Servlet that simulates blocking on a database connection by sleeping for N seconds?
Kirk --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]