Testing your DAO layer

Johannes Brodwall has a nice step by step post here about how to do tests of your DAO layer running Hibernate and HSQLdb in memory.