com microsoft sqlserver jdbc SQLServerDriver not found error

Question

I am trying to connect to my SQL Server 2008 database from Java and I m having the same problem from this thread   String userName    xxxx   String password    xxxx   String url    jdbc sqlserver xxx xxx xxx xxx databaseName asdfzxcvqwer integratedSecurity true   Class forName  com microsoft sqlserver jdbc SQLServerDriver    connection   DriverManager getConnection url  userName  password     I keep getting a ClassNotFoundException Whenever I try to load the driver from Class forName  com microsoft sqlserver jdbc SQLServerDriver     java lang ClassNotFoundException  com microsoft sqlserver jdbc SQLServerDriver     at org apache catalina loader WebappClassLoader loadClass WebappClassLoader java 1713      at org apache catalina loader WebappClassLoader loadClass WebappClassLoader java 1558      at java lang Class forName0 Native Method      at java lang Class forName Unknown Source      at repositories RepositoryBase  lt init gt  RepositoryBase java 22      at repositories ProductsRepository  lt init gt  ProductsRepository java 13      at api Products init Products java 31      at javax servlet GenericServlet init GenericServlet java 160      at org apache catalina core StandardWrapper initServlet StandardWrapper java 1280      at org apache catalina core StandardWrapper loadServlet StandardWrapper java 1193      at org apache catalina core StandardWrapper allocate StandardWrapper java 865      at org apache catalina core StandardWrapperValve invoke StandardWrapperValve java 136      at org apache catalina core StandardContextValve invoke StandardContextValve java 123      at org apache catalina authenticator AuthenticatorBase invoke AuthenticatorBase java 472      at org apache catalina core StandardHostValve invoke StandardHostValve java 171      at org apache catalina valves ErrorReportValve invoke ErrorReportValve java 99      at org apache catalina valves AccessLogValve invoke AccessLogValve java 936      at org apache catalina core StandardEngineValve invoke StandardEngineValve java 118      at org apache catalina connector CoyoteAdapter service CoyoteAdapter java 407      at org apache coyote http11 AbstractHttp11Processor process AbstractHttp11Processor java 1004      at org apache coyote AbstractProtocol AbstractConnectionHandler process AbstractProtocol java 589      at org apache tomcat util net JIoEndpoint SocketProcessor run JIoEndpoint java 312      at java util concurrent ThreadPoolExecutor runWorker Unknown Source      at java util concurrent ThreadPoolExecutor Worker run Unknown Source      at java lang Thread run Unknown Source    I ve made sure the necessary jdbc and jtds drivers are added to the library and CLASSPATH is set as well  I m honestly not sure what went wrong here   Edit  Upon suggestion  I tried to download this jdbc jar and place it in my WEB-INF lib  then set my CLASSPATH variable to that location  Still  the same problem is happening   Edit2  Never mind  completely reinstalling Eclipse made it work  This is pretty frustrating

User · Answer

here is your answer  String userName    xxxx       String password    xxxx       String url    jdbc sqlserver xxx xxx xxx xxx databaseName asdfzxcvqwer integratedSecurity true        try               Class forName  com microsoft sqlserver jdbc SQLServerDriver                connection   DriverManager getConnection url  userName  password         catch  Exception e           e printStackTrace

User · Answer

You dont need both jTDS and JDBC in your classpath  Any one is required  Here you need only sqljdbc jar   Also  I would suggest to place sqljdbc jar at physical location to  WEB-INF lib directory of your project rather than adding it in the Classpath via IDE  Then Tomcat takes care the rest  And also try restarting Tomcat   You can download Jar from   www java2s com Code JarDownload sqlserverjdbc sqlserverjdbc jar zip  EDIT   As you are supplying Username and Password when connecting    You need only jdbc sqlserver   localhost 1433 databaseName test  Skip integratedSecurity attribute

User · Answer

For me  it worked once I changed  Class forName  com microsoft sqlserver jdbc SQLServerDriver      to   in POM   lt dependency gt       lt groupId gt com microsoft sqlserver lt  groupId gt       lt artifactId gt mssql-jdbc lt  artifactId gt       lt version gt 6 1 0 jre8 lt  version gt   lt  dependency gt    and then   import com microsoft sqlserver jdbc SQLServerDriver         DriverManager registerDriver SQLServerDriver         Connection connection   DriverManager getConnection connectionUrl

User · Answer

public static final String URL    jdbc sqlserver   localhost 1433 databaseName dbName   public static final String USERNAME    xxxx   public static final String PASSWORD    xxxx            This method      param args     command line argument    public static void main String   args       try              Connection connection          DriverManager registerDriver new com microsoft sqlserver jdbc SQLServerDriver                connection   DriverManager getConnection MainDriver URL MainDriver USERNAME                          MainDriver PASSWORD           String query   select   from employee           Statement statement   connection createStatement            ResultSet resultSet   statement executeQuery query           while resultSet next                          System out print  First Name      resultSet getString  first name                 System out println    Last Name      resultSet getString  last name                                   catch Exception ex               ex printStackTrace

User · Answer

intellij idea 2019   Download Microsoft JDBC Driver for SQL Server    https   docs microsoft com en-us sql connect jdbc download-microsoft-jdbc-driver-for-sql-server view sql-server-2017    Unpack   C  opt sqljdbc 7 2 enu mssql-jdbc-7 2 2 jre11 jar   Add   File- Project Structure- Global Libraries  Use   Adding Jar files to IntellijIdea classpath  look video    import com microsoft sqlserver jdbc SQLServerDriver   https   youtu be -2hjxoRKsyk   or ub Gradle set  compile      compile group   com microsoft sqlserver   name   mssql-jdbc   version   7 2 2 jre11

User · Answer

You are looking at sqljdbc4 2 version like     Class forName  com microsoft sqlserver jdbc SQLServerDriver      but  for sqljdbc4 version statement should be   Class forName  com microsoft jdbc sqlserver SQLServerDriver        I think if you change your first version to write the correct Class forName   your application will run

User · Answer

For me it worked after manually copying the sqljdbc4-2 jar into WEB-INF lib folder  So please have a try on this too

User · Answer

For me it was a wrong maven dependency deceleration  so here is the correct way   for sqljdbc4 use  sqljdbc4 dependency   lt dependency gt       lt groupId gt com microsoft sqlserver lt  groupId gt       lt artifactId gt sqljdbc4 lt  artifactId gt       lt version gt 4 0 lt  version gt   lt  dependency gt    for sqljdbc42 use  sqljdbc42 dependency   lt dependency gt       lt groupId gt com microsoft sqlserver lt  groupId gt       lt artifactId gt sqljdbc42 lt  artifactId gt       lt version gt 6 0 8112 lt  version gt   lt  dependency gt

[java] com.microsoft.sqlserver.jdbc.SQLServerDriver not found error

Examples related to java

Examples related to sql-server

Examples related to eclipse

Examples related to jdbc