OJDBC version difference [difference between Ojdbc14.jar,ojdbc5.jar and Ojdbc6.jar]

Source: Internet
Author: User
Tags sha1 hash sha1 hash algorithm
Differences between Classes12.jar,ojdbc14.jar,ojdbc5.jar and Ojdbc6.jar, the difference between

When using Oracle JDBC drivers, there are some issues that you can solve by replacing different versions of Oracle JDBC drivers. Most commonly used Ojdbc14.jar have multiple versions, Classes12.jar have multiple versions you know.

Connection Type:
1. JDBC OCI:OCI is an abbreviation for 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 a machine that is running the Java program using this driver, essentially using the OCI and server configuration provided in the Orcale client as a DLL.
2, JDBC Thin:thin is for Thin client meaning, this kind of drive is used in the Java program that runs in the Web browser generally. Rather than using the OCI or NET8, it communicates through the Java sockets and is driven by a pure Java implementation, so there is no need to install Orcale client software on a client machine that uses JDBC thin, so it is very portable and typically used in web development.


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


Oracle JDBC Driver 9.2.0 release with Oracle 9i

Classes111.jar applies to JDK 1.1.x
Classes12.jar applies to JDK 1.2 and JDK 1.3 (my project Environment Jdk1.6,oracle 10g,windows, which is not currently identified)
Ojdbc14.jar applies to JDK 1.4
Classes111.zip applies to JDK 1.1.x
Classes12.zip applies to JDK 1.2.x

_g.jar only compiles with javac-g, generates all debugging information, all the same

New features:
1. The Thin connection type driver provides direct support for Bfile,blob,clob, which was usually implemented by invoking Pl/sql.
2. Support JDBC 3.0 Features
3, Ojdbc14.jar support JDK 1.4
4, Ojdbc14.jar support save Point (SavePoint)
5, you can use PreparedStatement in different connection pool, this is an important performance improvement

The new jar file is named after the OJDBC<JDK Ver>.jar format, and the previous jar file name is unchanged


Oracle JDBC Driver version 10.2 released with Oracle 10.2

Classes12.jar applies to JDK 1.2 and JDK 1.3.

Ojdbc14.jar applies to JDK 1.4 and 5.0
_g.jar only compiles with javac-g, generates all debugging information, all the same


1. Full support 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: Apply to JDK6 (if you use jdk1.5, you can't use this driver)
_g.jar only compiles with javac-g, generates all debugging information, all the same

New features:
1, Ojdbc6.jar: Support JDK6, support JDBC 4.0, new Java.sql.SQLXML type is not supported.

Ojdbc5.jar: Full support for using JDK5 and JDBC 3.0.
2, 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 from 9.0.1.

3, J2SE 1.2,1.3,1.4 no longer support. 11R1 no longer includes these versions of Jars 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. 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, support the database change notice.
8, thin and OCI database startup and shutdown. 11R1 provides such a way to start and close a database.
9, the new factory method. 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.


Generally speaking, the new version of JDBC driver performance is strong, many bugs are found and resolved.

I encountered, before the use of Ojdbc14.jar (do not remember which version of) batch insert 100,000, the actual only inserted more than 30,000, the other lost, after Ojdbc6.jar, a commit batch insert 1 million also OK.

Try to use the same driver as the database version, and when there are bugs, replace the JDBC driver with a higher version.

If a JDBC jar package you do not know is that version of, you can extract this jar package, and then meta-inf\manifest. MF file to find "Oracle JDBC Driver version-" Words, you know the version.

Original address: http://tiantian0521.blog.163.com/blog/static/4172088320117294265766/

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.