JdbcTemplate jdbcTemplate = new JdbcTemplate(ds);
jdbcTemplate.execute("create table records (id smallint, " +
"name varchar(100), address varchar(100), city varchar(100), country varchar(100), " +
"age smallint)");
Connection con = DataSourceUtils.getConnection(ds);
IDatabaseConnection dbUnitCon = null;
try {
dbUnitCon = new DatabaseConnection(con);
} catch (DatabaseUnitException e) {
System.out.println(e);
}
dbUnitCon.getConfig().setProperty(DatabaseConfig.FEATURE_BATCHED_STATEMENTS, Boolean.TRUE);
dbUnitCon.getConfig().setProperty(DatabaseConfig.PROPERTY_DATATYPE_FACTORY, new MySqlDataTypeFactory());
IDataSet dataSet = null;
try {
dataSet = new XmlDataSet(new FileInputStream("data/load.xml"));
} catch (IOException e) {
System.out.println(e);