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

Old JDBC drivers and new MySQL 8 databases don't mesh. Here's an updated MySQL persistence.xml example file for those doing JPA and Hibernate development.