What is JDBC and ODBC and what are the differences between
them?
- 11 Answers
- 105246 Views
- Idbi Bank, Infosys, Infoview, TCS, I also Faced
- E-Mail Answers
Answer Posted / srilatha
*ODBC is for microsoft & JDBC is for java applications
* ODBC can't be directly used with java because it uses a c
interface.
*ODBC makes use of pointers which have been
removed totally from java.
*ODBC is procedural-oriented & JDBC is Object-Oriented
*ODBC is used to provide connection between front-end and
back-end.JDBC is used to provide connection between java
and database.
*ODBC is language -independent&JDBC is language-dependent.
*ODBC mixes simple & advanced features together and has
complex options for simple queries.JDBC is designed to keep
things simple while allowing advanced capabilities when
required.
*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.
| Is This Answer Correct ? | 38 Yes | 11 No |
Post New Answer View All Answers
Is jpa faster than jdbc?
What is the execute method in java?
How many types of statements are there in jdbc?
How to use JDBC API to call Stored Procedures?
How to use JDBC to connect Microsoft Access?
What is encrypted connection?
How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?
What is an escape syntax?
What are temp tables ?
How the JDBC application works?
How does jdbc driver work?
How MS-Access DB can be accessed over a network, using JDBC API?
What is resultset in jdbc with example?
What are the differences between resultset and rowset?
What is jdbc drivers in java?
