What is JDBC and ODBC and what are the differences between
them?
Answer Posted / vaibhav kansal
Difference between JDBC and ODBC?
a)OBDC is for Microsoft and JDBC is for Java applications.
b)ODBC can't be directly used with Java because it uses a C interface.
c)OBC makes use of pointers which have been removed totally from Java.
d)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.
e)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.
f)JDBC API is a natural Java interface and is built on ODBC. JDBC retains some of the basic features of ODBC.
| Is This Answer Correct ? | 35 Yes | 11 No |
Post New Answer View All Answers
Explain about the drive manager class working?
What is a JDBC 2.0 DataSource?
What are the types of statements in jdbc?
What is the query used to display all tables names in SQL Server (Query analyzer)?
What is a rollback in jdbc?
How do I load a database driver with JDBC 4.0 / Java 6?
What are the jdbc statements?
What is a connection string used for?
Which database is used with java?
Name the new features added in jdbc 4.0.
If I use the JDBC API, do I have to use ODBC underneath?
What is jsp and jdbc?
How to retrieve warnings in jdbc?
What do you understand by DDL and DML statements?
What does setautocommit do?