1. Make sure that you have executed all the steps listed in appendix C

2. Add -Dexec.classpathScope=test to the "mvn exec:java . . ." command

Doing this will at least find the test classes during execution and eliminates the need to copy them under target/classes

Although a number of the PIX database objects are created during the deployment of the pixweb-0.0.1.war to Tomcat, the sequences don't appear to be among that list. Therefore, the test programs will fail with something like the following:

Caused by: org.springframework.dao.DataAccessResourceFailureE xception: Could not obtain identity(); nested exception is java.sql.SQLException: Table not found in statement [insert into ALBUM_SEQUENCE]

I'm assuming this will also be rectified as I work my way through the book.

If not, as pointed out earlier, the definitions for all of the PIX DB objects appear to be located in wrox-pix-web/src/test/resources/pixhsql.sql

If I find out the magic needed to automatically create the required DB sequences, that comes in Part 2