[http://www.dbunit.org/ DbUnit] is a very handy tool for inserting test data into your database or confirming data after your tests. Sometimes, however, you run into gotchas.
[http://www.systemmobile.com/wp/?p=109 Inserting timestamps] -- They have to be formatted as "yyyy-MM-dd HH:mm:ss.fffffffff"
[http://idiacomputing.com/moin/PrimaryKeyGeneration#head-d7949da7a424b68c0ae6279e11b7e8718331321e autonumbered primary keys] -- you've got to let DbUnit generate the keys.
Some columns not populating? You probably didn't specify a DTD and those columns weren't mentioned in the data for the first row. See the [http://dbunit.sourceforge.net/components.html#flatxmldataset warning] and [http://dbunit.sourceforge.net/faq.html#generatedtd instructions] for generating a DTD. I temporarily added a test as a quick-and-dirty way of executing this:
public void nontestExportDtd() throws Exception {
IDatabaseConnection connection = getConnection();
FlatDtdDataSet.write(connection.createDataSet(),
new FileOutputStream(XML_DATASET_ROOT+"test.dtd"));
}