Oracle JDBC: Difference and distinction between driver versions, oraclejdbc

Oracle JDBC: Driver version differences and differences [go], oraclejdbc

Classes12.jar, ojdbc14.jar, ojdbc5.jar, and ojdbc6.jar

When using the Oracle JDBC driver, do you solve some problems by replacing different versions of the Oracle JDBC driver? The most commonly used ojdbc14.jar has multiple versions, and classes12.jar has multiple versions. Do you know that?

 

Connection Type:
1. jdbc oci: oci is the abbreviation of oracle call interface, which is similar to the traditional ODBC driver. Because it requires Oracle Call Interface and Net8, it needs to install the client software on the machine that runs the JAVA program using this driver, in fact, it mainly uses the oci and server configuration provided in dll mode in the orcale client.
2. JDBC Thin: thin is the meaning of for thin client, which is generally used in JAVA programs running in WEB browsers. It does not communicate through OCI or Net8, but through Java sockets, and is a pure java-implemented driver. Therefore, you do not need to install orcale client software on the client machine that uses JDBC Thin, therefore, it has good portability and is usually used in web development.

 

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

Released with Oracle 8iOracle JDBC driver version 8.1.7
Classes111.zip for JDK 1.1.x
Classes12.zip for JDK 1.2.x
Only zip files, no jar files.

 

 

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

Released with Oracle 9iOracle JDBC driver 9.2.0

 

Classes111.jar for JDK 1.1.x
Classes12.jar is applicable to JDK 1.2 and JDK 1.3 (my project environment is JDK1.6, oracle 10g, and windows. No problem is found when this is used)
Ojdbc14.jar for JDK 1.4
Classes111.zip for JDK 1.1.x
Classes12.zip for JDK 1.2.x

* ** _ G. jar is only compiled using javac-g to generate all debugging information.

 

 

New features:
1. The Thin connection Driver provides direct support for BFILE, BLOB, and CLOB. Previously, it was usually implemented by calling PL/SQL.
2. Support for JDBC 3.0 features
3. ojdbc14.jar supports JDK 1.4.
4. ojdbc14.jar supports Savepoint)
5. PreparedStatement can be used in different connection pools, which is an important performance improvement.

 

Since then, the names of new jar files are in the ojdbc <jdk ver>. jar format, and the names of previous jar files remain unchanged.
 

 

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

Released in Oracle 10.2Oracle JDBC driver Version 10.2
 

Classes12.jar is applicable to JDK 1.2 and JDK 1.3.

Ojdbc14.jar for JDK 1.4 and 5.0
* ** _ G. jar is only compiled using javac-g to generate all debugging information.

 

Features:

1. Full support for JDK 1.5
2. Supports JDBC 3.0.

 

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

Released in Oracle 11.1Oracle JDBC driver version 11.1

 

Ojdbc5.jar: Applicable to JDK 5
Ojdbc6.jar: Applicable to jdk6. (if you use jdk1.5, you cannot use this driver)
* ** _ G. jar is only compiled using javac-g to generate all debugging information.

 

 

 

 

New features:
1. ojdbc6.jar: JDK6 and JDBC 4.0 are supported. The new java. SQL. SQLXML type is not supported.

Ojdbc5.jar: JDK5 and JDBC 3.0 are fully supported.
2. oracle. jdbc. OracleDriver is recommended. oracle. jdbc. driver. OracleDriver is not recommended. Oracle. jdbc is recommended for each release starting from 9.0.1.

3. j2se 1.2, 1.3, and 1.4 are no longer supported. 11R1 does not include jar and zip of these versions. If you still use these versions, you can continue to use jdbc of 10gR2.
4. 11gR1 Thin driver supports AES encryption algorithm, SHA1 hash algorithm, RADIUS, KERBEROS, and SSL authentication mechanism.
5. The ANYDATE and ANYTYPE types are supported. These two types are introduced from 9i. Before 11R1, programmers can only operate through PL/SQL.
6. Advanced queue support. 11R1 provides a high-performance interface for accessing AQ.
7. Supports Database Change notifications.
8. Start and close the database of Thin and OCI. 11R1 provides this method to start and close the database.
9. New Factory methods. Oracle JDBC 11R1 oracle. jdbc. OracleConnection provides a factory method for creating Oracle Objects.
Including ARRAY, BFILE, DATE, INTERVALDS, NUMBER, STRUCT, TIME, TIMESTAMP, TIMESTAMP, etc.

 

 

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

In general, the new version of JDBC has high Driver Performance and many bugs have been found and solved.

I encountered a problem where I used ojdbc14.jar (which version I don't remember) to insert 0.1 million records in batches. Actually, I only inserted more than 30 thousand records, but I lost others. After I changed to ojdbc6.jar, it is OK to insert 1 million entries in batches at a time.

 

Try to use the same driver as the database version. If there is a bug, try another JDBC driver of a later version.

 

If you do not know the version of a jdbc jar package, you can decompress the jar package, and then META-INF \ MANIFEST. find "Oracle JDBC Driver version-10.1.0.2.0" in the MF file, and you will know the version.