java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Question

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

I got the above exception when i trying to deploying my Application into tomcat. but the weird thing is , i tried with a simple main method and it's works fine. Any help please ???

I did the following:

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String connectionUrl = "jdbc:microsoft:sqlserver://localhost:1433;" + "database=DBName;" + "user=UserName;" + "password=Password";
connection = DriverManager.getConnection(connectionUrl);

I think that the JDBC driver is not in the classpath. What are you using to build your project? — Krystian Lieber
– Krystian Lieber, Commented Mar 14, 2013 at 20:28
Look at one of the other hundred questions about this on this site. I just commented on another one just a minute ago. — Sotirios Delimanolis
– Sotirios Delimanolis, Commented Mar 14, 2013 at 20:28

Asaph · Accepted Answer · 2013-03-14 20:29:15Z

10

You need to add the jar file containing the class com.microsoft.sqlserver.jdbc.SQLServerDriver to your war file's WEB-INF/lib folder.

answered Mar 14, 2013 at 20:29

Asaph

163k25 gold badges204 silver badges204 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Krystian Lieber · Accepted Answer · 2013-03-14 20:33:57Z

3

Read Tomcat Documentation about classpath for clarification or just put the sqljdbc.jar in $CATALINA_HOME/lib to access it from all your applications.

answered Mar 14, 2013 at 20:33

Krystian Lieber

4813 silver badges10 bronze badges

Comments

Govardhan Chary · Accepted Answer · 2014-01-07 12:36:58Z

2

Eventhough you have JAR(sqlserverjdbc.jar) in build path You need to add the jar file containing the class. com.microsoft.sqlserver.jdbc.SQLServerDriver to your war file's WEB-INF/lib folder.

answered Jan 7, 2014 at 12:36

Govardhan Chary

211 bronze badge

Comments

oraclesoon · Accepted Answer · 2014-05-15 09:17:50Z

May 15, 2014 3:09:43 PM org.apache.tomcat.jdbc.pool.ConnectionPool init SEVERE: Unable to create initial connections of pool. java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerDriver at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:254) at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182) at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701) at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635) ...

It is quite puzzling because my web application has WEB-INF/lib/sqljdbc4.jar.

From the error message, somehow the jar file is required by Tomcat too.

After I copy the jar file to CATALINA_HOME/lib/sqljdbc4.jar, the error is gone.

Tyrone Hed · Accepted Answer · 2015-03-04 20:01:30Z

0

Since you're running a web app, you need to have the MS SQL Server driver--or the driver for any DB--stored in two places. Inside the app that becomes your WAR and then you need a second copy that is stored in the App Server's LIB directory. So, if you're running on Tomcat then you would put it /opt/tomcat/lib or C:\DEV\tomcat7\lib.

answered Mar 4, 2015 at 20:01

Tyrone Hed

11 bronze badge

Comments

Supercoder · Accepted Answer · 2023-10-12 19:44:54Z

0

I just had the same error running one of my java App from eclipse after uninstalled and re-installed tomcat. I had to create a new Apache Tomcat Runtime from my Project.

From Eclipse Properties > Project Facets > Runtimes as per the following screenshot:

Note: Also, make sure you have a copy of the jdbc jar file into your tomcat library. For example into: C:\Program Files\Apache Software Foundation\Tomcat 9.0\lib\mssql-jdbc-8.4.0.jre11.jar

Enjoy!

answered Oct 12, 2023 at 19:44

Supercoder

1,2241 gold badge15 silver badges20 bronze badges

Collectives™ on Stack Overflow

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related