Oracle Learning (eight) to start versions and their differences

1. The difference between Oracle's OCI Driver and Thin Driver

①JDBC OCI:OCI is the abbreviation for Oracle call interface, which is similar to the traditional ODBC driver. Because it requires the Oracle call Interface and NET8, it needs to install the client software on the machine running the Java program using this driver, in fact, using the OCI and server configuration provided by the Orcale client in DLL mode.

②jdbc Thin:thin is meant for the Thin client, which is typically used in Java programs that run in a Web browser. It is not through the OCI or NET8, but through the Java Sockets Communication, is a pure Java implementation of the driver, so there is no need to install Orcale client software on the client machine using JDBC thin, so there is good portability, usually used in web development.

2. Oracle JDBC Driver 8.1.7 Release with Oracle 8i (only zip file, no jar file)

Driver Package:

Classes111.zip for JDK 1.1.x

Classes12.zip for JDK 1.2.x

Oracle Official:

Http://www.oracle.com/technetwork/database/enterprise-edition/jdbc817-100207.html

3. Oracle JDBC Driver 9.2.0 Release with Oracle 9i

Driver Package:

Classes111.jar for JDK 1.1.x

Classes12.jar for JDK 1.2 and JDK 1.3 (my project Environment Jdk1.6,oracle 10g,windows, with which no problem is currently found)

Ojdbc14.jar for JDK 1.4

Classes111.zip for JDK 1.1.x

Classes12.zip for JDK 1.2.x

_g.jar just compiles with javac-g, generates all the debugging information, all the rest.

New features:

The driver for the ①thin connection type provides direct support for Bfile,blob,clob, which was previously typically called PL/SQL.

② supports JDBC 3.0 features

③ojdbc14.jar supports JDK 1.4

④ojdbc14.jar support SavePoint (savepoint)

⑤ can use PreparedStatement in different connection pools, which is an important performance boost

Since then the new jar file is named in OJDBC<JDK Ver>.jar format, the previous jar file name is unchanged

Oracle Official:

Http://www.oracle.com/technetwork/database/enterprise-edition/jdbc9201-092698.html

4. Oracle JDBC Driver 10.2 release with Oracle 10.2

Driver Package:

The Classes12.jar is available for JDK 1.2 and JDK 1.3.

Ojdbc14.jar for JDK 1.4 and 5.0

_g.jar just compiles with javac-g, generates all the debugging information, all the rest.

New features:

① full support for JDK 1.5

② supports JDBC 3.0

Oracle Official:

Http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html

5. Oracle JDBC Driver 11.1 release with Oracle 11.1

Driver Package:

Ojdbc5.jar: Suitable for Jdk5

Ojdbc6.jar: For JDK6 (If you use jdk1.5, you cannot use this driver)

_g.jar just compiles with javac-g, generates all the debugging information, all the rest.

New features:

①ojdbc6.jar: Support for JDK6, JDBC 4.0 supported, new Java.sql.SQLXML type not supported.
Ojdbc5.jar: Full support for using JDK5 and JDBC 3.0.

② recommends using the Oracle.jdbc.OracleDriver class, and it is not recommended to use Oracle.jdbc.driver.OracleDriver. ORACLE.JDBC is recommended for each release starting with 9.0.1.

③J2SE 1.2,1.3,1.4 no longer supported. 11R1 no longer includes these versions of the jar and zip, and if you still use these versions, you can continue to use 10GR2 jdbc.

④11GR1 Thin driver supports AES encryption algorithm, SHA1 hash algorithm, RADIUS, KERBEROS,SSL authentication mechanism.

⑤ supports anydate and anytype types. Both types are introduced from 9i, and programmers can only operate with PL/SQL before 11r1.

⑥ Advanced Queue Support. The 11R1 provides a high-performance interface for accessing AQ.

⑦ supports database change notifications.

⑧thin and OCI databases are started and closed. 11R1 provides such a way to start and close the database.

⑨ the new factory method. The Oracle JDBC 11R1 Oracle.jdbc.OracleConnection provides a factory method for creating Oracle objects. Includes array, BFILE, DATE, Intervalds, number, STRUCT, Time,timestamp,timestamp, and so on.

Oracle Learning (eight) to start versions and their differences