I guess some advice is better than none.
Have you checked out the Jakarta Commons DBCP pooling solution like I recommended? Here's a link to how it was done with MySQL: http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2 Have you checked out third-party SQL Server drivers? The drivers I am familiar with have fully-functional trial periods and they not only support pooling but also JDBC 3.0. Have you checked out open source pooling solutions besides DBCP, like poolman? John > -----Original Message----- > From: Amitabh Dubey [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 23, 2002 10:39 AM > To: Tomcat Users List > Subject: RE: Tomcat Connection pooling > > > John, you are the only one who replied, and hence i took your > advice and > changed my subject and am reposting it. hopefully someone > with an actual > example of pooling with sql server can help me. > > Amitabh > > -----Original Message----- > From: Turner, John [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 23, 2002 9:37 AM > To: 'Tomcat Users List' > Subject: RE: Tomcat Connection pooling > > > > Check your message list threads. I already replied to this post this > morning! Perhaps others have as well. > > John > > > > -----Original Message----- > > From: Amitabh Dubey [mailto:[EMAIL PROTECTED]] > > Sent: Monday, September 23, 2002 10:33 AM > > To: Tomcat > > Subject: Tomcat Connection pooling > > > > > > Hello Guys, > > I have been working on this problem for 3 days now and > > have not been able > > to make Tomcat create a connection pool for me. This is my setup > > > > Database - SQL Server 2000 > > Driver - JDBC Driver by microsoft > > Tomcat - 4.1.2 (Packaged as part of JWSDK from SUN) > > > > I was able to successfully create and use connections using a > > DataSource. > > However, I want to use connection pooling and have no idea of > > how I can do > > so. If there is anyone who has been successful in creating a > > DataSource > > using a Connection pool with SQL Server, please could you > > either send me a > > snippet of your server.xml or tell me how i can go about > > achieving pooling. > > > > Also, do i need Tyrex if i want to use connection pooling. I > > have downloaded > > it from their website anyways and placed in my > > tomcat\common\lib directory. > > How do i go about using this pool manager if this i what i > > have to use with > > tomcat to achieve pooling. > > > > Please HELP!! > > > > Thank you > > Amitabh Dubey > > > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>