private void assertDatabaseCreatedAndShutdown(EmbeddedDatabase db) { assertDatabaseCreated(db); db.shutdown(); }
@After public void tearDownEmbeddedDatabase() { embeddedDatabase.shutdown(); }
@AfterClass public static void tearDown() throws Exception { if (database != null) { database.shutdown(); } }
@After public void shutDown() { if (TransactionSynchronizationManager.isSynchronizationActive()) { TransactionSynchronizationManager.clear(); TransactionSynchronizationManager.unbindResource(db); } db.shutdown(); }
@AfterClass public static void tearDown() throws Exception { TestUtils.deleteFrom(database, "users", "groups", "group_membership"); if (database != null) { database.shutdown(); } }
@Test public void testGetDataSource() { StubDatabasePopulator populator = new StubDatabasePopulator(); factory.setDatabasePopulator(populator); EmbeddedDatabase db = factory.getDatabase(); assertTrue(populator.populateCalled); db.shutdown(); }
@Test public void createSameSchemaTwiceWithGeneratedUniqueDbNames() throws Exception { EmbeddedDatabase db1 = new EmbeddedDatabaseBuilder(new ClassRelativeResourceLoader(getClass()))// .addScripts("db-schema-without-dropping.sql", "db-test-data.sql")// .generateUniqueName(true)// .build(); JdbcTemplate template1 = new JdbcTemplate(db1); assertNumRowsInTestTable(template1, 1); template1.update("insert into T_TEST (NAME) values ('Sam')"); assertNumRowsInTestTable(template1, 2); EmbeddedDatabase db2 = new EmbeddedDatabaseBuilder(new ClassRelativeResourceLoader(getClass()))// .addScripts("db-schema-without-dropping.sql", "db-test-data.sql")// .generateUniqueName(true)// .build(); assertDatabaseCreated(db2); db1.shutdown(); db2.shutdown(); }
@After public void tearDown() throws Exception { this.workerApplicationContext.close(); this.brokerService.stop(); this.embeddedDatabase.shutdown(); }
@Test public void createSameSchemaTwiceWithoutUniqueDbNames() throws Exception { EmbeddedDatabase db1 = new EmbeddedDatabaseBuilder(new ClassRelativeResourceLoader(getClass()))// .addScripts("db-schema-without-dropping.sql").build(); try { new EmbeddedDatabaseBuilder(new ClassRelativeResourceLoader(getClass()))// .addScripts("db-schema-without-dropping.sql").build(); fail("Should have thrown a ScriptStatementFailedException"); } catch (ScriptStatementFailedException e) { // expected } finally { db1.shutdown(); } }
@AfterClass public static void destroy() { dataSource.shutdown(); }
@AfterClass public static void tearDown() { embeddedDatabase.shutdown(); }
@AfterClass public static void destroy() { dataSource.shutdown(); }
@AfterClass public static void teardown() { dataSource.shutdown(); }
@AfterClass public static void shutDownDatabase() { dataSource.shutdown(); }
@AfterClass public static void destroy() { dataSource.shutdown(); }
@AfterClass public static void tearDown() { embeddedDatabase.shutdown(); }
@AfterClass public static void tearDown() { embeddedDatabase.shutdown(); }
@Test public void testSetMaxRowsPerPollWithoutSelectQuery() { EmbeddedDatabase dataSource = new EmbeddedDatabaseBuilder().build(); JdbcOutboundGateway jdbcOutboundGateway = new JdbcOutboundGateway(dataSource, "update something"); try { jdbcOutboundGateway.setMaxRows(10); jdbcOutboundGateway.setBeanFactory(mock(BeanFactory.class)); jdbcOutboundGateway.afterPropertiesSet(); fail("Expected an IllegalArgumentException to be thrown."); } catch (IllegalArgumentException e) { assertEquals("If you want to set 'maxRows', then you must provide a 'selectQuery'.", e.getMessage()); } dataSource.shutdown(); }
@Test public void testFileSystemWithJdbcMetadataStore() throws Exception { EmbeddedDatabase dataSource = new EmbeddedDatabaseBuilder() .setType(EmbeddedDatabaseType.H2) .addScript("classpath:/org/springframework/integration/jdbc/schema-drop-h2.sql") .addScript("classpath:/org/springframework/integration/jdbc/schema-h2.sql") .build(); JdbcMetadataStore metadataStore = new JdbcMetadataStore(dataSource); metadataStore.setLockHint(""); metadataStore.afterPropertiesSet(); try { testFileSystem(metadataStore); List<Map<String, Object>> metaData = new JdbcTemplate(dataSource) .queryForList("SELECT * FROM INT_METADATA_STORE"); assertEquals(1, metaData.size()); assertEquals("43", metaData.get(0).get("METADATA_VALUE")); } finally { dataSource.shutdown(); } }
EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder(); EmbeddedDatabase db = builder.type(H2).script("schema.sql").script("test-data.sql").build(); // do stuff against the db (EmbeddedDatabase extends javax.sql.DataSource) db.shutdown()