Shulou(Shulou.com)06/02 Report--

This article mainly explains the "what is the difference between OJDBC versions", the content of the explanation is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "what is the difference between OJDBC versions"!

OJDBC version differences

Connection type:

1. JDBC OCI: oci is an abbreviation for oracle call interface, which is similar to the traditional ODBC driver. Because it needs Oracle Call Interface and Net8, it needs to install the client software on the machine running the JAVA program using this driver, which mainly uses the oci and server configuration provided by dll in the orcale client.

2. JDBC Thin: thin means for thin client, and this driver is generally used in JAVA programs running in WEB browsers. It is not through OCI or Net8, but through Java sockets communication, is a pure java driver, so there is no need to install orcale client software on client machines that use JDBC Thin, so it has good portability and is usually used in web development.

Version 8.1.7 of Oracle JDBC driver released with Oracle 8i

Classes111.zip for JDK 1.1.x

Classes12.zip is suitable for JDK 1.2.x

Only zip files, no jar files.

Version 9.2.0 of Oracle JDBC driver released with Oracle 9i

Classes111.jar for JDK 1.1.x

Classes12.jar is suitable for JDK 1.2 and JDK 1.3 (my project environment JDK1.6,oracle 10g and JDK windows, using this so far no problems have been found)

Ojdbc14.jar is suitable for JDK 1.4

Classes111.zip for JDK 1.1.x

Classes12.zip is suitable for JDK 1.2.x

* * _ g.jar is only compiled with javac-g to generate all debugging information, everything else is the same

What's new:

1. Drivers of Thin connection types provide direct support for BFILE,BLOB,CLOB, which was usually implemented by calling PL/SQL in the past.

2. Support JDBC 3.0 features

3. Ojdbc14.jar supports JDK 1.4.

4. Ojdbc14.jar supports SavePoint (Savepoint)

5. PreparedStatement can be used in different connection pools, which is an important performance improvement

From then on, the name of the new jar file is in ojdbc.jar format, and the name of the previous jar file remains the same.

Oracle JDBC driver version 10.2 released with Oracle 10.2

Classes12.jar is suitable for JDK 1.2 and JDK 1.3.

Ojdbc14.jar for JDK 1.4 and 5.0

* * _ g.jar is only compiled with javac-g to generate all debugging information, everything else is the same

Features:

1. Fully support JDK 1.5

2. JDBC 3.0 is supported.

Oracle JDBC driver version 11.1 released with Oracle 11.1

Ojdbc5.jar: for jdk5

Ojdbc6.jar: for jdk6 (if you use jdk1.5, you can't use this driver)

* * _ g.jar is only compiled with javac-g to generate all debugging information, everything else is the same

What's new:

1. Ojdbc6.jar: supports JDK6 and JDBC 4.0. the new java.sql.SQLXML type is not supported.

Ojdbc5.jar: full support for JDK5 and JDBC 3.0.

2. It is recommended to use the oracle.jdbc.OracleDriver class, not oracle.jdbc.driver.OracleDriver. Oracle.jdbc is recommended for every release starting from 9.0.1.

3. J2se 1.2 is no longer supported by 1.3 and 1.4. 11R1 no longer includes these versions of jar and zip, and if you still use these versions, you can continue to use 10gR2's jdbc.

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

5. ANYDATE and ANYTYPE types are supported. These two types have been introduced since 9i. Before 11R1, programmers could only operate through PL/SQL.

6. Advanced queue support. 11R1 provides a high-performance interface to access AQ.

7. Database change notification is supported.

8. The database of Thin and OCI starts and shuts down. 11R1 provides such a way to start and shut down 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 and so on.

Thank you for your reading, the above is the content of "what is the difference between OJDBC versions". After the study of this article, I believe you have a deeper understanding of the difference between OJDBC versions, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.