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

SQL Server 2005's Type 4 JDBC driver provides database connectivity from a Java application. Though the driver class and connection URL are a bit different in this version, connectivity is a snap.