My case is that I have two tables which one table has foreign key constraint to the other, and the reference is the other table's field 'id' which will auto increment with every insert, and cannot be omitted for this reference relation, and when I run unit test to test DAO's save(INSERT) method, the comparisonFailure occured for the 'id' is not match(expect 1 but real value is more than 1 and increasing by every run).
How to deal with this case?
Use the dbUnit feature to ignore columns in the comparison.
For example, DefaultPrepAndExpectedTestCase.runTest(...) has a parameter "verifyTables" which is type VerifyTableDefinition and has a constructor parameter "excludeColumns".
Directly, can use one of the "exclude column" methods on DefaultColumnFilter, such as excludedColumnsTable(table, columnNames).