Need of JDBC:
JDBC makes it possible to do establish a connection with a data source, send queries and update statements, and process the results. Establish a connection with a data source. Send queries and update statements to the data source.
Java Database Connectivity ( JDBC ) is an application programming interface (API) for the programming language Java, which defines how a client may access a database. It is part of the Java Standard Edition platform, from Oracle Corporation. It is a Java-based data access technology used for Java database connectivity.
We can use JDBC API to access tabular data stored in any relational database. With the help of JDBC API, we can save, update, delete and fetch data from the database. It is like Open Database Connectivity ( ODBC ) provided by Microsoft.
Types of JDBC Drivers:
- JDBC-ODBC Bridge Driver:
- It allows applications java to use the JDBC API with many existing ODBC drivers.
- Native Driver:
- This driver converts JDBC method calls into native calls of the database API.
- Network Protocol Driver:
- It uses an application server that converts JDBC calls directly or indirectly into the vendor-specific database protocol.
- Thin Driver:
- It is platform-independent and does not require any additional Oracle software on the client-side.