Component

Common JDBC Component:

• JDBC have following Component:

JDBC API - (java.sql, javax.sql)

• Provides access to a relational database (like Oracle, SQL server, MySQL, etc.) from java.
• Using JDBC API, frontend java application can execute query and fetch data from connected database.

Driver Manager:

• This class manages a list of database driver.
• JDBC driver Manager Interface defines 'objects' which are used to connect java application with different JDBC drivers.
• JDBC Driver manager loads the most appropriate driver among all the drivers for creating a connection.

JDBC test suite:

• JDBC test Suite is used to check capability of a JDBC driver with J2EE platform.
• JDBC-ODBC bridge:
• As the name suggests this enables JDBC access via ODBC drivers.
• The JDBC Driver contact to the ODBC Driver for connection ti the database.
• The ODBC driver is already installed or come as deafult driver in windows.