ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Tips--JDBC, JDK, and Oracle Database Certification and Availability FAQs(ZT)

Tips--JDBC, JDK, and Oracle Database Certification and Availability FAQs(ZT)

原创 Linux操作系统 作者:vongates 时间:2019-03-12 21:36:06 0 删除 编辑
PURPOSE
-------
This articles discusses JDBC, JDK, and Oracle database certified configurations. Frequently asked questions are addressed also.

SCOPE & APPLICATION
-------------------

This article is intended for system analysts, developers, and administrators.


JDBC, JDK, and Oracle Database Certification and Availability FAQs
-------------------------------------------------

Q1: Which JDK version goes with which driver version?
A1: JDK and JDBC Certification Matrix

JDK Driver File Name JDBC Version
--- ---------------- ------------

1.1 classes111.zip 7.3.4 -
1.2 classes12.zip 8.1.6 -
1.3 classes12.zip 9.2 -
1.4 ojdbc14.zip 9.2 -
1.5 ojdbc14.zip 10.2 (not 10.1)


Q2: Which JDBC driver version is certified to connect to which database version?
A2: JDBC and Oracle Database Certification Matrix

JDBC --> Oracle DB
------------------

10g JDBC Backward Compatibility
===============================

The Oracle JDBC drivers are certified to work with currently-supported versions
of the database. For example:

The 10g Release 1 (10.1) JDBC drivers are certified to work with 10.0.x, 9.2.x,
and 8.1.7.x database releases.

The 9.2 Oracle JDBC drivers are certified to work with 9.2.x and 8.1.7 database
releases.

The 9.2 Oracle JDBC drivers are not certified to work with older, unsupported
database releases, such as 8.0.x and 7.x.


8i/9i JDBC Forward Compatibility to 10g Database
================================================

Existing supported JDBC drivers (8.1.7.4 and 9.2.0.4 JDBC drivers) are
certified to work against Oracle Database 10g; known limitations will be
documented.

You can find a complete, up-to-date list of supported databases at
http://metalink.oracle.com.


8i/9i JDBC Backward Compatibility
=================================

JDBC Thin drivers are certified to work with supported (previous) versions of
the database. A complete list of supported databases can be found on
http://metalink.oracle.com under the Certify and Availability section.

For example, 9.2 JDBC Thin drivers are certified to work with 9.2.x, 9.0.1.x,
and 8.1.7 database releases. 9.2 JDBC Thin drivers are not certified to work
with older, unsupported database releases such as 8.0.x and 7.x.


8i/9i JDBC Forward Compatibility to 9i Database
==================================================

The 8i/9i JDBC product does not certify forward compatibility to 9i version of
the database. However, newer versions of Oracle's products (9iAS, for example)
may choose to certify with older JDBC client side drivers depending on business
need. Users should consult product specific documentation for (forward)
compatibility information.



Q3: Which client JDK version goes with which Oracle database version?
A3: The client JDK version and the Oracle database version are not directly
related. See questions 1 and 2 above.


Q4: Does a classes13.zip exist?
A4: No. Use classes12.zip instead. This have been certified with JDK 1.3 for JDBC
releases 8.1.7 and higher.


Q5: Where can you get the Oracle JDBC driver?
A5: The drivers can be obtained from two locations:

- http://otn.oracle.com
- Oracle Enterprise Edition (client) installation disk


Q6: Is JDBC 3.0 supported?
A6: JDBC 9.2 provides significant support for JDBC 3.0, complete
JDBC 3.0 support is expected by 10i.


Q7: Is JDK 1.3 supported?
A7: Yes with JDBC version 9.2.0 and higher using classes12.zip driver file.


Q8: Where do you find the JDBC thin driver on various platforms? (I only see downloads
for Solaris and NT on OTN.)
A8: Because the JDBC Thin driver is platform independent, you can download and use
the Solaris distribution and use it on any UNIX OS. Likewise, the Windows
download can be used on any Windows OS. Oracle recommends using the latest JDBC
Thin driver available as it is backwards compatible to previous Oracle database
versions, as long as the database version itself is still supported.


Q9: What drivers types exist for Oracle?
A9: Oracle supplies 3 driver types:

JDBC Thin Driver
----------------

The Oracle JDBC Thin driver is a 'Type IV' (native protocol, 100% Pure
Java) implementation. The JDBC Thin driver uses Java Sockets to connect
directly to the Oracle Server, and is typically used for Java applets in
either a two-tier or three-tier configuration, though it can also be used
for Java applications.

The JDBC Thin driver provides its own implementation of a TCP/IP version of
Oracle's SQL*Net/Net8. Because it is written entirely in Java, this driver is
platform-independent. When the JDBC Thin driver is used with an applet,
the client browser must have the capability to support Java sockets.

The JDBC Thin driver does not require Oracle software on the client side;
it can be downloaded into a browser simultaneously with the Java applet
being run. From the client (usually a browser), you select a URL from an
HTML page that contains a Java applet tag. The applet archive must include
the appropriate JDBC class files. The Web Server downloads the Java applet
and the JDBC Thin driver to the client. The JDBC Thin driver then
establishes a direct connection to the database server using Java Sockets.


JDBC OCI Driver
---------------

Oracle's JDBC OCI driver provides a 'Type II' (native-API, partly Java)
implementation of the JDBC interfaces using OCI (Oracle Call Interface) to
interact with an Oracle database.

Because the JDBC OCI driver uses native methods to call C entry points in
the OCI library, it is platform-specific. It also requires an Oracle client
installation including Net8.

Because the JDBC OCI driver interfaces to Oracle databases through OCI, it
is compatible with all Oracle database versions, and supports all installed
Net8 adapters, including IPC, named pipes, TCP/IP, and SPX/IPX among
others.

Because the JDBC OCI driver contains C code, it is not suitable for use in
applets. However, it is an excellent choice for Java applications or Java
middle tiers such as the Oracle Application Server. The JDBC OCI driver can
be used in the following configurations:

* with a Java application running on a client machine in a two-tier
configuration

* with a Java application running on a middle tier in a three-tier
configuration

* with a Java servlet running on a middle tier in a three-tier
configuration


JDBC Server Driver (KPRB)
-------------------------

Oracle's JDBC Server driver is for server-side use only. The JDBC Server
driver is built into Oracle JServer, Oracle9i's tightly integrated server
side-Java engine. The JDBC server driver can be used with any Java program
running in Oracle9i that needs to access the SQL engine--such as Java stored
procedures.

The JDBC Server driver allows Java programs running in Oracle9i to access
SQL and PL/SQL by using JDBC. This driver possesses the same features and
extensions as the client-side drivers.


Q10: Where can I get driver for V734 of Oracle? (I do not see this version available
from OTN.)
A10: From the Oracle Enterprise Edition (7.3.4) installation disk. However,
Oracle no longer distributes this release.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29987/viewspace-52010/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2018-09-11

  • 博文量
    449
  • 访问量
    292694