| | | | | | Question Answer Tutorial - JAVA->JDBC | | | | | | Question: What is JAVA JDBC?
| | | Answer: Java JDBC is a java API to connect and execute que
ry with the database. JDBC API uses jdbc drivers/>to connect with the database.
| | | | | | | | | | | | Question: Why to use JDBC?
| | | Answer: Earlier to JDBC, ODBC API was API used to connect
and execute query with the database. But, ODBC API/>uses ODBC driver which is written in C language and&n
bsp;platform dependent & unsecured). This is reason/>why Java has defined its own API (i.e. JDBC API)
;that uses JDBC drivers which is written in Java/>language and is platform independent
| | | | | | | | | | | | Question: What is JDBC Driver?
| | | Answer: JDBC Driver is a software component that enables java a
pplication to interact with the database./>There are 4 types of JDBC drivers available:/> a.) JDBC-ODBC bridge driver/> b.) Native-API driver (partially java driver)/> c.) Network Protocol driver (fully java driver)/> d.) Thin driver (fully java driver)
| | | | | | | | | | | | | Question: What is JDBC-ODBC bridge driver?
| | | Answer: The JDBC-ODBC bridge driver uses ODBC driver to connect
;to the database. The JDBC-ODBC bridge driver/>converts JDBC method calls into the ODBC method calls.&nbs
p;This is now discouraged because of thindriver/>Advantages of using JDBC-ODBC driver:/> a.) easy to use/> b.) can be easily connected to any database/> Disadvantages of using JDBC-ODBC driver:/> a.) Performance degraded because JDBC method call is
;converted into the ODBC method calls/> b.) The ODBC driver needs to be installed on th
e client machine
| | | | | | | | | | | | Question: What is Native-API driver?
| | | Answer: The Native API driver uses the client-side libraries of
;the database. The driver converts JDBC/>method calls into native calls of the database API. I
t is not written entirely in java/>Advantage of using Native-API driver:/> - Performance upgraded than JDBC-ODBC bridge driver/> Disadvantage of using Native-API driver:/> a.) The Native driver needs to be installed on
the each client machine/> b.) The Vendor client library needs to be installed&
nbsp;on client machine
| | | | | | | | | | |
| | | | | |