Class.forName("org.gjt.mm.mysql.Driver");
Connection jdbcConnection = DriverManager.getConnection("jdbc:mysql://localhost:3306/database_name?zeroDateTimeBehavior=convertToNull","user", "password");
IDatabaseConnection connection = new DatabaseConnection(jdbcConnection);
QueryDataSet partialDataSet = new QueryDataSet(connection);
partialDataSet.addTable("table_name");
FlatXmlDataSet.write(partialDataSet,new FileOutputStream("partial.xml"));
Tuesday, 9 April 2013
Exporting MySql tables to DBUnit FlatXmlDataSet format
This fragment of code allows export a table to the DBUnit Flat XML format
Labels:
dbunit
,
flatxmldataset
,
mysql
Location:
London, UK