Apache DBCP or Tomcat JDBC Connection Pool

[Neil Laurance <Ne...@igmarkets.com>]

Hi there,

For some time, the following link has existed:

http://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html

This details a 'new' Tomcat JDBC connection pool, with a number of reasons why this is superior to commons-dbcp

However, the standard datasource configuration page mentions that tomcat still uses dbcp by default:

http://tomcat.apache.org/tomcat-7.0-doc/jndi-datasource-examples-howto.html

Is the 'new' Tomcat JBDC connection pool suitable for adoption, and is there a timescale for making this the default pool?

Thanks, Neil

________________________________
The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone (+44 (0)20 7896 0011) and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG is a trading name of IG Markets Limited, a company registered in England and Wales under number 04008957. VAT registration number 761 2978 07. Registered Office: Cannon Bridge House, 25 Dowgate Hill, London EC4R 2YA. Authorised and regulated by the Financial Services Authority. FSA Register number 195355.

Re: Apache DBCP or Tomcat JDBC Connection Pool

[Daniel Mikusa <dm...@vmware.com>]

On Jan 18, 2013, at 11:47 AM, Neil Laurance wrote:

> Hi there,
> 
> For some time, the following link has existed:
> 
> http://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html
> 
> This details a 'new' Tomcat JDBC connection pool, with a number of reasons why this is superior to commons-dbcp

I would suggest that you refer to the doc that is included with Tomcat 7.  I don't know if that one is up-to-date anymore.

  https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html


> 
> However, the standard datasource configuration page mentions that tomcat still uses dbcp by default:
> 
> http://tomcat.apache.org/tomcat-7.0-doc/jndi-datasource-examples-howto.html
> 
> Is the 'new' Tomcat JBDC connection pool suitable for adoption, and is there a timescale for making this the default pool?

I personally prefer the new connection pool, tomcat-jdbc.  I like some of the features it add, in particular interceptors.  Plus, DBCP is known to have issues with scaling and concurrency, the new pool fixes that.  That being said, if you're running a small site, you may never hit those issues, so it may not matter which one you pick.

Dan

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org