public void createDatabase() throws Exception { // Use a different connection url so the tests can run in parallel String connectionUrl; String sqlClassPathResource; if (!withAclClassIdType) { connectionUrl = "jdbc:hsqldb:mem:lookupstrategytest"; sqlClassPathResource = ACL_SCHEMA_SQL_FILE; } else { connectionUrl = "jdbc:hsqldb:mem:lookupstrategytestWithAclClassIdType"; sqlClassPathResource = ACL_SCHEMA_SQL_FILE_WITH_ACL_CLASS_ID; } dataSource = new SingleConnectionDataSource(connectionUrl, "sa", "", true); dataSource.setDriverClassName("org.hsqldb.jdbcDriver"); jdbcTemplate = new JdbcTemplate(dataSource); Resource resource = new ClassPathResource(sqlClassPathResource); String sql = new String(FileCopyUtils.copyToByteArray(resource.getInputStream())); jdbcTemplate.execute(sql); }
public static SingleConnectionDataSource getDataSourceFrom(String databaseFile) { SingleConnectionDataSource dataSource = new SingleConnectionDataSource(); dataSource.setDriverClassName("org.sqlite.JDBC"); dataSource.setUrl("jdbc:sqlite:" + databaseFile); return dataSource; }
@Bean public DataSource jdbcDataSource() { SingleConnectionDataSource ds = new SingleConnectionDataSource(); ds.setDriverClassName("org.sqlite.JDBC"); ds.setUrl("jdbc:sqlite:stats.db"); return ds; }
SingleConnectionDataSource ds = new SingleConnectionDataSource(); ds.setDriverClassName("org.hsqldb.jdbcDriver"); ds.setUrl("jdbc:hsqldb:data/tutorial"); ds.setUsername("sa"); ds.setPassword(""); JdbcTemplate jt = new JdbcTemplate(ds); jt.execute("insert into employee (id, name) values (?, ?)", 1, "Tom");