private void loadConfig() {
dataSource = new MysqlDataSource();
dataSource.setServerName(configFile.getDatabaseName());
dataSource.setUser(configFile.getDatabaseUser());
dataSource.setPassword(configFile.getDatabasePassword());
this.jdbcTemplate = new JdbcTemplate(dataSource);
}
/** Imports data into database by executing the sql datadump script */
private void importData() {
context = new AnnotationConfigApplicationContext(SpringConf.class);
CustomResourceLoader customResourceLoader =
(CustomResourceLoader) context.getBean("customResourceLoader");
try {
Resource query = customResourceLoader.getDataDumpResource(configFile.getDatadumpPath());
ScriptUtils.executeSqlScript(dataSource.getConnection(), query);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ScriptException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}