ansaurus

Question

ClassNotFoundException: com.microsoft.sqlserver.jdbc

Answer 1

+2 A:

Your driver class name is wrong. The exception text points to a package, not an actual driver class. And don't forget to restart Tomcat after changing the contents of various lib directories.

Edit: Your IDE might use different configuration than your deployed war. Or fail with the same exception silently but the driver itself was already loaded by other means - then the actual connection just works.

kd304 2009-06-22 19:39:21

thnks for feedbackWhat you mean by saying "Your driver class is wrong" - that driver works fine under IDE

kilonet 2009-06-22 19:45:09

Regardless of what your IDE is doing, "com.microsoft.sqlserver.jdbc" is not a driver class, it's a package.

skaffman 2009-06-22 19:48:34

I feel silly, but what conclusions I should draw from >>>"com.microsoft.sqlserver.jdbc" is not a driver class, it's a package

kilonet 2009-06-22 19:58:28

In general, if you see these kind of error messages, check your configuration for mistypes.

kd304 2009-06-22 20:04:59

Answer 2

+3 A:

The driver class is "com.microsoft.sqlserver.jdbc.SQLServerDriver". You've just missed the class name off the end.

skaffman 2009-06-22 19:41:53

I never remember the driver class names. These times I wish JDBC had automatic driver discovery.

kd304 2009-06-22 19:47:35

skaffman,I specified driver class in context.xml as following:driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"

kilonet 2009-06-22 19:49:45

please post the relevent part of your context.xml file.

skaffman 2009-06-22 19:50:50

kilonet 2009-06-22 19:55:16

For that configuration to work in the deployed version of your web application the JAR containing com.microsoft.sqlserver.jdbc.SQLServerDriver has to be in $CATALINA_HOME/lib

laz 2009-06-22 20:15:42

Answer 3

A:

blah... After reinstalling tomcat it worked just fine. As kd304 said - maybe it was configuration issue Thanks for your help

kilonet 2009-06-22 20:30:43

ansaurus

tags:

views:

answers:

ClassNotFoundException: com.microsoft.sqlserver.jdbc

related questions