One reason to use WEB-INF\lib is if you plan on distributing your app or deploying it to a different system, it's easier to move \webapps\<app>\* than to worry about lots of little jars in common...
----- Original Message ----- From: "Peng Tuck Kwok" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 10:31 PM Subject: Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue > Uhm michael, you need to decide where you want to put the jars in the > first place, if you want the driver available to all webapps then you > put it there. If you just want it for your webapp then you can put it > into the lib directory. I'm not sure if it will cause major problems but > it's best to put it in one place at one time first. > Also please check your spelling for your driver in the jsp code, you may > have mispelled it and caused it to look for something else. > > > > > Michael Ni wrote: > > > > ive copied to my > > C:\Tomcat 4.1\webapps\ROOT\WEB-INF\lib > > C:\Tomcat 4.1\common\lib > > and it still doesn't work. > > > > has anyone actually got their scripts to query from SQL Server 2000 > > using the Microsoft SQL Server 2000 JDBC Driver? seems like sun > > products never work with microsofts > > > > michael ni > > > > > > > >> From: "Galbayar Dorjgotov" <[EMAIL PROTECTED]> > >> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> > >> To: "Tomcat Users List" <[EMAIL PROTECTED]> > >> Subject: RE: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue > >> Date: Tue, 25 Feb 2003 11:15:44 +0800 > >> > >> copy common\lib directory > >> > >> -----Original Message----- > >> From: Michael Ni [mailto:[EMAIL PROTECTED] > >> Sent: Tuesday, February 25, 2003 10:32 AM > >> To: [EMAIL PROTECTED] > >> Subject: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue > >> > >> > >> My goal is to use JSP to query from my Microsoft SQL Server 2000. > >> > >> I have successfully created my environments and installed the drivers for > >> the Microsoft SQL Server 2000 JDBC. > >> > >> However when i run my script i get the following error > >> > >> Driver not found:java.lang.ClassNotFoundException: > >> com.microsoft.jdbc.sqlserver.SQLServerDrivercom.microsoft.jdbc.sqlserver.SQL > >> > >> ServerDriver > >> exception: java.sql.SQLException: No suitable driverNo suitable driver > >> > >> you can see for yourself at the following url > >> > >> http://128.91.107.144:8080/test/home.jsp > >> > >> I attached my home.jsp page. Does tomcat need to have the microsoft > >> drivers > >> physically in the folder or subfolders of c:\Tomcat 4.1? All i did was > >> create the CLASSPATH which assigned CLASSPATH to the 3 jar driver files. > >> I've been stuck on this issue for 3 days. Can anyone help me? > >> > >> > >> > >> > >> > >> _________________________________________________________________ > >> MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > >> http://join.msn.com/?page=features/virus > >> > >> > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > _________________________________________________________________ > > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > > http://join.msn.com/?page=features/virus > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]