[jbosscache-dev] Using Apache DBCP in NonManagedConnectionFactory

[Vladimir Blagojevic]

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
>