Connection Pooling in Framework

[darrell73s]

Currently I'm using OFBiz 12.04.02 which uses commons-dbcp 1.4. I'm looking to take advantage of some of the newer features in dbcp 2 which I noticed is the version being used in trunk. I was hoping to get others' takes on feasibility and/or ease of adding/upgrading dbcp to the latest version in 12.04.

Additionally, wondering if anyone has had experience with using another connection pooling solution, such as tomcat's connection pooling or c3p0 and what kinds of impacts on the framework that a switch like that had? I realize that the intent is that it should be as straight forward as implementing a new ConnectionFactory for your chosen solution but wanted to seek out any other "gotchas" that may come up (e.g. Transaction management, etc).

Thanks!
Darrell

[Adrian Crum-3]

I worked on integrating Tomcat's connection pool, but I ran into
problems and never finished it.

https://issues.apache.org/jira/browse/OFBIZ-5363

Adrian Crum
Sandglass Software
www.sandglass-software.com

On 9/28/2014 4:24 AM, darrell73s wrote:

> Currently I'm using OFBiz 12.04.02 which uses commons-dbcp 1.4. I'm looking
> to take advantage of some of the newer features in dbcp 2 which I noticed is
> the version being used in trunk. I was hoping to get others' takes on
> feasibility and/or ease of adding/upgrading dbcp to the latest version in
> 12.04.
>
> Additionally, wondering if anyone has had experience with using another
> connection pooling solution, such as tomcat's connection pooling or c3p0 and
> what kinds of impacts on the framework that a switch like that had? I
> realize that the intent is that it should be as straight forward as
> implementing a new ConnectionFactory for your chosen solution but wanted to
> seek out any other "gotchas" that may come up (e.g. Transaction management,
> etc).
>
> Thanks!
> Darrell
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Connection-Pooling-in-Framework-tp4656132.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Jacopo Cappellato-4]

You could also consider the integration I have implemented for Atomikos:

https://issues.apache.org/jira/browse/OFBIZ-5129

but please consider that I did only some cursory tests. Atomikos provides db transaction and db pooling management.

Jacopo


On Sep 28, 2014, at 5:24 AM, darrell73s <[hidden email]> wrote:

> Currently I'm using OFBiz 12.04.02 which uses commons-dbcp 1.4. I'm looking
> to take advantage of some of the newer features in dbcp 2 which I noticed is
> the version being used in trunk. I was hoping to get others' takes on
> feasibility and/or ease of adding/upgrading dbcp to the latest version in
> 12.04.
>
> Additionally, wondering if anyone has had experience with using another
> connection pooling solution, such as tomcat's connection pooling or c3p0 and
> what kinds of impacts on the framework that a switch like that had? I
> realize that the intent is that it should be as straight forward as
> implementing a new ConnectionFactory for your chosen solution but wanted to
> seek out any other "gotchas" that may come up (e.g. Transaction management,
> etc).
>
> Thanks!
> Darrell
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Connection-Pooling-in-Framework-tp4656132.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.