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 are the common jdbc exceptions?
What are the advantages of database connection pooling?
What is the use of callablestatement? Name the method, which is used to prepare a callablestatement.
What is jdbc odbc driver?
Differentiate between a statement and a preparedstatement.
What isolation level is used by the DBMS when inserting, updating and selecting rows from a database?
Name the types of jdbc drivers.
Why should we close database connections in java?
What does jdbc do?
Can we return resultset in java?
What is static Synchronized method in JDBC API? Give an example?
3 Answers 3 Edge Solutions, R Systems, Sirvisetti Global Services,
How we store procedure in oralce for callable statements in jdbc