changed dao service to transactional and removed transactional from tests to fix update test issue; added constraint testing