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

java.sql.SQLException: No suitable driver establish for 
There are 2 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 agree amongst the JDBC driver acquaint inward the CLASSPATH. Many programmers who normally role jtds.jar, makes a error piece using sqljdbc4.jar past times adding "microsoft" inward JDBC URL. That makes URL invalid together with JDBC API throws "java.sql.SQLException: No suitable driver : sqljdbc4.jar" error.


For Example inward JTDS, the JDBC URL format is

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

together with piece 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 likewise known every bit sub-protocol. All other parameters e.g. serverName, instanceName, together with portNumber is optional. If you lot don't render serverName therefore SQL server volition expect into properties collection, if an instance is non specified therefore JDBC volition connect to default instance together with if the port number is non specified therefore it volition connect to default SQL Server port number 1433.

Common reasons of "No suitable driver found" Error

Let's come across only about of the most mutual reasons for getting java.sql.SQLException: No suitable driver establish for jdbc: error piece 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 inward CLASSPATH. In this case, you lot volition acquire next error :

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

In gild to solve this error, only add together jtds.jar inward CLASSPATH of your Java application. If you lot don't receive got jtds.jar, you lot tin download it from here. Alternatively, you lot tin likewise add together next Maven dependency, if you lot are using Maven to create your projection :

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

If you lot already receive got this JAR file inward your CLASSPATH but nonetheless getting inward a higher house error, peradventure it's fourth dimension to revisit your CLASSPATH settings. See Core Java, Volume II--Advanced Features past times Cay S. Horstmann to acquire to a greater extent than most 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", piece using sqljdbc4.jar file to connect MSSQL database. This volition number inward the next exception :

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

In gild to create this error only take microsoft from URL. Correct JDBC URL format to connect SQL SERVER is "jdbc:sqlserver://localhost:1433";.  No involve to worry most CLASSPATH, because if the SQLJDBC4.jar is non acquaint therefore it volition hand you lot a dissimilar error, something similar java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver.


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

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

Solving this error is easy, only right the spelling inward JDBC URL together with you lot are done.

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

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

In gild to solve that error, only take jTDS driver together with add together Microsoft JDBC driver i.e. sqljdbc4.jar inward your project's create path.


That's all most how to solve java.sql.SQLException: No suitable driver establish for jdbc: XXX error inward Java. The root elbow grease of this work is wrong JDBC URL, by together with large the protocol business office is incorrect. This is non only a Microsoft SQL SERVER specific error but tin come upward piece connecting to whatsoever 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 inward Java :

• Practical database programming amongst Java past times Ying Bai (book)
• JDBC Recipes: 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

Sumber https://javarevisited.blogspot.com/

Share this post