ResourceDatabasePopulator populator = new ResourceDatabasePopulator();
populator.setContinueOnError(true);
populator.setIgnoreFailedDrops(true);
populator.addScript(new ClassPathResource("/sql/items.sql"));
try {
populator.populate(dataSource.getConnection());
} catch (SQLException e) {
logger.error("Exception Populating Database", e);
}
return populator;
}