我正在询问并回答这个问题以供将来参考,因为我认为我找到了一个解决DbUnit常见问题的合适解决方案.我希望它能帮到某个人,某个地方.

我正在使用DbUnit 2.5.0和TestNG 6.8.8.我的用例是包含3个实体的数据库的一部分.有一个ServiceUser,它为Administrable和UserGroup保存一个外键.

我跟随了http://city81.blogspot.com/2011/03/testing-jpa-entities-using-dbunit.html的大部分代码示例

public abstract class AbstractDatabaseTest {
    protected EntityManager em; // initialized elsewhere
    private IDatabaseConnection connection;
    private IDataSet dataset;
    @BeforeClass
    private void setupDatabaseResource() throws Exception {
        // using Hibernate
        connection = new DatabaseConnection(((SessionImpl) (em.getDelegate())).connection());
        connection.getConfig().setProperty(DatabaseConfig.PROPERTY_DATATYPE_FACTORY,new HsqldbDataTypeFactory());
        // full database export
        IDataSet fullDataSet = connection.createDataSet();
        final String datasetPath = String.format("%s%s",RESOURCE_FOLDER,"Testing.xml");
        FlatXmlDataSet.write(fullDataSet,new FileOutputStream(datasetPath));
        FlatXmlDataSetBuilder flatXmlDataSetBuilder = new FlatXmlDataSetBuilder();
        flatXmlDataSetBuilder.setColumnSensing(true);
        dataset = flatXmlDataSetBuilder.build(new FileInputStream(datasetPath));
    }
    @AfterMethod
    public void cleanDB() throws Exception {
        em.getTransaction().begin();
        DatabaSEOperation.CLEAN_INSERT.execute(connection,dataset);
        em.getTransaction().commit();
    }
}

结果是以下XMLDataSet(省略数据)：

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException
Cannot delete or update a parent row: a foreign key constraint fails (`testing_db`.`serviceuser`,CONSTRAINT `FK_gyylcfbhpl2ukqs5rm7sq0uy8` FOREIGN KEY (`userGroup_id`) REFERENCES `usergroup` (`id`))