Interested to Buy Any Domain ? << Click Here >> for more details...
What is JDBC and ODBC and what are the differences between
them?
- 11 Answers
- 108963 Views
- Idbi Bank, Infosys, Infoview, TCS, I also Faced
- E-Mail Answers
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
What is the difference between setmaxrows(int) and setfetchsize(int)?
What does the connection object represents?
How do we load the drivers?
What are the conditions applies to varchar variable, when using in procedures?
DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do?
What are the new features available in jdbc 4.0?
Can we have foreign key reference to a non primary key column ?
What is CLOB and BLOB datatypes in JDBC?
How many types of statements are there in jdbc?
What is setautocommit in jdbc?
How can I create a custom RowSetMetaData object from scratch?
What is JDBC Transaction Management and why do we need it?
What is the meaning of batch updates?
What is two-phase commit in the database?
What is the difference between execute, executeQuery, executeUpdate?
