• Spring Test DBUnit
• DBUnit과 Spring을 쉽게 연동할 수 있게 해준다.

@Bean
public DatabaseConfigBean dbUnitDatabaseConfig() {
    DatabaseConfigBean config = new DatabaseConfigBean();
    config.setQualifiedTableNames(true); // schema 지원
    config.setMetadataHandler(new MySqlMetadataHandler());
    return config;
}
 
@Bean
public DatabaseDataSourceConnectionFactoryBean dbUnitDatabaseConnection(DataSource dataSource) {
    final DatabaseDataSourceConnectionFactoryBean dbUnitDatabaseConnection = 
        new DatabaseDataSourceConnectionFactoryBean();
    dbUnitDatabaseConnection.setDataSource(dataSource);
    dbUnitDatabaseConnection.setDatabaseConfig(dbUnitDatabaseConfig())
    return dbUnitDatabaseConnection;
}
 
// 실제 테스트에서는
@DbUnitConfiguration(databaseConnection = "dbUnitDatabaseConnection")
public class DatabaseTest {
...
}

FlatXML 에서는 schemaName.tableName 형태로 기입해줘야한다.

<?xml version="1.0" encoding="UTF-8"?>
<dataset>
	<myschema.article id="123" title="hello" regDttm="2016-09-28 09:20:22.000000" />
</dataset>