Explain the architecture of JDBC?

If you want to develop a Java application that communicates with a database, you should use JDBC API. A driver is the implementation of the said API; various vendors provide various drivers, you need to use a suitable driver with respect to the database you need to communicate with. The driver manager loads the driver and manages the driver.

Following are the components of JDBC:

• JDBC DriverManager: The DriverManager class of the java.sql package manages different types of JDBC drivers. This class loads the driver classes. In addition to this whenever a new connection establishes it chooses and loads the suitable driver from the previously loaded ones.

  Note: From JDBC 4.0 the drivers in the CLASSPATH will be loaded automatically.

• JDBC API: It is a Java abstraction which enables applications to communicate with relational databases. It provides two main packages namely, java.sql and javax.sql. It provides classes and methods to connect with a database, create statements (quires), execute statements and handle the results.

Krantik Chavan

Updated on 30-Jul-2019 22:30:25

• Related Questions & Answers
• Explain the architecture of DBMS?
• Explain the ODBC architecture?
• Explain the architecture of Java Swing in Java?
• Explain the performance of cache in computer architecture?
• Explain the stream architecture in .NET
• Explain the methods of reducing the number of microinstructions in computer architecture?
• Explain the three level schema architecture in DBMS?
• Explain Java Virtual Machine (JVM) Architecture
• Explain the difference between RowSet and ResultSet in JDBC?
• Explain the various DMA transfer modes in computer architecture?
• What is RowId object in JDBC Explain?
• What is JDBC SQL Escape Syntax Explain?
• What are save points in JDBC? Explain?
• What is CONCUR_UPDATABLE ResultSet in JDBC? Explain?
• What is CONCUR_READ_ONLY ResultSet in JDBC? Explain?