Has anyone used any alternatives to the DBCP with Tomcat because it seems to get worse and worse as I use it more.
Pete,
Are you asking if there are other connection pool managers other than DBCP?
Yes. Many. Unfortunately, I can only name a couple off the top of my head:
www.javaexchange.com has one (a David Flanagan, author of /Java Enterprise in a Nutshell/, recommendation) called DbConnectionBroker.
Also be sure to check the vendor of your database. They may have one.
Finally, if you want some code to play with, hack and improve, try looking at Marty Hall's connection pool examples from /Core Servlets and JavaServer Pages/ (www.coreservlets.com) -- Chapter 18. His code is free for unrestricted use and improvement. It's a great example, and as I recall, has room for optimization.
There are many more I'm sure. I recently participated in a code review of a complex webapp that used something called "Poolman". I didn't have to look at it much so I don't know where you can find it, if it's open-source, or other; try Google.
HTH, Tim
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
