ShowJdbcDrivers.java - ojdbc Oracle Driver Example

Q

How to verify if ojdbc Oracle 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 ojdbc Oracle Driver is loaded corrected from the classpath or not:

// Copyright (c) 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 ojdbc Oracle 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 .;\fyicenter\Oracle-12.2.0.1\ojdbc8.jar 
   ShowJdbcDrivers

Loaded JDBC driver classes:
oracle.jdbc.OracleDriver

If you run the example again with a typo in the classpath, you will not see the ojdbc Oracle Driver class in the output:

C:\fyicenter>\local\jdk-1.8.0\bin\java 
   -cp .;\fyicenter\Oracle-12.2.0.1\ojdbc18.jar 
   ShowJdbcDrivers

Loaded JDBC driver classes:

 

Examples for ojdbc.jar - JDBC Driver for Oracle

⇒⇒FAQ for ojdbc.jar - JDBC Driver for Oracle

2018-03-13, 549👍, 0💬