JDBC Driver Class Not Found

Question

I have downloaded the Microsoft SQL Server JDBC Driver and I have added the two .jar files sqljdbc4 and sqljdbc to the Classpath. However, when a java program executes the command

Class.forName("com/microsoft/jdbc/sqlserver/SQLServerDriver");

the program still throws a ClassNotFoundException.  Are these the correct files and classnames that I should be referencing and is there any obvious steps that I appear to have missed?

Answer 1

Problem Solved:

The correct class name is:

com.microsoft.sqlserver.jdbc.SQLServerDriver

and must be accesssed from the sqljdbc4.jar file.

Answer 2

Hi,

    I have the same issue similar to above. My issue is I have three jar files(msutil.jar,mssqlserver.jar,msbase.jar) in web-inf\xxx\ directory. And when i was executing the below line in java

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

i was getting error like below

Driver Class Not Found
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
    at java.lang.ClassLoader.loadClassInternal(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at com.subex.sonus.util.DBConnection.<clinit>(DBConnection.java:63)
    at com.subex.sonus.operation.ARMSOperation.<init>(ARMSOperation.java:55)
    at com.subex.sonus.SonusServiceImpl.sonusUpload(SonusServiceImpl.java:29)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
    at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
    at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
    at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
    at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
    at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
    at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
    at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
    at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
    at java.lang.Thread.run(Unknown Source)

For your information i don't have that 3 jar files in my sql server installation directory.  Do i need to add the path of web-inf\xx to environment variable?

Can any body help me on the same.

Regards,

Vaithilingam.K