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

Answer Posted / manjesh

ODBC is open database connectivity. The goal of ODBC is to
make it possible to access any data from any application,
regardless of which database management system (DBMS) is
handling the data so it is language independent


JDBC is Java Database Connectivity. It enables java programs
to execute sql statements. JDBC makes it possible to write a
single database application that can run on different
platforms and interact with different DBMS. JDBC is language
dependent i.e it is used only to make connectivity with
java.

.*ODBC is language -independent&JDBC is language-dependent.

Is This Answer Correct ?    37 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which interface handles transaction management in jdbc?

572


What is jdbc servlet?

504


Why do we use jdbc in java?

550


What is the difference between setmaxrows(int) and setfetchsize(int)?

568


Explain in detail about JDBC and its general features?

533






What is JDBC Statement?

569


what happen if we set JDBC string to NULL?

2951


Why prepared statements are faster?

533


What is jdbc connection string?

509


Write an sql to find all records having all upper case alphanumeric characters in a field ?

531


What are the differences between resultset and rowset?

530


Is jdbctemplate thread safe?

488


How many categories of jdbc drivers are there?

489


Why do we need jdbc?

582


Why are we using blob datatypes in jdbc?

556