ShowJdbcDrivers.java - sqljdbc JDBC Driver Example

Q

How to verify if sqljdbc JDBC Driver is loaded corrected from the classpath? I want to see a Java program example.

✍: FYIcenter.com

A

Here is an example program, ShowJdbcDrivers.java, that can be used to verify if sqljdbc JDBC Driver is loaded corrected from the classpath or not:

// Copyright (c) 2016 FYIcenter.com
import java.sql.DriverManager;
import java.sql.Driver;
import java.util.Enumeration;

// Example show all JDBC drivers loaded in the classpath
public class ShowJdbcDrivers {
   public static void main(String [] args) throws Exception {
      System.out.println("Loaded JDBC driver classes:");
      for (Enumeration<Driver> drivers=DriverManager.getDrivers(); 
         drivers.hasMoreElements(); ) {
         System.out.println(drivers.nextElement().getClass().getName());
      }
   }
}

You can compile and run the above example in a command window. You should see sqljdbc JDBC driver class listed in the output:

C:\fyicenter>\local\jdk-1.8.0\bin\javac 
   ShowJdbcDrivers.java

C:\fyicenter>\local\jdk-1.8.0\bin\java
   -cp .;C:\local\sqljdbc_6.0\enu\sqljdbc42.jar 
   ShowJdbcDrivers

Loaded JDBC driver classes:
com.microsoft.sqlserver.jdbc.SQLServerDriver   

If you run the example again with a typo in the classpath, you will not see the sqljdbc JDBC driver class in the output:

C:\fyicenter>\local\jdk-1.8.0\bin\java
   -cp .;C:\local\sqljdbc_6.0\enu\sqljdbc-4.2.jar 
   ShowJdbcDrivers
   
Loaded JDBC driver classes:

If you run the example in JDK 1.8 with sqljdbc.jar in the classpath, you will not see the sqljdbc JDBC driver class in the output. This shows that sqljdbc.jar is not compatible with JDK 1.8.

C:\fyicenter>\local\jdk-1.8.0\bin\java
   -cp .;C:\local\sqljdbc_6.0\enu\sqljdbc.jar 
   ShowJdbcDrivers
   
Loaded JDBC driver classes:

 

Examples for sqljdbc - JDBC Driver for SQL Server

⇒⇒FAQ for sqljdbc - JDBC Driver for SQL Server

2017-01-05, 196👍, 0💬