Baeldung

Java, Spring and Web Development tutorials

JDBC Series
2026-05-04 07:42 UTC by baeldung

JDBC (Java Database Connectivity) is the foundational API for relational database access in Java, sitting beneath all higher-level abstractions like JPA and Spring Data. Understanding how to connect, query, manage transactions, and handle results at the JDBC level gives us precise control over database interactions and a solid foundation for troubleshooting any data-access layer.

This series covers core JDBC operations from fundamentals to practical patterns, organized by concern: from setting up connections and connection pools, through executing statements and working with result sets, managing schemas and metadata, and diagnosing common errors.

Getting Started with JDBC

• Loading JDBC Drivers
• Jdbc URL Format for Different Databases
• A Comparison Between JPA and JDBC
• A Simple Guide to Connection Pooling in Java
• Best Practices for Sizing the JDBC Connection Pool

Executing Statements

• Batch Processing in JDBC
• A Guide to Auto-Commit in JDBC
• How to Execute Multiple SQL Statements as One in JDBC
• Store File or byte[] as SQL Blob in Java (Store and Load)
• Using “LIKE” Wildcards in Java PreparedStatements
• Inserting Null Into an Integer Column Using JDBC

Working with ResultSets

• Processing JDBC ResultSet With Stream API
• Pagination With JDBC
• Get the Number of Rows in a ResultSet
• Convert ResultSet Into Map
• Converting a JDBC ResultSet to JSON in Java

Connection and Schema Management

• Connecting to a Specific Schema in JDBC
• Extracting Database Metadata Using JDBC
• How to Check if a Database Table Exists with JDBC
• Is java.sql.Connection Thread-Safe?
• Intercept SQL Logging with P6Spy
• Mocking JDBC for Unit Testing

Errors and Troubleshooting

• Fix the Java-MySQL Connection Exception: Public Key Retrieval is not allowed
• Resolving PostgreSQL ERROR: canceling statement due to user request
• Solving “java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver”
• Fix the Exception “Cannot issue data manipulation statements with executeQuery()”
• Tomcat Warning “To Prevent a Memory Leak, the JDBC Driver Has Been Forcibly Unregistered”

       

Content mobilized by FeedBlitz RSS Services, the premium FeedBurner alternative.