Here's a quick JDBC with HSQLDB tutorial to get you up and running with Java database connectivity and the popular HyperSQL database.

JDBC (Java Database Connectivity) is the Java API that manages connecting to a database, issuing queries and commands, and handling result sets obtained from the database.

A developer shouldn't spend time on database table creation when unit tests run. Instead, have Hibernate create tables in the database for JPA and other data-driven applications.

Write, build, and run an example application that persists data to and from a relational database using Hibernate, JPA, and the repository pattern.