File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes class path for  ms sqlserver database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "class path for  ms sqlserver database" Watch "class path for  ms sqlserver database" New topic

class path for ms sqlserver database

Anil Jain
Ranch Hand

Joined: Mar 10, 2002
Posts: 51
I downloaded the jdbc driver for mssql 2000. I set the system classpath for these .jar files. But when I compiled my servlet, it gives me followig error:
cannot resove symbol Class Connection,DriverManager.
Please advise on this.

Anil Jain<br />Sun Certified Java(2) Programmer
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

You'll probably find this is a problem with the location of your JAR and not specfically JDBC-related.
Depending on the App-server you are using, you need to put the JAR somewhere it can be seen by the web-app. Without going into the specifics (you can get the whole story if you do a search in this or the Servlet forums) web apps manage their own classpaths, they ignore the one you set on the system.
For example, if you are running tomcat, the easiest place to put it is the [ TOMCAT_HOME]/server/lib directory
I agree. Here's the link:
subject: class path for ms sqlserver database
It's not a secret anymore!