JDBC - How to find Oracle Driver Version

[Hari Krishna Varma Gadiraju]

Is there way what oracle driver version my java code is using?

I would like to know if my code is using the oracle8i / 9i JDBC Driver.

[Balazs Borbely]

look into the driver jar file
in META-INF\MANIFEST.MF

[stu derby]

The DatabaseMetaData class will tell you.

import java.sql.*;
public class dbinfo
{
  public static void main (String arr[]) throws Exception
  {
    String dbDriver="oracle.jdbc.driver.OracleDriver";
    String dbURL = "jdbc:oracle:thin:@test-db:1521:testsid";
    String dbPW = "my_password";
    String dbUser = "my_username";
 
    Connection con = null;
    Class.forName(dbDriver);
 
    con = DriverManager.getConnection (dbURL, dbUser, dbPW);
    con.setAutoCommit(false);
 
    DatabaseMetaData dbmd = con.getMetaData();
 
    System.out.println("=====  Database info =====");
    System.out.println("DatabaseProductName: " + dbmd.getDatabaseProductName() );
    System.out.println("DatabaseProductVersion: " + dbmd.getDatabaseProductVersion() );
    System.out.println("DatabaseMajorVersion: " + dbmd.getDatabaseMajorVersion() );
    System.out.println("DatabaseMinorVersion: " + dbmd.getDatabaseMinorVersion() );
    System.out.println("=====  Driver info =====");
    System.out.println("DriverName: " + dbmd.getDriverName() );
    System.out.println("DriverVersion: " + dbmd.getDriverVersion() );
    System.out.println("DriverMajorVersion: " + dbmd.getDriverMajorVersion() );
    System.out.println("DriverMinorVersion: " + dbmd.getDriverMinorVersion() );
    System.out.println("=====  JDBC/DB attributes =====");
    System.out.print("Supports getGeneratedKeys(): ");
    if (dbmd.supportsGetGeneratedKeys() )
      System.out.println("true");
    else
      System.out.println("false");

    pstmt.close();
    con.close();
  }

}

[ March 24, 2006: Message edited by: stu derby ]