What is JDBC and ODBC and what are the differences between
them?
Answer Posted / vaibhav kansal
Difference between JDBC and ODBC?
a)OBDC is for Microsoft and JDBC is for Java applications.
b)ODBC can't be directly used with Java because it uses a C interface.
c)OBC makes use of pointers which have been removed totally from Java.
d)ODBC mixes simple and advanced features together and has complex options for simple queries. But JDBC is designed to keep things simple while allowing advanced capabilities when required.
e)ODBC requires manual installation of the ODBC driver manager and driver on all client machines. JDBC drivers are written in Java and JDBC code is automatically installable, secure, and portable on all platforms.
f)JDBC API is a natural Java interface and is built on ODBC. JDBC retains some of the basic features of ODBC.
Is This Answer Correct ? | 35 Yes | 11 No |
Post New Answer View All Answers
What is the use of dialect?
How can I get information about foreign keys used in a table?
What is an advantage of using the jdbc connection pool?
How to invoke Oracle Stored Procedure with Database Objects as IN/OUT?
Does jdbctemplate close connection?
What is java soft framework?
What do you mean by metadata and why we are using it?
What are types of resultset?
What is a java driver?
What happens if we don't close the connection in jdbc?
Is not bound in this context unable to find jdbc spring boot?
Why “no suitable driver” error occurs?
What is the return type of class.forname() method?
What is batch processing and how to perform batch processing in jdbc?
Compare jdbc and odbc and how is jdbc required in this context.