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
What does executequery return in java?
How can we retrieve data from the resultset?
How many types of jdbc drivers are there?
How do I insert/update records with some of the columns having NULL value?
What is jdbc thin client in oracle?
How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?
Under what circumstances, that all four drivers are used?
What is the full form of jdbc?
What are the different types of interfaces in the api component?
Which type of driver provides jdbc access via one or more odbc drivers?
What are the jdbc statements?
Explain about Join?
What are the differences between stored procedure and functions?
What is the significance of DataBaseMetaData.tableIndexStatistics? How to obtain and use it?
Discuss the significances of jdbc.