Using DBUnit with AbstractSpringContextTests

[chenrici]

I was wondering, if others also have come across the Requirement to use both the org.dbunit.DatabaseTestCase and die org.springframework.test.AbstractSpringContextTest s Hierarchie.

Specially if there is any commited code around, which helps me with some kind of Mixin Class Composition Approach. If not what would be the a "recommended" approach to achieve this?

Any hints or links appreciated.

Christoph Henrici

[Rod Johnson]

I know some users have combined these. There is nothing in development (so far) within Spring, although a contribution would be considered.

[dejanp]

I was wondering, if others also have come across the Requirement to use both the org.dbunit.DatabaseTestCase and die org.springframework.test.AbstractSpringContextTest s Hierarchie.

Specially if there is any commited code around, which helps me with some kind of Mixin Class Composition Approach. If not what would be the a "recommended" approach to achieve this?

Any hints or links appreciated.

Christoph Henrici

If you take a look at DatabaseTestCase class, you will notice that it doesn't do much at all. You can write your own base test class that extends a Spring test class and add dbUnit setup/teardown to it. It's just a couple of lines really, something like:

    protected void onSetUp() throws Exception {
        super.onSetUp();

        dataSet=...

        connection = new DatabaseDataSourceConnection(dataSource);
        DatabaseOperation.INSERT.execute(connection, dataSet);
    }

    protected void onTearDown() throws Exception {
        super.onTearDown();

        DatabaseOperation.DELETE_ALL.execute(connection, dataSet);
        
        connection.close();
    }

or something simmilar.

[chenrici]

Spring is already tremendously feature-rich adressing real live development requirements ..;-)

Here's what i found out , ater some "research" of my own:

DBUnit does not require to inherit the Testcase from org.dbunit.DatabaseTestCase.

What i did is subclass Springs AbstractTransactionalDataSourceSpringContextTests with a abstract class, who main purpose is to wrap the Connection of jdbcTemplate as a IDatabaseConnection.

    protected IDatabaseConnection getDbUnitConnection() throws Exception {
        final DataSource dataSource = jdbcTemplate.getDataSource();
        return new DatabaseConnection(DataSourceUtils.getConnection(dataSource));
    }

Using then the wrapped Connection with the other DbUnit classes as required.

Best thanx
Christoph Henrici