tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ian Hunter" <ihun...@hunterweb.net>
Subject Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
Date Tue, 25 Feb 2003 03:29:35 GMT
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" <pengtuck@makmal.net>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
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" <galbayar@mobinet.mn>
> >> Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> >> To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> >> 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:mikeni123@hotmail.com]
> >> Sent: Tuesday, February 25, 2003 10:32 AM
> >> To: tomcat-user@jakarta.apache.org
> >> 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: tomcat-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
> >
> > _________________________________________________________________
> > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
> > http://join.msn.com/?page=features/virus
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message