Example usage for org.springframework.jdbc.datasource.embedded EmbeddedDatabaseType DERBY

List of usage examples for org.springframework.jdbc.datasource.embedded EmbeddedDatabaseType DERBY

Introduction

In this page you can find the example usage for org.springframework.jdbc.datasource.embedded EmbeddedDatabaseType DERBY.

Prototype

EmbeddedDatabaseType DERBY

To view the source code for org.springframework.jdbc.datasource.embedded EmbeddedDatabaseType DERBY.

Click Source Link

Document

The <a href="https://db.apache.org/derby">Apache Derby</a> Embedded SQL Database.

Usage

From source file:org.apache.cmueller.camel.apachecon.na2013.SqlBatchTest.java

@Before
public void setUp() throws Exception {
    datasource = new EmbeddedDatabaseBuilder().setType(EmbeddedDatabaseType.DERBY)
            .addScript("sql/init_database.sql").build();

    super.setUp();
}

From source file:edu.si.services.sidora.rest.batch.BatchServiceTest.java

@Override
public void setUp() throws Exception {
    log.info("===================[ KARAF_HOME = {} ]===================", System.getProperty("karaf.home"));

    List<String> propFileList = loadAdditionalPropertyFiles();
    if (loadAdditionalPropertyFiles() != null) {
        for (String propFile : propFileList) {
            Properties extra = new Properties();
            try {
                extra.load(new FileInputStream(propFile));
                props.putAll(extra);//from w  w  w. j a  v a2 s .c om
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

    for (Map.Entry<Object, Object> p : System.getProperties().entrySet()) {
        if (props.containsKey(p.getKey())) {
            props.setProperty(p.getKey().toString(), p.getValue().toString());
        }
    }

    super.setUp();

    httpClient = HttpClientBuilder.create().build();
    //jaxb = JAXBContext.newInstance(CustomerList.class, Customer.class, Order.class, Product.class);

    db = new EmbeddedDatabaseBuilder().setType(EmbeddedDatabaseType.DERBY).setName("derbyTestDB")
            .addScripts("sql/createAndPopulateDatabase.sql").build();

    //        FileInputStream sqlFile = new FileInputStream("src/test/resources/sql/createAndPopulateDatabase.sql");
    //        Properties sql = new Properties(System.getProperties());
    //        sql.load(sqlFile);

    jdbcTemplate = new JdbcTemplate(db);
}

From source file:org.springframework.integration.jdbc.JdbcPollingChannelAdapterIntegrationTests.java

@Before
public void setUp() {
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    builder.setType(EmbeddedDatabaseType.DERBY).addScript(
            "classpath:org/springframework/integration/jdbc/pollingChannelAdapterIntegrationTest.sql");
    this.embeddedDatabase = builder.build();
    this.jdbcTemplate = new JdbcTemplate(this.embeddedDatabase);
}

From source file:org.talend.components.service.rest.JdbcComponentIntegrationTest.java

@Before
public void setUp() throws Exception {
    db = new EmbeddedDatabaseBuilder().generateUniqueName(true).setType(EmbeddedDatabaseType.DERBY)
            .setName("testdb").setScriptEncoding("UTF-8")
            .addScript("/org/talend/components/service/rest/schema.sql")
            .addScript("/org/talend/components/service/rest/data_users.sql").build();
    // addresss: Starting embedded database: url='jdbc:derby:memory:2dc86c66-5d3a-48fd-b903-56aa27d20e3b;create=true',
    // username='sa'
    try (Connection connection = db.getConnection()) {
        dbUrl = connection.getMetaData().getURL();
    }/*from  w w w  .  ja v a2  s  .  c  o  m*/

    RestAssured.port = localServerPort;
}

From source file:org.talend.components.service.rest.JdbcComponentTestIT.java

@Before
public void setUp() throws Exception {
    db = new EmbeddedDatabaseBuilder().generateUniqueName(true).setType(EmbeddedDatabaseType.DERBY)
            .setName("testdb").setScriptEncoding("UTF-8")
            .addScript("/org/talend/components/service/rest/schema.sql")
            .addScript("/org/talend/components/service/rest/data_users.sql").build();
    // addresss: Starting embedded database:
    // url='jdbc:derby:memory:2dc86c66-5d3a-48fd-b903-56aa27d20e3b;create=true',
    // username='sa'
    try (Connection connection = db.getConnection()) {
        dbUrl = connection.getMetaData().getURL();
    }/*from   w w  w .j  a v  a  2s.c  o m*/

    RestAssured.port = localServerPort;
}