i'm developing java app, works fine in eclipse program not run apache tomcat 7.0 because cannot find sqlserver driver.
this app suppose connect sqlserver 2005 database, not past class.forname("com.microsoft.sqlserver.jdbc.sqlserverdriver")
, on server side.
i know it's line because found:
java.lang.classnotfoundexception: com.microsoft.sqlserver.jdbc.sqlserverdriver
in log file. placed sqljdbc.jar
in every catalinahome/lib
, catalinahome/shared/lib
, , web-inf/lib
.
i edited catalina.properties
reads shared/lib
folder.
i'm out of ideas, awesome!
update #1 - problem solved
i manually included .class files war file , works.
catalina_home/lib should work. have restarted tomcat after though?
and sql driver needs dlls, it seems. have them setup correctly? visible error may still classnotfound because if class fails initialize statically, viewed class not found @ all.
before deploying driver tomcat, make small local test - standalone java class loads driver , tries connect. may point issue more clearly.
Comments
Post a Comment