checkng(or seeing) oracle jdbc driver(ojdbc.jar) version

Oracle provides the various version of oracle jdbc driver to java developers. But, released jdbc drivers' name are always ojdbc14.jar.

If you try to run java to see manifest file, you may be failed.

$ java -jar ojdbc14.jar

Failed to load Main-Class manifest attribute from

ojdbc14.jar

So, to know those version. there are 2 measures to check it.

1) Unzip and see MANIFEST.MF in ojdbc14.jar

Manifest-Version: 1.0

Specification-Title: "Oracle JDBC driver classes for use with JDK1.4"

Specification-Version: "Oracle JDBC Driver version - 9.0.2.0.0"

Specification-Vendor: "Oracle Corporation" .

Implementation-Title: "ojdbc14.jar"

Implementation-Version: "Oracle JDBC Driver version - 9.0.2.0.0"

Implementation-Vendor: "Oracle Corporation"

Implementation-Time: "Thu Apr 25 23:14:02 2002"

2) Java coding

DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@123.345.321.121:231:SID","ID","PASS");

DatabaseMetaData meta = conn.getMetaData ();

System.out.println("Database Product Name : " + meta.getDatabaseProductName());

System.out.println("Database Product Version : " + meta.getDatabaseProductVersion());

System.out.println("JDBC Driver Name :" + meta.getDriverName());

System.out.println("JDBC Driver Version : " + meta.getDriverVersion());

3) From the ojdbc14.jar in oracle 11g, you can use below method to verify the version.

java –jar ojdbc6.jar

In result, there is need to know the version of ojdbc14.jar, you have to rename the name of jar like ojdbc14-10.0.2.jar. It is easy to understand