JDBC的版本和Oracle Driver的版本怎样对应？

Question

JDBC的版本和Oracle Driver的版本怎样对应？比如JDBC4.0有个新特性，不需要类加载驱动。怎样知道JDBC的版本、JDBC的版本和Oracle Driver的对应关系？

Answer 1

上面列的就是你要的驱动的对应关系。或者你可以这样理解驱动与oracle的主版本号一样。 oracle数据安主目录中有一个叫jdbc的目录，里面有driver。 ojdbc6是jdk1.6用，ojdbc5是jdk1.5用。 用压缩工具打开，META-INF/MANIFEST.MF中 Implementation-Version: 11.2.0.1.0就是你要的jdbc版本号

Answer 2

回复
非常感谢您的耐心回答。不过有一点要纠正，Implementation-Version对应的是Oracle的版本，如11.2.0.1.0，Specification-Version: 4.0这个才是JDBC版本。

Answer 3

Which JDBC drivers support which versions of JDBC?

Oracle 9.0.1 supports:

• JDBC 2.0 Extensions except for:
• using both global and local transactions on the same connection.

Oracle 9.2.0 supports:

• Partial support for JDBC 3.0:
• transaction savepoints
• using both global and local transactions on the same connection.

Oracle 10.1.0 supports:

• Full support for JDBC 3.0 except for:
• retrieving auto-generated keys
• result-set holdability
• returning multiple result-sets.

Oracle 10.2.0 supports:

• Full support for JDBC 3.0 
  Note that there is no real change in the support for the following in the database. All that has changed is that some methods that previously threw SQLException now do something more reasonable instead.
• result-set holdability
• returning multiple result-sets.

Oracle 11.1.0 and 11.2.0 support:

Full support for JDBC 3.0 in the JDK 1.5 drivers. 

Full support for JDBC 4.0 in the JDK 1.6 drivers with the exception of SQLXML which is not supported.

Answer 4

Which JDBC drivers support which versions of JDBC?

Oracle 9.0.1 supports:

• JDBC 2.0 Extensions except for:
• using both global and local transactions on the same connection.

Oracle 9.2.0 supports:

• Partial support for JDBC 3.0:
• transaction savepoints
• using both global and local transactions on the same connection.

Oracle 10.1.0 supports:

• Full support for JDBC 3.0 except for:
• retrieving auto-generated keys
• result-set holdability
• returning multiple result-sets.

Oracle 10.2.0 supports:

• Full support for JDBC 3.0 
  Note that there is no real change in the support for the following in the database. All that has changed is that some methods that previously threw SQLException now do something more reasonable instead.
• result-set holdability
• returning multiple result-sets.

Oracle 11.1.0 and 11.2.0 support:

Full support for JDBC 3.0 in the JDK 1.5 drivers. 

Full support for JDBC 4.0 in the JDK 1.6 drivers with the exception of SQLXML which is not supported.