org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseBuilder Java Examples

public DataSource toDataSource() {
  DataSource dataSource;

  if (url == null || url.contains("hsqldb:mem")) {
    log.debug("Creating in memory HSQL database");
    // Start an in-process, in-memory HSQL server
    dataSource = new EmbeddedDatabaseBuilder().setType(HSQL).setName("c2mondb").build();
  } else {
    log.debug("Creating HSQL database at URL {}",url);
    dataSource = DataSourceBuilder.create().url(url).username(username).password(password).build();
  }

  if (!scripts.isEmpty()) {
    ResourceDatabasePopulator populator = new ResourceDatabasePopulator(scripts.toArray(new Resource[scripts.size()]));
    populator.setContinueOnError(true);
    DatabasePopulatorUtils.execute(populator, dataSource);
  }

  return dataSource;
}
 

@Bean
public DataSource dataSource() {
  EmbeddedDatabaseBuilder edb = new EmbeddedDatabaseBuilder();
  edb.setType(EmbeddedDatabaseType.H2);
  edb.addScript("spittr/db/jpa/schema.sql");
  edb.addScript("spittr/db/jpa/test-data.sql");
  EmbeddedDatabase embeddedDatabase = edb.build();
  return embeddedDatabase;
}
 

@Bean
public DataSource dataSource() {
    return new EmbeddedDatabaseBuilder()
            .setType(EmbeddedDatabaseType.H2)
            .addScript("classpath:db/schema.sql")
            .addScript("classpath:db/test-data.sql")
            .build();
}
 

@Bean(destroyMethod = "shutdown")
public DataSource writeDataSource() {
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder()
            .setName("lazyWriteDb")
            .setType(EmbeddedDatabaseType.H2)
            .setScriptEncoding("UTF-8")
            .addScript("classpath:/writedb.sql");
    return builder.build();
}
 

@Bean
DataSource orderDataSource() {

	return new EmbeddedDatabaseBuilder().//
			setType(EmbeddedDatabaseType.HSQL).//
			setName("orders").//
			build();
}
 

@Bean(destroyMethod="shutdown")
public DataSource dataSource(){
    return new EmbeddedDatabaseBuilder()
    		.setType(EmbeddedDatabaseType.H2)
    		.addScript("classpath:schema.sql")
    		.addScript("classpath:testData.sql")
    		.build();
}
 

@Bean
public DataSource dataSource2() {
	return new EmbeddedDatabaseBuilder()//
	.setName("database2")//
	.addScript("classpath:/org/springframework/test/context/jdbc/schema.sql")//
	.addScript("classpath:/org/springframework/test/context/jdbc/data.sql")//
	.build();
}
 

@Bean(destroyMethod = "shutdown")
public DataSource readDataSource() {
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder()
            .setName("routingReadDb")
            .setType(EmbeddedDatabaseType.H2)
            .setScriptEncoding("UTF-8")
            .addScript("classpath:/readdb.sql");
    return builder.build();
}
 

@Bean(destroyMethod="shutdown")
public DataSource dataSource(){
    return new EmbeddedDatabaseBuilder()
    		.setType(EmbeddedDatabaseType.H2)
    		.addScript("classpath:schema.sql")
    		.addScript("classpath:testData.sql")
    		.build();
}
 

@Bean
public DataSource dataSource1() {
	return new EmbeddedDatabaseBuilder()//
	.setName("database1")//
	.addScript("classpath:/org/springframework/test/context/jdbc/schema.sql")//
	.addScript("classpath:/org/springframework/test/context/jdbc/data.sql")//
	.build();
}
 

/**
 * 使用内嵌数据库
 */
@Bean
public DataSource h2DataSource() {
    return new EmbeddedDatabaseBuilder()
            .setType(EmbeddedDatabaseType.H2)
            .addScript("sql-script/schema.sql")
            .addScript("sql-script/data.sql")
            .build();
}
 

@Bean
public DataSource dataSource() {
  return new EmbeddedDatabaseBuilder()
          .setType(EmbeddedDatabaseType.H2)
          .addScript("schema.sql")
          .build();
}
 

/**
 * Embedded H2 database
 * Connect to running database with the following details:
 *
 * URL: jdbc:h2:mem:dataSource
 * Driver Class: org.h2.Driver
 * Username: sa
 * Password: [blank]
 *
 * @return
 */
@Bean
public DataSource dataSource() {
    final EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    database = builder.setType(EmbeddedDatabaseType.H2)
            .setName("dataSource")
            .ignoreFailedDrops(true)
            .continueOnError(false)
            .addScript("classpath:database/h2/calendar-schema.sql")
            .addScript("classpath:database/h2/calendar-data.sql")
            .build();
    return database;
}
 

@Bean
public DataSource dataSource() {
    return new EmbeddedDatabaseBuilder()
      .setType(EmbeddedDatabaseType.H2)
      .addScript("schema.sql")
      .addScript("data.sql")
      .build();
}
 

/**
 * Embedded H2 database
 * Connect to running database with the following details:
 *
 * URL: jdbc:h2:mem:dataSource
 * Driver Class: org.h2.Driver
 * Username: sa
 * Password: [blank]
 *
 * @return
 */
@Bean
public DataSource dataSource() {
    final EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    database = builder.setType(EmbeddedDatabaseType.H2)
            .setName("dataSource")
            .ignoreFailedDrops(true)
            .continueOnError(false)
            .addScript("classpath:database/h2/calendar-schema.sql")
            .addScript("classpath:database/h2/calendar-data.sql")
            .build();
    return database;
}
 

@Bean
public DataSource dataSource2() {
	return new EmbeddedDatabaseBuilder()//
	.setName("database2")//
	.addScript("classpath:/org/springframework/test/context/jdbc/schema.sql")//
	.addScript("classpath:/org/springframework/test/context/jdbc/data.sql")//
	.build();
}
 

@Bean
public DataSource dataSource1() {
	return new EmbeddedDatabaseBuilder()//
	.setName("database1")//
	.addScript("classpath:/org/springframework/test/context/jdbc/schema.sql")//
	.addScript("classpath:/org/springframework/test/context/jdbc/data.sql")//
	.build();
}
 

@Bean
public DataSource dataSource1() {
	return new EmbeddedDatabaseBuilder()//
	.setName("database1")//
	.addScript("classpath:/org/springframework/test/context/jdbc/schema.sql")//
	.addScript("classpath:/org/springframework/test/context/jdbc/data.sql")//
	.build();
}
 

@Bean
public DataSource dataSource() {
	return new EmbeddedDatabaseBuilder()//
	.setName("populated-sql-scripts-test-db")//
	.addScript("classpath:/org/springframework/test/context/jdbc/schema.sql") //
	.build();
}
 

@Bean
public DataSource dataSource() {
    final EmbeddedDatabaseBuilder embeddedDatabaseBuilder = new EmbeddedDatabaseBuilder();
    return embeddedDatabaseBuilder
            .addScript("classpath:org/tuxdevelop/spring/batch/lightmin/repository/drop_schema_h2.sql")
            .addScript("classpath:org/tuxdevelop/spring/batch/lightmin/repository/schema_h2.sql")
            .addScript("classpath:properties/sample/server/sql/inserts.sql")
            .setType(EmbeddedDatabaseType.H2).build();
}
 

@Bean
public DataSource dataSource() {

	EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
	EmbeddedDatabase db = builder.setType(EmbeddedDatabaseType.H2).addScript("db/sql/create-db.sql").addScript("db/sql/insert-data.sql").build();
	return db;

}
 

@Bean
public DataSource dataSource() {
    EmbeddedDatabaseBuilder dbBuilder = new EmbeddedDatabaseBuilder();
    return dbBuilder.setType(EmbeddedDatabaseType.H2)
        .addScript("classpath:/manytomany/db.sql")
        .build();
}
 

@Bean
public DataSource dataSourcePartner() {
	return new EmbeddedDatabaseBuilder()//
			.setType(EmbeddedDatabaseType.HSQL)//
			.ignoreFailedDrops(true)//
			.addScripts("classpath:org/springframework/batch/core/schema-drop-hsqldb.sql",
					"classpath:org/springframework/batch/core/schema-hsqldb.sql", "classpath:schema-partner.sql")//
			.build();
}
 

@Bean
public DataSource dataSource() {
    return new EmbeddedDatabaseBuilder()
            .generateUniqueName(true)
            .setType(EmbeddedDatabaseType.H2)
            .setScriptEncoding("UTF-8")
            .ignoreFailedDrops(true)
            .addScript("schema.sql")
            .addScripts("data.sql")
            .build();
}
 

@Bean("otherDataSource")
@Primary
public DataSource otherDataSource() {
	
	return new EmbeddedDatabaseBuilder().generateUniqueName(true)
            .setType(EmbeddedDatabaseType.H2)
            .setScriptEncoding("UTF-8")
            .ignoreFailedDrops(true).build();
}
 

@Bean
public DataSource dataSource1() {
	return new EmbeddedDatabaseBuilder()//
	.setName("database1")//
	.addScript("classpath:/org/springframework/test/context/jdbc/schema.sql")//
	.addScript("classpath:/org/springframework/test/context/jdbc/data.sql")//
	.build();
}
 

@Bean @Qualifier("mainDataSource")
public DataSource dataSource(){
	EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
	EmbeddedDatabase db = builder
			.setType(EmbeddedDatabaseType.H2)
			.build();
	return db;
}
 

@Bean
DataSource dataSource() {
	return new EmbeddedDatabaseBuilder()//
	.addScript("classpath:/org/springframework/test/jdbc/schema.sql")//
	.addScript("classpath:/org/springframework/test/jdbc/data.sql")//
	.build();
}
 

@Bean
public DataSource dataSource() {
	return new EmbeddedDatabaseBuilder()//
	.generateUniqueName(true)//
	.addScript("classpath:/org/springframework/test/context/jdbc/schema.sql") //
	.build();
}
 

@Bean
public DataSource dataSource() {
	return new EmbeddedDatabaseBuilder()//
	.generateUniqueName(true)//
	.addScript("classpath:/org/springframework/test/jdbc/schema.sql") //
	.build();
}