I guess we are talking about two different issues. I had the library in the classpath and in the common/lib too, but for some reason the pool won't work. Maybe the environment I'm using was different. I use Tomcat 4.1.12, SQL Server2000, Windows XP and the microsoft jdbc driver for SQL Server 2000. Either ways, I'm glad it worked and thought of posting just in case someone faces the same problem again!
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 1:30 PM To: [EMAIL PROTECTED] Subject: RE: Connection pool nightmare! I happened to have this problem long time ago. It is because my jdbc driver was not in the classpath. I didn't add it to classpath, instead, I placed Oracle JDBC classes12.jar in Tomcat's common/lib. Now everything works fine. Be aware, the file extension has to be jar not zip. My environment is Tomcat 4.1.12, Windows 2000 Pro/Red Hat 7.2 Server, Oracle 8i. Regards, PQ "This Guy Thinks He Knows Everything" "This Guy Thinks He Knows What He Is Doing" -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
