-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Zahid,
On 1/3/20 18:50, zahid wrote: > Is commons-dbcp-2.x a Database pooling component for any > container Jetty,Jboss tomcat etc. ? Yes. Tomcat ships with a shaded (package-renamed) version of commons-dbcp as well as tomcat-pool, a separate connection-pool implementation. > is commons-dbcp-2.x a third option, separate option from the two > pooling options [tomcat-pool and commons-pool] you mentioned ? No, I misspoke and said commons-pool. commons-dbcp is based upon commons-pool which is a generic pooling framework. The "dbcp" flavor provides pooling (unsurprisingly) of JDBC connections. The commons-pool reference was meant to be the bundled version of commons-dbcp that Tomcat already provides. Thanks, - -chris > On 03/01/2020 23:21, Dave Bothwell wrote: >> Chris, >> >> That was very helpful. >> >> Thank you Dave >> >> >> >> On Fri, Jan 3, 2020 at 5:29 PM Christopher Schultz < >> ch...@christopherschultz.net> wrote: >> > Dave, > > On 1/3/20 13:47, Dave Bothwell wrote: >>>>> I am using Tomcat 8.5.11 with JDBC connection pooling. >>>>> Based on the documentation it is clear that DBCP pooling >>>>> has changed the maxActive attribute to maxTotal. However it >>>>> is unclear, based on this document >>>>> https://tomcat.apache.org/tomcat-8.5-doc/jdbc-pool.html, if >>>>> JDBC pooling has also changed maxActive to maxTotal. >>>>> >>>>> my question is which attribute should I be using? > Are you asking about the difference between configurations for > tomcat-pool and commons-pool? > > commons-pool (which is the default connection-pool in Tomcat) uses > maxTotal. > > tomcat-pool (which is NOT the default connection-pool in Tomcat) > uses maxActive. > >>>>> Also, I am currently using both attributes maxActive and >>>>> maxTotal in my current server.xml file, which does not >>>>> appear to be causing any issues. > If you use both, you should be all set for whichever pool you use > at runtime. Note that you will have to specifically enable > tomcat-pool, so it's unlikely that the pooling-library in use will > be a surprise. > > If you look in your log file, you will notice that when Tomcat > starts up it will give you a warning that one of the two > configuration options failed to apply to whichever pool you are > using. It is a warning, not an error, so you can ignore it. But it > will show up in your log file every time. > > -chris >>> >>> -------------------------------------------------------------------- - - >>> >>> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >>> For additional commands, e-mail: users-h...@tomcat.apache.org >>> >>> -----BEGIN PGP SIGNATURE----- Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/ iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAl4TWrkACgkQHPApP6U8 pFibBw/+Mpzeueng9m+w+T19rZM3TG8MCToGHY1oqzrC59p3dIogcFW8qneEQhqd +Ah3Fz7G8aclSuWdJYLoqXm3vnmyWlfUM7qlDKIVyIb1AyWfdP0OqmWU2ze4WFLn jUmwVyX4F0K0AcnzFLxfQpZHK/0LS17tgig6ZwVZW1Wwu8zULOKavfnuDTl4mMwK qqJznL3wMLvU2mTWlWEKWIhCusLi2xmHWTh/rT0hl4r+WqhRDVyFEzC4Yl1XJTFJ IvyZcvSYPpHfvqg5OR15SlOwJbGxIhn1lyP5KrjciIy6zir4MdFp/8WsCKPF9MBW 7vxXf1fzoahGWkmbo6hgfpWnw7jOjq+bvAFGp6k287dXpJO6duIvqkIjfosZUTsU 0MoWtug3CTWz0E5bYLDZ4zo7+qyFVYzccUcSdXtjwUOmg+ln0VzXbPxpCB62Fk+/ SK7/ukHC9Ovy3upf5aMLSNDCDrl1/3I0tSuXz1lfObxqto0HZH3gho4mzKt1vnVc iECw0NBGD53lBC5FQ/KuUgn24DGgQlrU171KQV8h/YGrdj+PxYKDwsAdP7i00bzg 7upQ2oMdG4tzsFI7kXD178bVZgqUHLJ+1j5yI0nFGx3cRc47K79IRQj5Sxp4gw0W /0iRr9zhRWWvKsvICNyU86o269gPAuHbc1bGLOtV26DoKORaH1g= =RY/K -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org