Four types of JDBC drivers

Source: Internet
Author: User

After downloading the JDBC driver on the internet, I often see Type4 as the vendor's standard. Recently, I have reviewed the data and it turns out to be the JDBC standard defined by SUN.

Type 1 JDBC-ODBC Bridge
Later than JDK, it is part of the sun. jdbc. odbc package.
Application ---> JDBC-ODBC Bridge (Type1 jdbc driver) ----> JDBC-ODBC Library ---> ODBC Driver --> Database
It is suitable for fast prototype systems and does not provide JDBC-driven databases such as access (a favorite of small websites)

Type2 JAVA to Native API
Use the local database provided by the developer to directly communicate with the database.
Application ---> JDBC Driver (Type2 jdbc driver) ----> Native Database library ----> Database
The performance is slightly better than that of type1.

Type3 Java to net
Application ---> Jdbc Driver (Type3 jdbc driver) -----> java middleware ---> JDBC Driver ----> Database
It has the maximum flexibility, which is usually provided by non-database vendors and is the smallest of the four types.

Type4 JAVA to native dababase
Application ---> Jdbc driver (type4 jdbc driver) -----> database engine ---> database
With the highest performance, you can use your local protocol to directly communicate with the database engine and be able to assemble on the Internet.

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.