Difference Between ODBC and JDBC

Usually the software applications are written in a specific programming language (like Java, C, etc.), While the databases can accept queries only in different database-specific language (like SQL). So when a software application is developed to access data in a database, an interface that can translate one language to another (the application and database) is required. Or else the application programmers need to learn and incorporate the database language specific to their applications. ODBC (the consistency of database open) and JDBC (Java consistency DatabBase) are two interfaces that solve this specific problem. ODBC is a platform, a language and operating system with an independent interface that can be used for serving this purpose. Similarly JDBC is an Application Program Interface for data for the programming language Java. Java programmers can use the bridge JDBC-to-ODBC to connect with any ODBC database accommodating.

What is ODBC?

ODBC is an interface to access management systems and database (DBMS). ODBC was developed by programmers of the SQL Access group in the year 1992 when there was no standard medium for communicating between a database and an application. It does not depend on a specific programming language or database system or operating system. Programmers can use the ODBC interface to write applications that can cast doubt on the data from any database, regardless of the environment it is prolonged or the type of DBMS it uses.

Because the ODBC the drivers in a device act as a translator between the application and the database, ODBC is able to perform as an independent platform and language. This means that the application is relieved of the burden to know the database specific language. Rather it will only use the syntax and ODBS and the driver will translate the query to the database in a language they can understand. So the results are rendered in a format that can be understood by the application. The ODBC API software can be used with both relational and non-systems relational database. Another important benefit of having ODBC as a universal middleware between an application and a database is that every time the changes occur in any specific database, the software does not need to be updated. Only one update of the driver ODBC would be sufficient.

What is JDBC?

JDBC is an API developed data for the programming language Java. This was released with JDK 1.1 from Sun Microsystems (the original owners of Java). And its current version is JDBC 4.0 (currently distributed with Java SE6). Java.sql and javax.sql packages contain the JDBC classes. This is an interface that helps a client to access a database, providing methods to question and update data in the databases. JDBC is more suitable for oriented databases object. You can access any ODBC database, using the accommodating bridge-to-JDBC ODBC.

What is the difference between ODBC and JDBC?

ODBC is an open interface that can be used by any application to communicate with any system database, while JDBC is an interface that can be used by Java applications to access databases. So, unlike JDBC, ODBC is language independent. But using JDBC-ODBC-to build a bridge over Java applications can also talk to any ODBC database accommodating.


Category: VS  |  Tags: