JDBC (Java Database Connectivity) is a standard Java API that provides a uniform interface for applications to connect and interact with relational databases. It consists of a set of classes and interfaces written in Java that standardize database operations like:
- Establishing connections
- Executing SQL queries
- Handling result sets
- Managing transactions
- Processing database metadata
JDBC drivers implement this API for specific database systems, allowing Java applications to be database-agnostic at the code level. The driver handles the translation between JDBC calls and database-specific protocol commands.
One really good source of JDBC drivers is the list used by DBeaver.
Common JDBC drivers
| Database | Driver URL |
|---|---|
| PostgreSQL | https://jdbc.postgresql.org/ |
| Oracle | https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html |
