Re: How to check if jdbc drier from any vendor is installed or not ?

From:

Rohit <will.u.tellmemore@gmail.com>

Newsgroups:

comp.lang.java.databases

Date:

Tue, 15 Sep 2009 08:48:12 -0700 (PDT)

Message-ID:

<159f8e23-8ed2-443b-8638-92115c6010dc@p15g2000vbl.googlegroups.com>

It's easy enough to specify drivers to the DriverManager via the
jdbc.drivers property and -classpath option. You can also enumerate the
known drivers [1].

Is there any command that I can use to get the list of all MS SQL jdbc
drivers on a system ?

<code>
import java.sql.*;
import java.util.*;

class DriveTest {
  public static void main (String args [])
    throws SQLException, ClassNotFoundException {
    System.out.println("Current JDBC Drivers: "
      + System.getProperty("jdbc.drivers"));
    Enumeration e = DriverManager.getDrivers();
    while (e.hasMoreElements()) {
      System.out.println(e.nextElement());
    }
  }}

</code>

<console>
$ make run
javac -cp .:/opt/h2/bin/h2.jar DriveTest.java
java -Djdbc.drivers=org.h2.Driver -cp .:/opt/h2/bin/h2.jar DriveTest
Current JDBC Drivers: org.h2.Driver
org.h2.Driver@3a328f
</console>

Does this print only what you specify on the command line above or it
also shows the other drivers installed on the system. In my case I do
not know what I am looking for. But need to find if there is _any_
JDBC driver for MS SQL installed. I do not know the name of the
driver.

I will try this code and see how it works on my systems.