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


Please Help Members By Posting Answers For Below Questions

Which is better jpa or jdbc?

500


What is dburl?

573


What is the use of getGeneratedKeys() method in Statement?

527


What is jdbc stand for?

483


What causes the "No suitable driver" error?

532






What are the different classes through which JDBC represents statements?

503


any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.

1836


What does executeupdate return in jdbc?

503


What is namedparameterjdbctemplate?

494


What do you mean by two phase commits?

557


What is jdbc odbc bridge?

500


How can I retrieve a String or other object type without creating a new object each time?

574


What is SQL Warning? How to retrieve SQL warnings in the JDBC program?

538


What is jdbc connection class?

462


What are the factors that the jdbc driver performance depends upon?

518