Rurony's Training Gym

WARN : org.dbunit.dataset.AbstractTableMetaData - Potential problem found: The configured data type factory 'class org.dbunit.dataset.datatype.DefaultDataTypeFactory' might cause problems with the current database 'MySQL' (e.g. some datatypes may not be supported properly). In rare cases you might see this message because the list of supported database products is incomplete (list=[derby]). If so please request a java-class update via the forums.If you are using your own IDataTypeFactory extending DefaultDataTypeFactory, ensure that you override getValidDbProducts() to specify the supported database products.

private final static String driverClass = "com.mysql.jdbc.Driver";

private final static String connectionUrl = "jdbc:mysql://localhost/testdb";

private final static String username = "testdb";

private final static String password = "testdb";

private final static String schema = "testdb";

//private IDatabaseTester databaseTester;

public static Connection getConnection() throws InstantiationException, IllegalAccessException, ClassNotFoundException {

Connection conn = null;

try {

Class.forName(driverClass);

conn = DriverManager.getConnection(connectionUrl, username, password);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return conn;

}

@Before

public void setUp() throws Exception {

//databaseTester = new JdbcDatabaseTester(driverClass, connectionUrl, username, password);

//IDatabaseConnection connection = new DatabaseConnection(getConnection());

IDatabaseConnection connection = new MySqlConnection(getConnection(), schema);

try {

IDataSet dataSet = new FlatXmlDataSetBuilder().build(new File("resetDB.xml"));

//DatabaseOperation.CLEAN_INSERT.execute(databaseTester.getConnection(), dataSet);

DatabaseOperation.CLEAN_INSERT.execute(connection, dataSet);

} catch (Exception e) {

// TODO: handle exception

//databaseTester.getConnection().close();

connection.close();

}

}