When I ran my web application under Eclipse IDE everything worked fine. But when I exported my project into war-file and deployed in tomcat I've got following message:
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc
I've tried putting sqljdbc4.jar everywhere:
What I'am missing? Environment: tomcat 6.0.20, sql server 2005
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.
The driver class is "com.microsoft.sqlserver.jdbc.SQLServerDriver". You've just missed the class name off the end.
blah... After reinstalling tomcat it worked just fine. As kd304 said - maybe it was configuration issue Thanks for your help
