You’ve got database code that uses both Hibernate and Spring. You need to test it. In this podcast I talk about how you can use DBUnit and HSQLDB along with some Spring test classes to create a setup that will let you test database code fast, and in isolation. Just what good unit tests should do.
Check out some great references on database testing, including the ones I mentioned in this show.
DBUnit and thier best practices for database testing.
The HSQLDB home page.
Scott Ambler’s excellent discussion of database refactoring.
An article from TheServerSide.com about unit testing with HSQLDB.
Spring’s AbstractTransactionalDataSourceSpringContextTests class that helps make some of your database testing easier. Check the other classes in the hierarchy for specifics on what they do as well.
I decided to try out adding a GarageBand.com song today, like the SlashdotReview podcast does. The song is Calendar by Eugenia and The Boys. Let me know if you like it. Also feel free to revolt and tell me to pull the music and keep it to tech stuff. 
Listen now with the Flash player.
Download Unit Testing Database Code.
August 15th, 2005 at 16:02
Tim, haven’t had a dose of Zdot for several weeks. A new one in the pipeline? Love listening to these on the way to and fro work.
Keep up the good work.
August 18th, 2005 at 12:44
I did not know Zdot was back up!! And with a podcast. This is fantastic!! I’m downloading them all just so I can catch up.
September 29th, 2005 at 17:34
I really enjoy your podcast. JavaCast sucks in comparison.
December 8th, 2005 at 14:53
The talk was useful, but I have a hard time understanding if I can’t see code. I would really appreciate it if you could provide code samples.
Thanks,
Tony