DBCP is Single Threaded

2013-11-07 Thread yogesh hingmire
While looking to upgrade to tomcat7, i understand the connection pool is a major improvement. I read that commons-dbcp is single threaded, in order to be thread safe commons-dbcp locks the entire pool, even during query validation. So as i understand, the connection pool will be locked when

Re: DBCP is Single Threaded

2013-11-07 Thread Mark Thomas
On 07/11/2013 15:58, yogesh hingmire wrote: While looking to upgrade to tomcat7, i understand the connection pool is a major improvement. I read that commons-dbcp is single threaded, in order to be thread safe commons-dbcp locks the entire pool, even during query validation. Where did you

Re: DBCP is Single Threaded

2013-11-07 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Yogesh, On 11/7/13, 10:58 AM, yogesh hingmire wrote: While looking to upgrade to tomcat7, i understand the connection pool is a major improvement. I read that commons-dbcp is single threaded, in order to be thread safe commons-dbcp locks

Re: DBCP is Single Threaded

2013-11-07 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Mark, On 11/7/13, 11:03 AM, Mark Thomas wrote: On 07/11/2013 15:58, yogesh hingmire wrote: While looking to upgrade to tomcat7, i understand the connection pool is a major improvement. I read that commons-dbcp is single threaded, in order

Re: DBCP is Single Threaded

2013-11-07 Thread Mark Thomas
On 07/11/2013 16:03, Christopher Schultz wrote: Yogesh, On 11/7/13, 10:58 AM, yogesh hingmire wrote: While looking to upgrade to tomcat7, i understand the connection pool is a major improvement. I read that commons-dbcp is single threaded, in order to be thread safe commons-dbcp locks

Re: DBCP is Single Threaded

2013-11-07 Thread Mark Thomas
On 07/11/2013 16:08, Christopher Schultz wrote: Mark, On 11/7/13, 11:03 AM, Mark Thomas wrote: On 07/11/2013 15:58, yogesh hingmire wrote: While looking to upgrade to tomcat7, i understand the connection pool is a major improvement. I read that commons-dbcp is single threaded, in order

Re: DBCP is Single Threaded

2013-11-07 Thread Christopher Schultz
. I read that commons-dbcp is single threaded, in order to be thread safe commons-dbcp locks the entire pool, even during query validation. So as i understand, the connection pool will be locked when handing out new connections and other threads which need connections from the pool

Re: DBCP is Single Threaded

2013-11-07 Thread Mark Thomas
On 07/11/2013 21:10, Christopher Schultz wrote: Can you describe the effective difference between my over-simplified description and what is implemented in commons-pool (ignoring thread-fairness, which I'll admit is a very useful feature)? For starters, the relatively expensive validation

Re: DBCP is Single Threaded

2013-11-07 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Mark, On 11/7/13, 4:44 PM, Mark Thomas wrote: On 07/11/2013 21:10, Christopher Schultz wrote: Can you describe the effective difference between my over-simplified description and what is implemented in commons-pool (ignoring thread-fairness,