@Test public void testUsageWithConnectionProperties() throws Exception { final String jdbcUrl = "url"; final Properties connProps = new Properties(); connProps.setProperty("myProp", "myValue"); connProps.setProperty("yourProp", "yourValue"); connProps.setProperty("user", "uname"); connProps.setProperty("password", "pwd"); class TestDriverManagerDataSource extends DriverManagerDataSource { @Override protected Connection getConnectionFromDriverManager(String url, Properties props) { assertEquals(jdbcUrl, url); assertEquals("uname", props.getProperty("user")); assertEquals("pwd", props.getProperty("password")); assertEquals("myValue", props.getProperty("myProp")); assertEquals("yourValue", props.getProperty("yourProp")); return connection; } } DriverManagerDataSource ds = new TestDriverManagerDataSource(); //ds.setDriverClassName("foobar"); ds.setUrl(jdbcUrl); ds.setConnectionProperties(connProps); Connection actualCon = ds.getConnection(); assertTrue(actualCon == connection); assertTrue(ds.getUrl().equals(jdbcUrl)); }
ds.setConnectionProperties(connProps); Connection actualCon = ds.getConnection(); assertTrue(actualCon == connection);
@Test public void testStandardUsage() throws Exception { final String jdbcUrl = "url"; final String uname = "uname"; final String pwd = "pwd"; class TestDriverManagerDataSource extends DriverManagerDataSource { @Override protected Connection getConnectionFromDriverManager(String url, Properties props) { assertEquals(jdbcUrl, url); assertEquals(uname, props.getProperty("user")); assertEquals(pwd, props.getProperty("password")); return connection; } } DriverManagerDataSource ds = new TestDriverManagerDataSource(); //ds.setDriverClassName("foobar"); ds.setUrl(jdbcUrl); ds.setUsername(uname); ds.setPassword(pwd); Connection actualCon = ds.getConnection(); assertTrue(actualCon == connection); assertTrue(ds.getUrl().equals(jdbcUrl)); assertTrue(ds.getPassword().equals(pwd)); assertTrue(ds.getUsername().equals(uname)); }
for (String statement : statements) { try { dataSource.getConnection().createStatement().execute(statement); } catch (SQLException ex) {
private static DriverManagerDataSource dataSource; @BeforeClass public static void setupClass() throws Exception { ResourceDatabasePopulator populator = new ResourceDatabasePopulator(); populator.addScript(new ClassPathResource("path/to/package/defaults.sql")); dataSource = new DriverManagerDataSource(); dataSource.setUrl("jdbc:hsqldb:mem:pgtest;sql.syntax_pgs=true"); dataSource.setUsername("SA"); Connection con = dataSource.getConnection(); assertNotNull(con); populator.populate(con); con.close(); }
try (Connection connection = driverManagerDataSource.getConnection())
try (Connection connection = driverManagerDataSource.getConnection())