1.

What is JDBC driver?

Answer»

JDBC driver is a software component having various classes and interfaces, that enables the Java application to interact with a database.

To connect with INDIVIDUAL databases, JDBC requires PARTICULAR drivers for each specific database. These drivers are provided by the database vendor in addition to the database. For example:

  • MYSQL Connector/J is the official JDBC driver for MySQL and we can locate the mysql-connector-java-<version>-bin.jar file among the installed files. On windows, this file can be obtained at
C:\Program Files (x86)\MySQL\MySQL Connector J\mysql-connector-java-5.1.30-bin.jar.
  • JDBC driver of Oracle 10G is ojdbc14.jar and it can be obtained in the installation directory of an Oracle at …/Oracle/app/oracle/product/10.2.0/server/jdbc/lib .

JDBC driver provides the connection to the database. Also, it implements the PROTOCOL for sending the query and result between client and database.


Discussion

No Comment Found

Related InterviewSolutions