@Before
public void onSetUp() throws Exception {
JdbcTestUtils.executeSqlScript(
new JdbcTemplate(dataSource),
new ClassPathResource("META-INF/testdata/sample_schema_ddl_" + usingDBMS + ".sql"),
true);
// init data
JdbcTestUtils.executeSqlScript(
new JdbcTemplate(dataSource),
new ClassPathResource("META-INF/testdata/sample_schema_initdata_" + usingDBMS + ".sql"),
true);
}
@Bean
public BasicDataSource dataSource() {
BasicDataSource basicDataSource = new BasicDataSource();
basicDataSource.setDriverClassName(environment.getProperty("jdbc.driverClassName"));
basicDataSource.setUrl(environment.getProperty("jdbc.url"));
basicDataSource.setUsername(environment.getProperty("jdbc.username"));
basicDataSource.setPassword(environment.getProperty("jdbc.password"));
// properties below are to improve performance
basicDataSource.setTestWhileIdle(true);
basicDataSource.setTestOnBorrow(true);
basicDataSource.setTestOnReturn(false);
basicDataSource.setValidationQuery(environment.getProperty("jdbc.validationQuery"));
basicDataSource.setTimeBetweenEvictionRunsMillis(30000);
basicDataSource.setMaxActive(100);
basicDataSource.setMinIdle(10);
basicDataSource.setMaxWait(10000);
basicDataSource.setInitialSize(10);
basicDataSource.setRemoveAbandonedTimeout(60);
basicDataSource.setRemoveAbandoned(true);
basicDataSource.setLogAbandoned(true);
basicDataSource.setMinEvictableIdleTimeMillis(30000);
// create scheme
if (!"false".equals(System.getProperty("create_scheme"))) {
JdbcTestUtils.executeSqlScript(
new JdbcTemplate(basicDataSource),
new ClassPathResource("/sql/create_scheme.sql"),
false);
}
return basicDataSource;
}
