Java.Sql.Sqlexception: No Suitable Driver Constitute For Jdbc:Jtds:Sqlserver - Drive As Well As Solution

java.sql.SQLException: No suitable driver constitute for 
There are ii ways to connect Microsoft SQL Server from Java program, either past times using Microsoft's official JDBC driver (sqljdbc4.jar), or past times using jTDS driver (jtds.jar). This error comes when your supplied database URL didn't tally amongst the JDBC driver acquaint inwards the CLASSPATH. Many programmers who commonly work jtds.jar, makes a error spell using sqljdbc4.jar past times adding "microsoft" inwards JDBC URL. That makes URL invalid together with JDBC API throws "java.sql.SQLException: No suitable driver : sqljdbc4.jar" error.


For Example inwards JTDS, the JDBC URL format is

jdbc:jtds:://[:][/][;=[;...]]

together with spell using Microsoft's JDBC driver, the URL format is :

jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

where jdbc:sqlserver string is mandatory because it's used to position JDBC drive. It is too known every bit sub-protocol. All other parameters e.g. serverName, instanceName, together with portNumber is optional. If yous don't render serverName together with thence SQL server volition await into properties collection, if an instance is non specified together with thence JDBC volition connect to default instance together with if the port set out is non specified together with thence it volition connect to default SQL Server port set out 1433.

Common reasons of "No suitable driver found" Error

Let's encounter merely about of the most mutual reasons for getting java.sql.SQLException: No suitable driver constitute for jdbc: error spell connecting to SQL SERVER 2008, 2012 together with 2014.

1) You are using JDBC URL format for jTDS driver (jdbc:jtds://localhost:1434";)  but deployed sqljdbc4.jar inwards CLASSPATH. In this case, yous volition acquire next error :

java.sql.SQLException: No suitable driver constitute for jdbc:jtds://localhost:1434     at java.sql.DriverManager.getConnection(Unknown Source)     at java.sql.DriverManager.getConnection(Unknown Source)

In social club to solve this error, merely add together jtds.jar inwards CLASSPATH of your Java application. If yous don't conduct keep jtds.jar, yous tin download it from here. Alternatively, yous tin too add together next Maven dependency, if yous are using Maven to create your projection :

<dependency>    <groupId>net.sourceforge.jtds</groupId>    <artifactId>jtds</artifactId>    <version>1.3.1</version> </dependency>

If yous already conduct keep this JAR file inwards your CLASSPATH but withal getting inwards a higher house error, mayhap it's fourth dimension to revisit your CLASSPATH settings. See Core Java, Volume II--Advanced Features past times Cay S. Horstmann to larn to a greater extent than virtually JDBC drivers together with URL.

2) Many junior programmer's brand error of including "microsoft" in JDBC URL for SQL SERVER similar  "jdbc:microsoft:sqlserver://localhost:1433", spell using sqljdbc4.jar file to connect MSSQL database. This volition effect inwards the next exception :

java.sql.SQLException: No suitable driver constitute for jdbc:microsoft:sqlserver://localhost:1433     at java.sql.DriverManager.getConnection(Unknown Source)     at java.sql.DriverManager.getConnection(Unknown Source)

In social club to cook this error merely withdraw microsoft from URL. Correct JDBC URL format to connect SQL SERVER is "jdbc:sqlserver://localhost:1433";.  No ask to worry virtually CLASSPATH, because if the SQLJDBC4.jar is non acquaint together with thence it volition laissez passer on yous a unlike error, something similar java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver.


3)  The 3rd mutual argue of No suitable driver constitute the error is spelling mistake. For example, if yous are using jTDS driver to connect SQL SERVER 2008 database but given JDBC URL similar "jdbc:jdts://localhost:1434". It's real hard to location that instead of writing "jtds", yous conduct keep written "jdts". I conduct keep seen this error many times, solely to realize later spending hours checking CLASSPATH settings.  You volition hold upwardly greeted amongst next error :

java.sql.SQLException: No suitable driver constitute for jdbc:jdts://localhost:1434     at java.sql.DriverManager.getConnection(Unknown Source)     at java.sql.DriverManager.getConnection(Unknown Source)

Solving this error is easy, merely right the spelling inwards JDBC URL together with yous are done.

4) The 4th argue for getting No suitable driver constitute an error spell connecting to MSSQL is specifying JDBC URL every bit "jdbc:sqlserver://localhost:1433" but deployed jTDS driver inwards application's CLASSPATH. This happens because many developers work jTDS driver inwards the evolution environs together with Microsoft JDBC driver (sqljdbc4.jar) inwards the production environment.

java.sql.SQLException: No suitable driver constitute for jdbc:sqlserver://localhost:1433     at java.sql.DriverManager.getConnection(Unknown Source)     at java.sql.DriverManager.getConnection(Unknown Source)

In social club to solve that error, merely withdraw jTDS driver together with add together Microsoft JDBC driver i.e. sqljdbc4.jar inwards your project's create path.


That's all virtually how to solve java.sql.SQLException: No suitable driver constitute for jdbc: XXX error inwards Java. The root motility of this job is wrong JDBC URL, to a greater extent than frequently than non the protocol purpose is incorrect. This is non merely a Microsoft SQL SERVER specific error but tin come upwardly spell connecting to whatever database e.g. MySQL using JDBC API. You must brand certain that JDBC URL is absolutely right every bit instructed past times driver manual.

Further Resources to Learn JDBC inwards Java :

• Practical database programming amongst Java past times Ying Bai (book)
• JDBC Recipes: Influenza A virus subtype H5N1 Problem-Solution Approach past times Mahmoud Parsian (book)
• Step past times Step Guide to connect MySQL database using JDBC API (guide)
• Java guide to connect Oracle 10g database using JDBC sparse driver (guide)
• Solving java.lang.classnotfoundexception sun.jdbc.odbc.jdbcodbcdriver [solution]
• Fixing java.lang.ClassNotFoundException: org.postgresql.Driver [solution]
• Solving java.lang.classnotfoundexception oracle.jdbc.driver.oracledriver [solution]
• Dealing with java.lang.ClassNotFoundException: com.mysql.jdbc.Driver [fix]

Further Learning
JSP, Servlets together with JDBC for Beginners: Build a Database App
Complete JDBC Programming Part 1 together with 2
Java Platform: Working amongst Databases Using JDBC

Share this post