hibernate constrainviolationexception foreign key constraint

This was due to some test cases creating their own hibrenate sessions and transactions and attempting to save across multiple sessions and multiple transactions.

The fix was to ensure only one session is used across DAO calls.