connection pooling

[Cantor, Scott]

On 4/2/14, 3:46 PM, "Tom Scavo" <trscavo at gmail.com> wrote:

>This is FYI. For comparison, can you tell me what the IdP uses for
>connection pooling?

The JDBC pooling for application managed data sources is c3p0. Speaking
for myself, I have never had any success with it, and only use dbcp, so I
use container managed connections to get that option.

V3 if it assumes anything will be dbcp, not c3p0. I think c3p0 is actually
defunct, at least based on what Chad had said several years ago.

>Recently we had some issues with the InCommon Certificate Manager,
>hosted by Comodo. As it turns out, the Certificate Manager experienced
>a fairly serious outage due to increased workload that created an
>unserviceable workload for the database connection pool library c3p0
>[1]. Consequently, the C3p0 libraries were swapped out with another
>library, dbcp [2]. As a result, availability was restored and overall
>performance is measurably better.

Well, dbcp has its own issues, or had, but I think it stablized and I've
always used it. There were versions that deadlocked, and I was constantly
tweaking it years ago to avoid issues, but I think the current versions
are pretty robust.

-- Scott