What is the difference between odbc and jdbc?

The differences between JDBC and ODBC are: 1. JDBC is more portable than ODBC; 2. The languages ​​used by the two are different. JDBC is used in Java programming, while ODBC is generally used in C/C programming.

The difference between JDBC and ODBC

JDBC has better portability than ODBC

Normally, after installing the ODBC driver, certain configurations are required before it can be used. The same configuration cannot be used between different database servers. That is to say, you need to configure it once you install it. But the same cannot be said for JDBC database drivers. If you use a JDBC database driver, you only need to select the appropriate JDBC database driver and no additional configuration is required. During the installation process, the JDBC database driver will complete the relevant configuration itself. For this reason, JDBC is more portable than ODBC.

JDBC is easier to understand and use than ODBC

The languages ​​used are different

JDBC is used in Java programming , ODBC is generally used in C/C programming. ODBC is not suitable for use in Java. To use ODBC in Java, you need to use a JDBC-ODBC bridge. It has many shortcomings and is generally not used. Java uses JDBC and the driver jar package implemented by the manufacturer to access the database.

For more related knowledge, please visit PHP Chinese website! !

The above is the detailed content of What is the difference between odbc and jdbc?. For more information, please follow other related articles on the PHP Chinese website!