Oracle JDBC: Driver version differences and distinctions [go]

Differences between Classes12.jar,ojdbc14.jar,ojdbc5.jar and Ojdbc6.jar, the difference between

When using the Oracle JDBC driver, are there some problems that you can solve by replacing different versions of the Oracle JDBC driver? There are multiple versions of the most commonly used ojdbc14.jar, and there are multiple versions of Classes12.jar, do you understand?

Connection type:
1. The 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.
2. JDBC Thin:thin is the meaning of the for Thin client, which is typically used in Java programs running 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.

-------------------------------------------------------------------------------

Oracle JDBC Driver 8.1.7 Release with Oracle 8i
Classes111.zip for JDK 1.1.x
Classes12.zip for JDK 1.2.x
Only zip files, no jar files.

-------------------------------------------------------------------------------

Oracle JDBC Driver 9.2.0 release with Oracle 9i

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:
1. The driver for thin connection type provides direct support for Bfile,blob,clob, which is usually done by calling PL/SQL.
2. Support for JDBC 3.0 features
3. Ojdbc14.jar support JDK 1.4
4, Ojdbc14.jar support save Point (SavePoint)
5. PreparedStatement can be used in different connection pools, which is an important performance improvement

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

-------------------------------------------------------------------------------

Oracle JDBC Driver version 10.2 released with Oracle 10.2

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.

Characteristics:

1. Full support for JDK 1.5
2, Support JDBC 3.0

-------------------------------------------------------------------------------

Oracle JDBC driver version 11.1 released with Oracle 11.1

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:
1, Ojdbc6.jar: Support JDK6, JDBC 4.0 support, new Java.sql.SQLXML type is not supported.

Ojdbc5.jar: Full support for using JDK5 and JDBC 3.0.
2, we recommend the use of Oracle.jdbc.OracleDriver class, do not recommend the use of Oracle.jdbc.driver.OracleDriver. ORACLE.JDBC is recommended for each release starting with 9.0.1.

3, J2SE 1.2,1.3,1.4 no longer support. 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.
4, 11gR1 Thin driver support AES encryption algorithm, SHA1 hash algorithm, RADIUS, KERBEROS,SSL authentication mechanism.
5, support anydate and anytype type. Both types are introduced from 9i, and programmers can only operate with PL/SQL before 11r1.
6, Advanced queue support. The 11R1 provides a high-performance interface for accessing AQ.
7, support database change notification.
8, thin and OCI database start-up and shutdown. 11R1 provides such a way to start and close the database.
9, 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.

---------------------------------------------------

Overall, the new version of JDBC driver performance is strong, many bugs have been found and resolved.

I met, before using Ojdbc14.jar (do not remember which version of the) BULK insert 100,000, actually only inserted more than 30,000, the other lost, change Ojdbc6.jar, a commit batch insert 1 million is OK.

Try to use a driver that is consistent with the database version, and when there is a bug, replace the newer version of the JDBC driver.

If a JDBC jar package you do not know is that version, you can unzip the jar package and then meta-inf\manifest. MF file to find the word "Oracle JDBC Driver version-10.1.0.2.0", we'll know the version.

Oracle JDBC: Driver version differences and distinctions [go]