JDBC driver 与 JDK version

一、如何获取JDBC的jar包？
    1.<ORACLE_HOME>/jdbc/lib
    2.http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
   
二、JDBC driver 版本 与 JDK版本的关系

 

From JDBC FAQ on Oracle Technology Network (OTN), the OCI or Thin JDBC drivers versions support the following Javasoft's JDK versions :

 

 

JDBC Version	JDK version**	JDBC File Name
11.2.0	1.6.x 1.5.x	ojdbc6.jar ojdbc5.jar
11.1.0	1.6.x 1.5.x	ojdbc6.jar ojdbc5.jar
10.2.0	1.2.x 1.3.x 1.4.x 1.5.x	classes12.jar classes12.jar ojdbc14.jar ojdbc14.jar
10.1.0	1.2.x 1.3.x 1.4.x	classes12.jar classes12.jar ojdbc14.jar
9.2.0	1.1.x 1.2.x 1.3.x 1.4.x	classes111.zip* classes12.zip* classes12.zip* ojdbc14.jar

 

 

 

三、JDBC driver与数据库版本的兼容性

 

Backward Compatibility
The JDBC drivers are certified to work with the currently supported versions of Oracle
Database. For example, the JDBC Thin drivers in Oracle Database 11g Release 1 (11.1)
are certified to work with the 10.2.x, 10.1.x, 9.2.x, and 9.0.1.x Oracle Database releases.
However, they are not certified to work with older, unsupported database releases,
such as 8.0.x and 7.x.

 

Forward Compatibility
Existing and supported JDBC drivers are certified to work with Oracle Database 11g
Release 1 (11.1).
Although the main features will work it can happen that new features of a database version
cannot be used by older drivers. Therefore, it is recommended to use at least the same version
for the JDBC Driver as the version of the database

oracle还是推荐使用和数据库版本相同的JDBC Driver