Database monitoring and connection pooling

Elias Ross genman at noderunner.net
Wed May 29 16:43:26 UTC 2013


On Wed, May 29, 2013 at 7:31 AM, Thomas Segismont <tsegismo at redhat.com> wrote:
> Thanks Elias for pointing this out. I created this BZ:
> https://bugzilla.redhat.com/show_bug.cgi?id=968361
>
> From my point of view there is no reason for the abstract database plugin to
> ship a connection pool. Many drivers provide a connection pool backed
> datasource class. I think such classes should be used where possible to
> avoid loading an additional library.

In theory, that would be great. Oracle and Postgres, though, has their
own preferential way to configure pooling and use these pooled
connections. Meaning: Each vendor has their own classes you must
import and use. For MySQL, it seems there isn't one provided, but
maybe I haven't dug enough.

The BoneCP library is 115kb, which is fairly reasonable. The benefit
with this class is also you get the standard debug logging through
log4j. I'm not sure how you might do that with, say, Oracle's driver.
It also means every JDBC driver just works.


More information about the rhq-devel mailing list