RE: [jbosscache-dev] Using Apache DBCP in NonManagedConnectionFactory

-----Original Message----- From: jbosscache-dev-bounces(a)lists.jboss.org [mailto:jbosscache-dev-bounces@lists.jboss.org] On Behalf Of Manik Surtani Sent: Thursday, October 12, 2006 10:26 AM To: jbosscache-dev(a)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(a)jboss.org Telephone: +44 7786 702 706 MSN: manik(a)surtani.org Yahoo/AIM/Skype: maniksurtani _______________________________________________ jbosscache-dev mailing list jbosscache-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/jbosscache-dev