ShowJdbcDrivers.java - jTDS JDBC Driver Example

Q

How to verify if jTDS 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 jTDS 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 as shown below:

C:\fyicenter>\local\jdk-1.8.0\bin\javac 
   -cp C:\local\jtds-1.3.1\jtds-1.3.1.jar 
   ShowJdbcDrivers.java

C:\fyicenter>\local\jdk-1.8.0\bin\java
   -cp .;C:\local\jtds-1.3.1\jtds-1.3.1.jar 
   ShowJdbcDrivers

Loaded JDBC driver classes:
net.sourceforge.jtds.jdbc.Driver

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

C:\fyicenter>\local\jdk-1.8.0\bin\java
   -cp .;C:\local\jtds-1.3.1\jtds-1.3.l.jar 
   ShowJdbcDrivers

Loaded JDBC driver classes:

By the way, the typo is in the jTDS JDBC driver JAR file name. It should be "jtds-1.3.1.jar" instead of "jtds-1.3.l.jar".

 

Examples for jTDS - JDBC Driver for SQL Server

⇒⇒FAQ for jTDS - JDBC Driver for SQL Server

2017-02-03, 697👍, 0💬