What is JDBC and ODBC and what are the differences between
them?
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
How does a custom RowSetReader get called from a CachedRowSet?
Does sql allow null values ? Can we use it within where clause ?
What does setautocommit do?
Does jdbctemplate use prepared statements?
Define preparedstatement.
What is jdbc connection string?
Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?
What does the jdbc resultsetmetadata interface?
What are types of jdbc drivers?
What is ODBC and JDBC? How do you connect the Database?
What are the steps required to execute a query in jdbc?
If I use the JDBC API, do I have to use ODBC underneath?
What is hbm xml?
Compare jdbc and odbc and how is jdbc required in this context.
How to set the attribute concurrency in resultset?