Thanks for the reference. This looks like what I need. Now to go read up a bit more to grasp the concept.
Tony -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 26, 2000 2:30 PM To: Tony Fountain Subject: Re: Suggestions for connection pooling DBCP http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.h tml#Database%20Connection%20Pool%20(DBCP)%20Configurations Plenty of good examples on JNDI Configurations M-- ----- Original Message ----- Wrom: XRQBGJSNBOHMKHJYFMYXOEAIJJPHSCRTNHGSWZIDREXCAXZ To: "Tomcat Users List" <users@tomcat.apache.org> Sent: Thursday, October 25, 2007 1:19 PM Subject: Suggestions for connection pooling Platform: Apache Tomcat 5.5.23 running as windows service JVM 1.5.0_12-b04 (Sun) Windows 2003 Server We are running software on this platform that we purchased and integrated into our product. We replaced the default authentication class of the product with our own implementation. This resulted in a Java class that performs many database calls to SQL Server 2005. This all works and I'm in a mode of optimizing it and found that I'm creating a database connection for every call (sometimes a single action sends many requests). I've been researching options for implementing connection pooling but I have found many variations and no really solid examples. I'm pretty new to Java / Tomcat so I'm in search of suggestions and recommendations from more experienced individuals on the following topics: * How configure a JNDI resource (versus hardcoding the connection in the class - which is what I do now). I've tried this with some examples and have been unable to get it to work. * How can I implement connection pooling? Do I need to roll my own solution or is there a magical way to tap into Tomcat and allow it to manage the connection pool (latter is preferred). Config file and Java code examples would be very helpful as well. Also, keep in mind that even though the JVM is at 1.5, the product is compiled at 1.4 if that makes a difference. Thanks! Tony ________________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.paetec.com. ________________________________________________________________________ --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
