'checkng(or seeing) oracle jdbc driver(ojdbc.jar) version'에 해당되는 글 1건

  1. 2009.04.22 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 

'DB' 카테고리의 다른 글

MERGE INTO Statement  (0) 2009.04.25
오라클 Fast Connection Failover  (0) 2009.04.22
Dynamically creating table in ibatis  (0) 2009.04.21
오라클 10g jdbc driver 특징 중 Fast Connection Fail-Over  (0) 2009.04.10
오라클 메가진  (0) 2009.04.09
Posted by '김용환'
,