Hi Jonathan, Sorry for the delays.
I have a few questions for you... Have you switched to using JNDI lookups yet? (Since you are clearly using a web-based container.) I'd say JNDI is by far the preferred way to go for almost all web applications. Also, what kind of load do you have on your system? Our connection pools are rarely larger than 25-50 and work just fine. 10,000 connections smells to me of a larger problem. Cayenne works great with database connection pools. Whenever you perform an operation it checks out a connection, uses it, then returns it to the pool. Thanks, mrg On Sun, Jan 4, 2015 at 10:10 PM, jonathan_ms2006 <jonathan_ms2...@yahoo.com> wrote: > Hi Ari, > > I think you have a point there. Also I read some article about > connection pooling using web application container (tomcat), assuming we > have properly installed and configured Database Connection Pool (DBCP for > example), shall not this interfere or be in conflict with the connection > pool configured in cayennes' dataNodeDriver.xml.? will it be safe to remove > cayennes' dataNodeDriver connection pool.? In your case, have you removed > it.? Any ideas.? Thank you in advance... :)) > > Best Regards, > > Jonathan > > > > -- > View this message in context: > http://cayenne.195.n3.nabble.com/Closing-Cayennes-DataContext-tp4026629p4026635.html > Sent from the Cayenne - User mailing list archive at Nabble.com. >
