changed tests over to transaction test case in order to test integrity errors