You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by darrell73s <da...@gmail.com> on 2014/09/28 05:24:39 UTC

Connection Pooling in Framework

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.

Re: Connection Pooling in Framework

Posted by Jacopo Cappellato <ja...@hotwaxmedia.com>.
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 <da...@gmail.com> 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.


Re: Connection Pooling in Framework

Posted by Adrian Crum <ad...@sandglass-software.com>.
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.
>