Re: [cinjug-users] DbUnit and Hibernate

["Edward Sumerfield" <esumerfd@xxxxxxxxx>]

DBUnit rocks. It gives you data exporting and importing to a few different formats. I use Excel and XML format. I export data from an Oracle database and import into hsqldb between each test. Very fast and fairly simple to use.

The toughest problem is managing load dependencies. Each exported table and row must not break the foreign keys.

Oracle allows us to generate a list of tables in foreign key dependent order. It doesn't solve the problem of self-referencing tables and the row sequence though.

Additionally, since you are likley not exporting the entire database you may miss some required dependencies so there is usually some data patching that is required after the export to ensure that the data can be re-loaded correctly.

Make sure that you allow the export to include tables from a sub-dependent tree. I have never been able to fix the dependencies for an entire schema.

On 8/8/06, twcrone@xxxxxxxxxxxxx <twcrone@xxxxxxxxxxxxx> wrote:

In the past I have not built very good tests for my Hibernate DAO's.  Typically write a main method that tests the CRUD operations but never put it somewhere that others can easily use it or it can easily be run as a test suite.  I have heard of something called DBUNIT that I plan to look into.  Any other suggestions?

BTW...NFJS conference this weekend was GREAT!!!

- Todd

 

-- 
Ed