if performance is a critical requirement, than I would suggest writing a custom bean specific to the jdbc driver you intend to use. If Jakarta common provides all the features you need, than go with it.
If your application needs to support multiple databases and jdbc drivers, be warned that not all jdbc drivers implement pooling, nor do they implement it the same way. In particular, jdbc drivers for SQLserver vary significantly in implementation, so doing real world benchmarks of each driver is critical. If commons doesn't provide the features you need, like scrollable resultsets, you may want to implement jdbc 2.0 compliant pooling driver using javax.sql api. good luck peter lin 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]>
