How does JDBC differ from ODBC?
Answers were Sorted based on User's Feedback
JDBC is the name of the protocol which is used to connect
to the database whereas ODBC is the mechanism that is used
to retrieve data from the database....JDBC is called the
protocol and ODBC the subprotocol...
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / guest
ODBC is the industry-standard interface by which database
clients connect to database servers.
JDBC is a pure Java solution that does not follow the ODBC
standard.
However, there is a bridge between JDBC and ODBC that allows
JDBC to access databases that support ODBC.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / d. kalaivani natarajan
JDBC is platform independent whereas ODBC is platform
dependent.
ODBC is used to connect any type of client with a server.
But JDBC is used to connect only java based clients to a
server. Anyway, JDBC requires ODBC for this.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / murali
JDBC technology is an api written in java,where as odbc is a
'c' interface written in c/c++ and cobol languages.
jdbc makes jdbcAPI calls
odbc tranforms jdbcAPI calls to odbc operations,these are
sent to database server.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / imtiyaz
ODBC is a layer which is designed to communicate with
different databases. when we give a command to odbc it
talks with the specific database in its language we need
not to worry about the database what we are communicating
Thats why it is called Opend Data Base Connectivity
JDBC is layer and it is having its own API which is having
the commands to communicate with database.
when we JDBCODBC Driver, this will take care of sending the
java commands which can understand by ODBC.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / devarathnam c,kotagudibanda(po
Hi...
JDBC: It is developed in pure java language.But ODBC
develop in C/C++ language using pointers,it is a microsoft
product.
| Is This Answer Correct ? | 2 Yes | 0 No |
jdbc is used to connecting the database through the java
language.but the odbc is common to all the database
connection.
| Is This Answer Correct ? | 0 Yes | 3 No |
What is SQL Warning? How to retrieve SQL warnings in the JDBC program?
What is PreparedStatement?
What is @entity in java?
Why do you use a data source object for a connection?
What is jdbc class forname?
What is a statement?
What are the higher level apis under development on top of jdbc currently?
How does a file store compare with a jdbc store?
what does the method Class.forName returns?
What is execute(), executeUpdate() and executeQuery() methods?
What are the advantages of using jdbc datasource?
What are the different types of 2 tier and 3 tier architecture ?