Database unit testing
September 15, 2009 – 11:13 am
Most of the server side applications use database back-end. Being used to Test-Driven Development practices, it is desirable to be able to write a test for numerous stored procedures we put in our code. Building Java code to launch a simple stored procedure, flush database and setting to a predefined state is a burden. Here are couple tricks I used in my project:
1. Used TSQLUnit for SQL Server – open source, licensed under the LGPL license. There a good tutorial in the SQLServerCentral. You can also use a cookbook for fast introduction.
2. Used utPLSQL for Oracle testing. You can get up to speed here.
Good luck
No TweetBacks yet. (Be the first to Tweet this post)
