First, the JDBC Driver by Microsoft is old. It's free, but its old. It doesn't support JDBC 3.0. If you are trying to implement a production solution, you are better off with a third-party driver. There are only 3 or 4 out there that are robust and stable enough for serious production use, you can find links to them on the Sun site.
Second, as far as I know, the Tyrex included with Tomcat is broken, though I may be wrong. You want to use DBCP from the Jakarta Commons project (search the list archives for a HOWTO), roll your own, or use any of the other freely available pooling solutions out there (poolman, etc). Or use the pool that comes with the third-party driver. Third, don't use Tomcat 4.1.2 for anything. I can't imagine that is a stable release. You are better off dropping back to 4.0.4, or at least moving up to 4.1.10, though 4.1.10 still has a few issues. If you are targeting deployment, I would recommend 4.0.4, though others will probably disagree. Fourth, a tip: putting "URGENT" in your subject line will more than likely cause more people to ignore your post rather than answer it. This is a free mailing list, and the product it supports is free. The people on the list are under no obligation to help you in any way, shape, or form, least of all as a priority just because of something in the subject line. Many of us have been "burned" by spending a lot of time and effort helping someone who insisted that they needed help right away, only to find out later that the help was wasted or that the "urgent" situation wasn't really urgent in the first place. You will get a better response by using a subject line like "Connection pool recommendations for SQL Server" or something similar. Not criticizing you, just a tip. John > -----Original Message----- > From: Amitabh Dubey [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 22, 2002 11:07 PM > To: [EMAIL PROTECTED] > Subject: URGENT: SQL Server and Tomct 4.1 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]>
