"Any program is only as good as it is useful."
—Linus Torvalds
Enterprise applications store, retrieve, transmit, manipulate, and analyze data. Storing, processing, and analyzing data is very critical to any business. The Business Intelligence (BI) process transforms data into meaningful information for business. BI analyzes statistical data and helps with decision making and predictions for businesses, such as risk assessment, planning and forecasting, and analyzing buying trends. Information can be stored in a file or to a database. Querying and accessing data from a relational database is easier than the file system. This chapter covers the unit testing of the database layer. The following topics are covered in depth:
Separation of concerns
Unit testing the persistence layer
Writing clean data access code using Spring JDBC
Integration testing of JDBC code
Integration testing of Spring JDBC