@Bean public DataSource dataSource() { DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setDriverClassName(DB_DRIVER); dataSource.setUrl(DB_URL); dataSource.setUsername(DB_USERNAME); dataSource.setPassword(DB_PASSWORD); return dataSource; }
/** * Create a new DriverManagerDataSource with the given standard * DriverManager parameters. * @param url the JDBC URL to use for accessing the DriverManager * @param username the JDBC username to use for accessing the DriverManager * @param password the JDBC password to use for accessing the DriverManager * @see java.sql.DriverManager#getConnection(String, String, String) */ public DriverManagerDataSource(String url, String username, String password) { setUrl(url); setUsername(username); setPassword(password); }
/** * Create a new DriverManagerDataSource with the given JDBC URL, * not specifying a username or password for JDBC access. * @param url the JDBC URL to use for accessing the DriverManager * @param conProps the JDBC connection properties * @see java.sql.DriverManager#getConnection(String) */ public DriverManagerDataSource(String url, Properties conProps) { setUrl(url); setConnectionProperties(conProps); }
@Bean public DataSource dataSource(@Value("${jdbc.driverclass}") String driverClass, @Value("${jdbc.url}") String url, @Value("${jdbc.username}") String username, @Value("${jdbc.password}") String password) { DriverManagerDataSource driverManagerDataSource = new DriverManagerDataSource(url, username, password); driverManagerDataSource.setDriverClassName(driverClass); return spy(driverManagerDataSource); }
@Override protected DriverManagerDataSource createDataSource() { DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setDriverClassName("org.apache.derby.jdbc.EmbeddedDriver"); dataSource.setUrl("jdbc:derby:memory:" + databaseName + ";create=true"); return dataSource; }
@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)); }
@Bean public JdbiFactoryBean jdbiFactory() { return new JdbiFactoryBean().setDataSource(new DriverManagerDataSource()); }
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(); }
@Configuration @EnableTransactionManagement public class PersistenceConfiguration { @Value("${spring.datasource.url}") private String jdbcUrl; // ... @Bean public DataSource dataSource() { DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setUrl(jdbcUrl); // ... } }
/** * Create a new DriverManagerDataSource with the given JDBC URL, * not specifying a username or password for JDBC access. * @param url the JDBC URL to use for accessing the DriverManager * @see java.sql.DriverManager#getConnection(String) */ public DriverManagerDataSource(String url) { setUrl(url); }
@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)); }
System.setProperty("hibernate.hbm2ddl.auto", "create"); System.setProperty("hibernate.dialect", "..."); DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setJdbcUrl("jdbc:hsqldb:mem:mytest"); new org.mortbay.jetty.plus.naming.Resource( "jdbc/primaryDs", dataSource);
/** * Returns the JDBC data source for this instance, connecting as the configured * system user and applying any configured driver properties. * * @return see above */ public javax.sql.DataSource getJdbcDataSource() { final DriverManagerDataSource dataSource = new DriverManagerDataSource(defaultDatabase, systemUsername, systemPassword); dataSource.setConnectionProperties(parse(properties, PROPERTY_KEY_VALUE_DELIMITER, PROPERTY_DELIMITER)); return dataSource; }
@Override public void setPassword(String newPassword) { super.setPassword(interpolate(newPassword)); }
@Override public void setUsername(String newUsername) { super.setUsername(interpolate(newUsername)); }
@Test public void testInvalidClassName() throws Exception { String bogusClassName = "foobar"; DriverManagerDataSource ds = new DriverManagerDataSource(); try { ds.setDriverClassName(bogusClassName); fail("Should have thrown IllegalStateException"); } catch (IllegalStateException ex) { // OK assertTrue(ex.getCause() instanceof ClassNotFoundException); } }
@Override protected DriverManagerDataSource createDataSource() { DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setDriverClassName("org.hsqldb.jdbcDriver"); dataSource.setUrl("jdbc:hsqldb:mem:aksess"+ databaseName + dbCounter++); return dataSource; } }
/** * Create a new DriverManagerDataSource with the given standard * DriverManager parameters. * @param url the JDBC URL to use for accessing the DriverManager * @param username the JDBC username to use for accessing the DriverManager * @param password the JDBC password to use for accessing the DriverManager * @see java.sql.DriverManager#getConnection(String, String, String) */ public DriverManagerDataSource(String url, String username, String password) { setUrl(url); setUsername(username); setPassword(password); }
ds.setUrl(jdbcUrl); ds.setUsername(uname); ds.setPassword(pwd); ds.setConnectionProperties(connProps); Connection actualCon = ds.getConnection(); assertTrue(actualCon == connection); assertTrue(ds.getUrl().equals(jdbcUrl)); assertTrue(ds.getPassword().equals(pwd)); assertTrue(ds.getUsername().equals(uname));
@Test public void setTypeAfterCompile() { operation.setDataSource(new DriverManagerDataSource()); operation.setSql("select * from mytable"); operation.compile(); exception.expect(InvalidDataAccessApiUsageException.class); operation.setTypes(new int[] { Types.INTEGER }); }