What is JDBC and ODBC and what are the differences between
them?

Answer Posted / preethi kumar

1.ODBC is for Microsoft and JDBC is for java applications.
2.ODBC can be directly used with Java because it uses a C
interface.
3.ODBC makes use of pointers which have been removed
totally from java.
4.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.
5.ODBC doesnt 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.
6. JDBC API is a natural Java Interface and is built on
ODBC. JDBC retains some of the basic feature of ODBC

Is This Answer Correct ?    89 Yes 43 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to connect to multiple databases simultaneously? Using single statement can one update or extract data from multiple databases?

518


What does setautocommit do?

548


Does jpa use jdbc?

483


How can we disable a constraint ?

557


Write an sql to find all records having all numeric characters in a field ?

484






What is the meaning of connection?

516


What are types of resultset?

553


What is the purpose of jdbc?

577


What are the different types of locking in JDBC?

562


Why we use while rs next ())?

520


What do you mean by batch processing in jdbc?

517


What are the higher level apis under development on top of jdbc currently?

483


What is thin driver in jdbc?

504


How can I instantiate and load a new CachedRowSet object from a non-JDBC source?

525


What is jdbc and odbc?

497