dbConnectionBroker works well, is easy to use. Just drop the 5k jar into your $tocmat_home/webapp/app/lib directory http://www.javaexchange.com/ Example: http://www.javaexchange.com/Example1.html
Ken p.s. sorry about my posts to the list yesterday with bad date. :-( Ric Searle wrote: > Hi, > > I'm developing a web application using the Struts framework, running on > Tomcat 4.0.3, from which I need to access a MySQL database. I've read > various mailing lists etc looking for the best way to achieve this, but > not had much luck. > > Struts provides a basic Connection Pool, but user comments suggest that > this is not suitable for large-scale, high-traffic applications, and > also that it will soon be removed from Struts in favour of a > container-managed connection pool. I've found references to > DbConnectionBroker and Jakarta's commons-dbcp module. It seems to make > sense to use the latter, to keep the entire project neatly under the > Jakarta project, but I'd appreciate comments on either. > > I'm fairly new to Tomcat (and Servlets), and I can't find any simple > examples of how to use one of these connection pools. I suspect that I > need to add something to my server.xml, and instantiate the pool in the > servlet's init() method. It would be greatly appreciated if someone > could provide some simple instructions to get me started - sample code > would be fantastic. > > I hope to write about my experiences with this once I understand it - > there seems to be a need for documentation in this area. > > Regards, > > Ric Searle > Web Application Developer > -- > Dialogue Communications Ltd > > http://www.dialogue.co.uk > +44 (0) 114 221 0307 > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > > > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
