DBunit

Added by   Donny Lee, last edited by   Donny Lee  on Mar 03, 2011  ( view change) Export data from databaseeg: Export data from MSSQL to dataset.xml http://www.dbunit.org/faq.html#extract //jdbcConnection is database connection IDatabaseConnection connection = new DatabaseConnection(jdbcConnection); DatabaseConfig config = connection.getConfig(); config.setProperty(DatabaseConfig.PROPERTY_DATATYPE_FACTORY, new MsSqlDataTypeFactory()); // partial database export QueryDataSet partialDataSet = new QueryDataSet(connection); partialDataSet.addTable("campaign"); partialDataSet.addTable("campaigndetail","SELECT * FROM campaigndetail"); FlatXmlDataSet.write(partialDataSet, new FileOutputStream("dataset.xml"));

load dataset into database

offic doc:http://www.dbunit.org/howto.html

call onSetup() should insure these table in database ,because DBunit cann't create table, it only store data.so, if you use hsql and dbunit test your java code ,you need create table in hsql seeHSQLDB //datasource IDatabaseTester databaseTester = new DataSourceDatabaseTester(dataSource); /**get dataSet */ FlatXmlDataSetBuilder builder= new FlatXmlDataSetBuilder(); builder.setColumnSensing(true); IDataSet dataSet = builder.build(new File("src/test/resources/com/radicasys/intimate/report/dataset.xml")); //insert data databaseTester.setDataSet(dataSet); databaseTester.onSetup();