Java Reference
In-Depth Information
Testing database access
Dependency is the key problem in software
development at all scales.... Eliminating
duplication in programs eliminates dependency.
—Kent Beck,
Test-Driven Development: By Example
This chapter covers
Challenges of database testing
■
Introduction to DbUnit
■
Advanced DbUnit techniques
■
DbUnit best practices
■
The persistence layer (or, roughly speaking, the database access code) is undoubtedly
one of the most important parts of any enterprise project. Despite its importance,
the persistence layer is hard to unit test, mainly because of the following issues:
Unit tests must exercise code in isolation; the persistence layer requires
interaction with an external entity, the database.
■
Unit tests must be easy to write and run; code that accesses the database can
be cumbersome.
■
Unit tests must be fast to run; database access is relatively slow.
■
326
