Hibernate_exercise_solution_app is a project mainly written in Java, it's free.
Please have your computer set up as follows. Note that there are a few elements that you have to pull together to have your system ready to go, so just make sure that you follow each item carefully. If anything isn't clear let me know as soon as possible.
Download the code git clone git://github.com/dlbock/hibernate_exercise_solution_app.git
Create a new IntelliJ project and import the existing *.iml module file.
Download HSQLDB version 2.2.4 to somewhere you can get to easily http://sourceforge.net/projects/hsqldb/files/hsqldb/hsqldb_2_2/hsqldb-2.2.4.zip/download
Read up on HSQLDB to familiarize yourself with what it is.
Windows users, run the bin/runServer.bat file.
b. HSQLDB comes with a Java Swing interface for you to type SQL scripts in (i.e. create tables, drop tables, etc), to start that up,
Mac/Linux users: java -classpath lib/hsqldb.jar org.hsqldb.util.DatabaseManagerSwing
Windows users, run bin/runManagerSwing.bat.
To get into the database to be able to type out your SQL scripts, use: jdbc:hsqldb:hsql://localhost for the URL then hit OK.
Now you can start writing SQL to create tables. So type the following: CREATE TABLE cars (id identity, name varchar(50), numberPlate varchar(50));
CREATE TABLE contacts (id identity, firstName varchar(50), lastName varchar(50));