You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomee.apache.org by Romain Manni-Bucau <rm...@gmail.com> on 2012/07/21 11:05:05 UTC
Dbcp and tomee?
Do we try to use tomcat dbcp in tomee? It misses jta features.
Re: Dbcp and tomee?
Posted by zeeman <ha...@fastmail.us>.
It's a good plan, at least BoneCP offers what Tomcat pool offers, JTA
compatible, and web apps like mine would not mind adding the new jar and
deleting 2 jars needed by DBCP and commons pool. BoneCP has good design for
concurrency and abandoned connections, which is lacking in DBCP.
I'll be happy with this BoneCP option if it works reliably, and can be
packaged in resources.xml. Thanks for the good work, you guys are awesome!
--
View this message in context: http://openejb.979440.n4.nabble.com/Dbcp-and-tomee-tp4656450p4656520.html
Sent from the OpenEJB Dev mailing list archive at Nabble.com.
Re: Dbcp and tomee?
Posted by Romain Manni-Bucau <rm...@gmail.com>.
well not sure bonecp will be here out of the box since currently i'm not
sure it brings a lot more than tomcat (or even dbcp depending on the app)
but to use it adding few jar will now be easy (even in the app if using
resources.xml normally)
the todo are:
1) merge when we'll consider it stable (hope pretty quickly)
2) some logging/object creation should be rewritten/refactored (even if it
should work) to log better information
3) do some doc
- Romain
2012/7/25 zeeman <ha...@fastmail.us>
> Glad you went with BoneCP. It's a good pool. Have been using it in prod for
> some Spring projects. Looks like you guys are on the right path with this.
> Whenever you have completed the work and tested it, branch merged to trunk,
> I can test it with my project. I hope this is planned for 1.1 release.
> Thanks a bunch.
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/Dbcp-and-tomee-tp4656450p4656518.html
> Sent from the OpenEJB Dev mailing list archive at Nabble.com.
>
Re: Dbcp and tomee?
Posted by zeeman <ha...@fastmail.us>.
Glad you went with BoneCP. It's a good pool. Have been using it in prod for
some Spring projects. Looks like you guys are on the right path with this.
Whenever you have completed the work and tested it, branch merged to trunk,
I can test it with my project. I hope this is planned for 1.1 release.
Thanks a bunch.
--
View this message in context: http://openejb.979440.n4.nabble.com/Dbcp-and-tomee-tp4656450p4656518.html
Sent from the OpenEJB Dev mailing list archive at Nabble.com.
Re: Dbcp and tomee?
Posted by Romain Manni-Bucau <rm...@gmail.com>.
yes some updates: a branch here
http://svn.apache.org/repos/asf/openejb/branches/openejb-pool/ with
proxies, tomcat and bonecp pools (still in progress).
- Romain
2012/7/24 zeeman <ha...@fastmail.us>
> Any updates on which direction will be used for the DB pool?
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/Dbcp-and-tomee-tp4656450p4656515.html
> Sent from the OpenEJB Dev mailing list archive at Nabble.com.
>
Re: Dbcp and tomee?
Posted by zeeman <ha...@fastmail.us>.
Any updates on which direction will be used for the DB pool?
--
View this message in context: http://openejb.979440.n4.nabble.com/Dbcp-and-tomee-tp4656450p4656515.html
Sent from the OpenEJB Dev mailing list archive at Nabble.com.
Re: Dbcp and tomee?
Posted by Romain Manni-Bucau <rm...@gmail.com>.
hmm,
not sure the jta is the best idea (for perf reason) that's why i asked
about it.
About tomee/tomcat link about datasource it is better if we avoid a too
important link since datasource management is in openejb.
about tomcat and jta i found no way to get the same features we currently
have (maybe i missed them), i'll look further soon.
- Romain
2012/7/22 zeeman <ha...@fastmail.us>
> Here is my take on this. JCA is more for legacy systems integration. For
> Tomee since it's dependent on Tomcat, it makes sense that it works with
> Tomcat DB pool. Which means it's a matter of making Tomcat pool support JTA
> for Tomee. If that's not possible, override Tomcat pool in Tomee. Even with
> plain Tomcat it was possible to use JTA data sources by settings a
> transaction manager. So Tomee can do the same when registering data
> sources.
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/Dbcp-and-tomee-tp4656450p4656490.html
> Sent from the OpenEJB Dev mailing list archive at Nabble.com.
>
Re: Dbcp and tomee?
Posted by zeeman <ha...@fastmail.us>.
Here is my take on this. JCA is more for legacy systems integration. For
Tomee since it's dependent on Tomcat, it makes sense that it works with
Tomcat DB pool. Which means it's a matter of making Tomcat pool support JTA
for Tomee. If that's not possible, override Tomcat pool in Tomee. Even with
plain Tomcat it was possible to use JTA data sources by settings a
transaction manager. So Tomee can do the same when registering data sources.
--
View this message in context: http://openejb.979440.n4.nabble.com/Dbcp-and-tomee-tp4656450p4656490.html
Sent from the OpenEJB Dev mailing list archive at Nabble.com.
Re: Dbcp and tomee?
Posted by Romain Manni-Bucau <rm...@gmail.com>.
another thought: why not using jca?
wdyt?
- Romain
2012/7/21 Romain Manni-Bucau <rm...@gmail.com>
> i'd prefer a proxy in front of any datasource
>
> - Romain
>
>
>
> 2012/7/21 David Blevins <da...@gmail.com>
>
>> Poking Dain, hoping he can give some feedback. Dain was the one who
>> added the JTA support to DBCP when we needed it. It was a pretty decent
>> undertaking then. I.e. didn't fit terribly well.
>>
>> Redoing that in the Tomcat connection pooling might be possible.
>> Anything that uses the java.util.concurrent libraries is likely way better.
>>
>>
>> -David
>>
>> On Jul 21, 2012, at 11:57 AM, Romain Manni-Bucau wrote:
>>
>> > FYI using dbcp JTA part with a tomcat-jdbc backend pool is a bad idea we
>> > loose a lot of benefit of tomcat-jdbc and code is not clean.
>> >
>> > next idea is to either find a way to contribute to commons-dbcp tomcat
>> > features or to let our DataSourceFactory create simple datasources and
>> > manage ourself JTA link (= all manageddatasoruce stuff of commons dbcp
>> from
>> > our own code with proxies)
>> >
>> > wdyt?
>> >
>> > - Romain
>> >
>> >
>> > 2012/7/21 Romain Manni-Bucau <rm...@gmail.com>
>> >
>> >> Do we try to use tomcat dbcp in tomee? It misses jta features.
>> >>
>>
>>
>
Re: Dbcp and tomee?
Posted by Romain Manni-Bucau <rm...@gmail.com>.
i'd prefer a proxy in front of any datasource
- Romain
2012/7/21 David Blevins <da...@gmail.com>
> Poking Dain, hoping he can give some feedback. Dain was the one who added
> the JTA support to DBCP when we needed it. It was a pretty decent
> undertaking then. I.e. didn't fit terribly well.
>
> Redoing that in the Tomcat connection pooling might be possible. Anything
> that uses the java.util.concurrent libraries is likely way better.
>
>
> -David
>
> On Jul 21, 2012, at 11:57 AM, Romain Manni-Bucau wrote:
>
> > FYI using dbcp JTA part with a tomcat-jdbc backend pool is a bad idea we
> > loose a lot of benefit of tomcat-jdbc and code is not clean.
> >
> > next idea is to either find a way to contribute to commons-dbcp tomcat
> > features or to let our DataSourceFactory create simple datasources and
> > manage ourself JTA link (= all manageddatasoruce stuff of commons dbcp
> from
> > our own code with proxies)
> >
> > wdyt?
> >
> > - Romain
> >
> >
> > 2012/7/21 Romain Manni-Bucau <rm...@gmail.com>
> >
> >> Do we try to use tomcat dbcp in tomee? It misses jta features.
> >>
>
>
Re: Dbcp and tomee?
Posted by David Blevins <da...@gmail.com>.
Poking Dain, hoping he can give some feedback. Dain was the one who added the JTA support to DBCP when we needed it. It was a pretty decent undertaking then. I.e. didn't fit terribly well.
Redoing that in the Tomcat connection pooling might be possible. Anything that uses the java.util.concurrent libraries is likely way better.
-David
On Jul 21, 2012, at 11:57 AM, Romain Manni-Bucau wrote:
> FYI using dbcp JTA part with a tomcat-jdbc backend pool is a bad idea we
> loose a lot of benefit of tomcat-jdbc and code is not clean.
>
> next idea is to either find a way to contribute to commons-dbcp tomcat
> features or to let our DataSourceFactory create simple datasources and
> manage ourself JTA link (= all manageddatasoruce stuff of commons dbcp from
> our own code with proxies)
>
> wdyt?
>
> - Romain
>
>
> 2012/7/21 Romain Manni-Bucau <rm...@gmail.com>
>
>> Do we try to use tomcat dbcp in tomee? It misses jta features.
>>
Re: Dbcp and tomee?
Posted by Romain Manni-Bucau <rm...@gmail.com>.
FYI using dbcp JTA part with a tomcat-jdbc backend pool is a bad idea we
loose a lot of benefit of tomcat-jdbc and code is not clean.
next idea is to either find a way to contribute to commons-dbcp tomcat
features or to let our DataSourceFactory create simple datasources and
manage ourself JTA link (= all manageddatasoruce stuff of commons dbcp from
our own code with proxies)
wdyt?
- Romain
2012/7/21 Romain Manni-Bucau <rm...@gmail.com>
> Do we try to use tomcat dbcp in tomee? It misses jta features.
>