diffence between JDBC vs ODBC
Answers
Answer:
Definition of JDBC
Java Database Connectivity (JDBC) is an application programming interface i.e. (API). JDBC was released as a part of Java development Kit (JDK) 1.1. in the year 1996 by SUN Microsoft. It is built the basis of ODBC and hence, some basics of ODBC retain in JDBC.
Definition of ODBC
ODBC is Open Database Connectivity. Like JDBC, ODBC is also an API that acts as an interface between an application on the client side and the database on the server side. Microsoft introduced ODBC in the year 1992.
Explanation:
Key Differences Between JDBC and ODBC
1. The most basic difference between JDBC and ODBC is that JDBC is language and platform dependent. On the other hand, the ODBC is language and platform independent.
2. Java Database Connectivity is an acronym for JDBC, and on the other hand, Open Database Connectivity is an acronym for ODBC.
3.The code for ODBC is complex and is hard to learn. However, the code for JDBC is simpler and easy to run.
ODBC is an SQL-based Application Programming Interface (API) created by Microsoft that is used by Windows software applications to access databases via SQL.
JDBC is an SQL-based API created by Sun Microsystems to enable Java applications to use SQL for database access.