Re: deadlock in database connection pooling?

2009-12-11 Thread Mitch Claborn
Excellent information! I will try those immediately. mitch Christopher Schultz wrote: > Mitch, > > On 12/10/2009 7:43 PM, Mitch Claborn wrote: > > poolPreparedStatements="true" > > driverClassName="com.mysql.jdbc.Driver" > > validationQuery="select * fr

Re: deadlock in database connection pooling?

2009-12-11 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mitch, On 12/10/2009 7:43 PM, Mitch Claborn wrote: > poolPreparedStatements="true" > driverClassName="com.mysql.jdbc.Driver" > validationQuery="select * from operator limit 1" FWIW, this is a non-ideal valida

RE: deadlock in database connection pooling?

2009-12-10 Thread Caldarale, Charles R
> From: Mitch Claborn [mailto:mi...@claborn.net] > Subject: Re: deadlock in database connection pooling? > > Can I simply delete the tomcat version of dbcp (jar file) and drop in > the 1.3 version from commons? No, Tomcat renames the classes in the jar to avoid collisions with any

Re: deadlock in database connection pooling?

2009-12-10 Thread Mitch Claborn
Sorry - I was going to put that in and just forgot. Old age strikes again. It is 6.0.20. Can I simply delete the tomcat version of dbcp (jar file) and drop in the 1.3 version from commons? Mitch Claborn 972-954-7341 mi...@claborn.net Caldarale, Charles R wrote: >> From: Mitch Claborn [mai

RE: deadlock in database connection pooling?

2009-12-10 Thread Caldarale, Charles R
> From: Mitch Claborn [mailto:mi...@claborn.net] > Subject: deadlock in database connection pooling? > > I'm seeing several occurrences of deadlocks in Tomcat like the > following. Any clues? Definition of the Resource is below. Want to give us a hint about what Tomcat version you're using? Or