If you put the jar file in {tomcat directory}\common\lib it will be available to all your web apps. Theres no need to play around with your CLASSPATH variable.
Tom > -----Original Message----- > From: Joe [mailto:[EMAIL PROTECTED] > Sent: 05 June 2003 08:43 > To: [EMAIL PROTECTED] > Subject: CLASSPATH setting in Windows with JDBC from mySQL > > > Hi all, does anyone know how I should set the Class Path Variable in > Windows in order for JSP to search for the library? > > I've already tried the following methods but it cannot find the driver > when I tried to load an jsp page: > > Method 1 > I've currently install the JDBC driver on my C:\mysql\JDBC\ > And have tried setting my classpath to point to that folder as below > > Set CLASSPATH=C:\mysql\JDBC\;. > > Method 2 > Copied mysql-connector-java-3.0.8-stable-bin.jar to > C:\j2sdk1.4.1_02\common\lib > And simply set my classpath=. > > Method 3 > Copied mysql-connector-java-3.0.8-stable-bin.jar to > C:\j2sdk1.4.1_02\jre\lib > And again set my classpath=. > > I've also tried setting my classpath to point specifically to the JDBC > driver but still, the page cannot find the driver. > > > The only method that works now is that I've copied > mysql-connector-java-3.0.8-stable-bin.jar to my > /webapps/testAPPS/WEB-INF/lib > > Using this method, which means I have a copy of > mysql-connector-java-3.0.8-stable-bin.jar in every docBase that I have > which I find is redundant. Is there any working solution that I can > simply set in using my CLASSPATH? Also, I have no problem setting it in > CLASSPATH in Linux but I dunno why it doesn't work in Windows. :-( Now > that is reason why I preferred Linux. > > Regards, > Joe > > > > > > > > > > I've tried a lot of combination and have copy > mysql-connector-java-3.0.8-stable-bin.jar to > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]