Differences between Oracle Database driver packages ojdbc *. Jar

 

 

 Classes12.jar, ojdbc14.jar, ojdbc5.jar, and ojdbc6.jar are different. When using the oracle JDBC driver, are you sure you want to replace the oracle JDBC driver of different versions? 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 run the JavaProgramIn fact, the client software is mainly used in the orcale client to provide the OCI and server configuration in DLL mode. 2 JDBC thin: thin is the meaning of for thin client. This type of driver 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 released with Oracle 8i 8. 1.7 classes111.zip for JDK 1.1 .Xclasses12.zip for JDK 1.2 . X only has ZIP files and jar files. ------------------------------------------------------------------------------- Oracle JDBC driver released with Oracle 9i 9. 2 . 0 classes111.jar for JDK 1.1 . Xclasses12.jar for JDK 1.2 and JDK 1.3 (my project environment jdk1.6 , Oracle 10g, windows, with this currently no problem found) ojdbc14.jar for JDK 1.4 Classes111.zip for JDK 1.1 .Xclasses12.zip for JDK 1.2. X * ** _ G. Jar only uses javac- Compile g to generate all debugging information. other new features are the same: 1. Drivers of the thin connection type provide direct support for bfile, blob, and clob. Previously, they usually call PL/ SQL. 2. Supports JDBC 3.0. Features 3. ojdbc14.jar supports JDK 1.44. , Ojdbc14.jar supports savepoint) 5 Preparedstatement can be used in different connection pools. This is an important performance improvement. From then on, the new JAR file name will be ojdbc. <JDK ver> . Jar format, the name of the previous JAR file remains unchanged ------------------------------------------------------------------------------- With Oracle 10 . 2 release of oracle JDBC driver 10.2 classes12.jar for JDK 1.2 and JDK 1.3 . Ojdbc14.jar for JDK 1.4 and 5.0 *** _ g. Jar only uses javac- Compile g to generate all debugging information. Other features are the same: 1. Full support for JDK 1.52 and JDBC 3.0 ------------------------------------------------------------------------------- With Oracle 11 . 1 released oracle JDBC driver version 11.1 ojdbc5.jar: For jdk5ojdbc6. jar: For jdk6 (if you use jdk1. 5 You cannot use this driver) * ** _ G. Jar only uses javac- Compile g to generate all debugging information. other new features are the same: 1. ojdbc6.jar: supports JDK 6 and JDBC 4.0. The new java. SQL. SQLXML type is not supported. Ojdbc5.jar: fully supports the use of jdk5 and JDBC 3.0 . 2. Oracle. JDBC. oracledriver is recommended. Oracle. JDBC. Driver. oracledriver is not recommended. From 9.0 Oracle. JDBC is recommended for each release at the beginning of. 1. 3. j2se 1.2, 1.3, 1 . 4 is 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 EncryptionAlgorithm, Sha1 hash algorithm, radius, Kerberos, SSL authentication mechanism. 5. The anydate and anytype types are supported. These two types of models are introduced from 9i. Before 11r1, programmers can only use PL/ SQL operation. 6 And advanced queue support. 11r1 provides a high-performance interface for accessing aq. 7 And supports Database Change notifications. 8 , Thin, and OCI databases are enabled and disabled. 11r1 provides this method to start and close the database. 9And 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 -Find "oracle JDBC driver version-10.1.0.2.0" in the INF \ manifest. MF file and you will know the version.