tomcat-jdbc vs. tomcat-dbcp

[Christian <cm...@famiru.de>]

Hi,

reading tomcat 8.x documentation, I don't find anything about tomcat-dbcp. The use of tomcat-jdbc is described at [1].
Some of the disadvantages just apply for DBCP 1.x.
Is the use of tomcat-jdbc still recommended compared to the repackaged DBCP 2.x in tomcat-dbcp package?

Regards,
Christian

[1] https://tomcat.apache.org/tomcat-8.0-doc/jdbc-pool.html

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

Re: tomcat-jdbc vs. tomcat-dbcp

[Christopher Schultz <ch...@christopherschultz.net>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Christian,

On 11/28/14 7:57 AM, Christian wrote:
> reading tomcat 8.x documentation, I don't find anything about 
> tomcat-dbcp. The use of tomcat-jdbc is described at [1]. Some of 
> the disadvantages just apply for DBCP 1.x. Is the use of 
> tomcat-jdbc still recommended compared to the repackaged DBCP 2.x 
> in tomcat-dbcp package?
> 
> Regards, Christian
> 
> [1] https://tomcat.apache.org/tomcat-8.0-doc/jdbc-pool.html

Tomcat 8 comes with DBCP 2.x which is an improvement over DBCP 1.x and
the differences between DBCP 2.x and tomcat-pool are somewhat less
important.

tomcat-pool supports some additional nice-to-have features and has a
bit less overhead in terms of API size (class count) and so from a
virtual-method standpoint ought to be a tiny bit faster, but not so
much that you'd notice given that SQL queries take hundreds,
thousands, or millions of times more time to execute than method
invocations.

So, my recommendation is to choose whichever pool has the features
that you require and doesn't take too much fussing to configure
properly. Since Tomcat's default pool is based upon DBCP, it's likely
to be slightly easier to configure that one over tomcat-pool.

You can always benchmark in your environment to determine if
performance is a factor for you.

Thanks,
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
Comment: GPGTools - http://gpgtools.org

iQIcBAEBCAAGBQJUeId/AAoJEBzwKT+lPKRYr9oQAMWWkXoOMrrYRhHyGGneON7Q
dqDO2KjyNohoq+1ECzTtBmfkLtKuln9ilzt10H0MBbS0IXp+Ng/QibNoocF/W2yV
dKkh1QcfzH2jDE00ClSLFpoD7KxQ8mTh2XZWK+E22Iyixb0PehQASV+nVkrTyIqD
hF2jOCzmfn4G41W+P194q3lO7n3SqQIKcWvhcWYhxSyQMODksQsJMYDm6fU6thuO
PprCIq2UdDAQTqOSatbHslGg0zqj4qVt7avffbM+NCJn9zRzjgjnkGdHjAbP1NPG
BXmaGuNc22vV4pDbjS2ljgn/jtWu0K6IgxFIdLL/eguCUvtmn0OlIPyF3omPm70o
+DKDf22ME+aOcAZvCFanSAkTe95XktGBx6KPPrwRLjSJbM/OL3wt6Sktih9ULxfU
nMfMQ0eAUqRK4P9DN85E2zmZ76e+pTEpmgkuIYdrk4L66oudaBesLODfZYUy9Jon
0AsZEjVPouY5w+V51FWu8P29MWS33af+O4kNCK31SdEHx5FziLuNY43L1vIYDIIA
N1729D4b+J3fUsmPvF0JDn0VBPTnz4Hj1Vb5uYvbLm3rE3Bz+UDpuGdcw2z2FLkF
vNzVhWCVN8XNnz3VZd/mtZ8OUVPE2tcAbBX5P9bjxn8BUtE2mLyCx14E6yJOgz6p
061pxnx6KRu4LfswR+BM
=lq6D
-----END PGP SIGNATURE-----

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