[jbosscache-dev] Using Apache DBCP in NonManagedConnectionFactory

[Manik Surtani]

I doubt anyone would use a cache loader if JBC is a cache for  
Hibernate.  :-)

This is more for standalone cases, not even within an app server  
since then the app server would provide db conn pooling.
--
Manik Surtani

Lead, JBoss Cache
JBoss, a division of Red Hat

Email: manik at jboss.org
Telephone: +44 7786 702 706
MSN: manik at surtani.org
Yahoo/AIM/Skype: maniksurtani


On 12 Oct 2006, at 17:41, Vladimir Blagojevic wrote:

> Should ask Hibernate guys what to do? I think they use c3p0 as  
> default.
> Any potential pooling issues if someone uses jbc as a second level  
> cache
> for hibernate?
>
>
>> -----Original Message-----
>> From: jbosscache-dev-bounces at lists.jboss.org
>> [mailto:jbosscache-dev-bounces at lists.jboss.org] On Behalf Of
>> Manik Surtani
>> Sent: Thursday, October 12, 2006 10:26 AM
>> To: jbosscache-dev at lists.jboss.org
>> Subject: [jbosscache-dev] Using Apache DBCP in
>> NonManagedConnectionFactory
>>
>> At the moment, when using the non-managed connection factory
>> in the JDBC cache loader, a new connection is created for
>> every operation and in high-concurrency environments this can
>> exhaust the db connections.
>>
>> Should we be using a pooling library like Apache's DBCP[1]
>> for this?
>> Probably increase efficiency a great deal.  A user attempting
>> to improve throughput hacked in an open connection and stored
>> it in thread-local and saw some really big improvements[2].
>> His hack is not a solution since it breaks when using
>> transactions, but highlights the need for a conn pool for
>> people who use this cache loader outside of an app server.
>>
>> [1] http://jakarta.apache.org/commons/dbcp/
>> [2] http://www.jboss.com/index.html?
>> module=bb&op=viewtopic&p=3977895#3977895
>>
>> What do people think?
>> --
>> Manik Surtani
>>
>> Lead, JBoss Cache
>> JBoss, a division of Red Hat
>>
>> Email: manik at jboss.org
>> Telephone: +44 7786 702 706
>> MSN: manik at surtani.org
>> Yahoo/AIM/Skype: maniksurtani
>>
>>
>> _______________________________________________
>> jbosscache-dev mailing list
>> jbosscache-dev at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/jbosscache-dev
>>