public void testProperties() throws Exception {
Properties properties = new Properties();
properties.setProperty("driverClassName", "org.apache.commons.dbcp.TesterDriver");
properties.setProperty("url", "jdbc:apache:commons:testdriver");
properties.setProperty("maxActive", "10");
properties.setProperty("maxWait", "500");
properties.setProperty("defaultAutoCommit", "true");
properties.setProperty("defaultReadOnly", "false");
properties.setProperty("defaultTransactionIsolation", "READ_COMMITTED");
properties.setProperty("defaultCatalog", "test");
properties.setProperty("username", "username");
properties.setProperty("password", "password");
properties.setProperty("validationQuery", "SELECT DUMMY FROM DUAL");
BasicDataSource ds = (BasicDataSource) BasicDataSourceFactory.createDataSource(properties);
assertEquals("jdbc:apache:commons:testdriver", ds.getUrl());
assertEquals(10, ds.getMaxActive());
assertEquals(true, ds.getDefaultAutoCommit());
}
|