JDBC driver version of Oracle

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,

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,

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.

Oracle JDBC driver 8.1.7 released with Oracle 8i

Classes111.zip for JDK 1.1.x

Classes12.zip for JDK 1.2.x

Only zip files without jar files

Oracle JDBC driver 9.2.0 released with Oracle 9i

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 naming of the new jar file is ojdbc. . Jar format, the name of the previous jar file remains unchanged

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

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

Classes111.zip for JDK 1.1.x

Classes12.zip for JDK 1.2.x

Oracle JDBC driver 10.2 released with Oracle 10.2

1. Full support for JDK 1.5

2. Supports JDBC 3.0.

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.

Oracle JDBC driver 11.1 released with Oracle 11.1

New features:

1. JDK6 and JDBC 4.0 are supported. The new java. SQL. SQLXML type is not supported and is supported by ojdbc6.jar. J2SE 5.0 and JDBC 3.0 fully support the use of ojdbc5.jar.

2. oracle. jdbc. driver is no longer supported. Oracle. jdbc is recommended for each release starting from 9.0.1. This day has finally arrived. In 11g, oracle. jdbc. driver references are no longer compiled.

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 algorithms, SHA1 hash algorithms, RADIUS, KERBEROS, and SSL authentication mechanisms.

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.

Ojdbc5.jar: Applicable to JDK 5

Ojdbc6.jar: Applicable to JDK 6

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

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

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.