https://www.ericsimmerman.com/tags/dbunit/Recent content in Dbunit on technocracyHugoenWed, 17 Jun 2009 00:00:00 +0000https://www.ericsimmerman.com/blog/2009/06/17/resolve-foreign-key-constraint-error/conflict-with-dbunit-clean_insert-operation-mysqlintegrityconstraintviolationexception/Wed, 17 Jun 2009 00:00:00 +0000https://www.ericsimmerman.com/blog/2009/06/17/resolve-foreign-key-constraint-error/conflict-with-dbunit-clean_insert-operation-mysqlintegrityconstraintviolationexception/<div class='post'> <p>If DBUnit starts throwing MySQLIntegrityConstraintViolationException while performing a CLEAN_INSERT you can lose quite a bit of sleep attempting to resolve it or you can cheat and get back to work. The shortcut is to simply disable constraints for the INSERT operation by disabling constraints for DBUnit altogether. You can do that by adding sessionVariables=FOREIGN_KEY_CHECKS=0 to your JDBC connection string to MySQL. I use maven and in pom.xml my configuration for the dbunit plugin looks like this</p>