private static void populateForH2(String url, BoneCPDataSource datasource, boolean isDev) { if (!url.contains("DB_CLOSE_DELAY") && isDev) { datasource.setJdbcUrl(url + ";DB_CLOSE_DELAY=-1"); } else { datasource.setJdbcUrl(url); } } }
private static void populateForMySQLFull(Matcher matcher, String url, BoneCPDataSource datasource) { String username = matcher.group(1); String password = matcher.group(2); String host = matcher.group(3); String db = matcher.group(4); String defaultProperties = DEFAULT_MYSQL_PROPERTIES; if (MYSQL_CUSTOM_PROPERTIES.matcher(url).find()) { defaultProperties = ""; } datasource.setJdbcUrl(String.format("jdbc:mysql://%s/%s", host, db + defaultProperties)); datasource.setUsername(username); datasource.setPassword(password); }
BoneCPDataSource source = new BoneCPDataSource(); source.setDriverClass("org.h2.Driver"); source.setJdbcUrl("jdbc:h2:mem:x"); String name = new JdbcSession(source) .sql("SELECT name FROM user WHERE id = ?") .set(555) .select(new SingleHandler<String>(String.class));
/** * Checks if the given url is matching one of the known pattern (MySQL and H2), * if so try to extract information from the url and populate the data source. * <p/> * In all case, this method set the data source url, even if none known pattern match. * * @param datasource the data source to populate * @param url the jdbc url * @param isDev a boolean indicating if the wisdom server is running in 'dev' mode. * @return {@literal true} if the data soruce was populated, {@literal false} otherwise */ public static boolean populate(BoneCPDataSource datasource, String url, boolean isDev) { Matcher matcher = MYSQL_URL.matcher(url); if (matcher.matches()) { populateForMySQLFull(matcher, url, datasource); return true; } matcher = H2_URL.matcher(url); if (matcher.matches()) { populateForH2(url, datasource, isDev); return true; } // Set the url to the raw url. datasource.setJdbcUrl(url); return false; }
dataSource.setJdbcUrl(conf.getProperty("db.url")); dataSource.setUsername(conf.getProperty("db.user")); dataSource.setPassword(conf.getProperty("db.password"));
bds.setJdbcUrl(conf.get("url")); bds.setUsername(conf.get("user")); bds.setPassword(conf.get("password"));
@Bean public DataSource dataSource() { BoneCPDataSource dataSource = new BoneCPDataSource(); dataSource.setDriverClass("org.postgresql.Driver"); dataSource.setJdbcUrl("jdbc:postgresql://localhost/oauthDB"); dataSource.setUsername("my_username"); dataSource.setPassword("*****"); return dataSource; }
ds.setJdbcUrl(config.getString("url")); ds.setUsername(config.getString("username")); ds.setPassword(config.getString("password"));
public static DataSource getDataSource(File file) throws ClassNotFoundException, IOException, DaoException { Class.forName("org.h2.Driver"); BoneCPDataSource ds = new BoneCPDataSource(); ds.setPartitionCount(8); ds.setMaxConnectionsPerPartition(4); ds.setJdbcUrl("jdbc:h2:"+file.getAbsolutePath()); ds.setUsername("sa"); ds.setPassword(""); // Initialize the database to create files try { ds.getConnection().close(); } catch (SQLException e) { throw new DaoException(e); } return ds; } }
@Singleton @Produces public javax.sql.DataSource produceDataSource() { try { Class.forName(config.getDriver()); } catch (ClassNotFoundException e) { throw new RuntimeException(e); } BoneCPDataSource ds = new BoneCPDataSource(); ds.setUser(config.getUser()); ds.setPassword(config.getPassword()); ds.setJdbcUrl(config.getUrl()); DataSource datasource = new DataSource(ds); return datasource; } }
final String database) { BoneCPDataSource datasource = new BoneCPDataSource(); datasource.setJdbcUrl(database); datasource.setDriverClass(env.getProperty(DB_DRIVER, DB_DEFAULT_DRIVER));
@Bean public DataSource dataSource() { BoneCPDataSource dataSource = new BoneCPDataSource(); dataSource.setDriverClass(environment.getRequiredProperty(PROPERTY_NAME_DATABASE_DRIVER)); dataSource.setJdbcUrl(environment.getRequiredProperty(PROPERTY_NAME_DATABASE_URL)); dataSource.setUsername(environment.getRequiredProperty(PROPERTY_NAME_DATABASE_USERNAME)); dataSource.setPassword(environment.getRequiredProperty(PROPERTY_NAME_DATABASE_PASSWORD)); return dataSource; }
ds.setJdbcUrl("jdbc:postgresql://localhost:5432/test"); ds.setUsername("user"); ds.setPassword("password");
/** * Data source. * @return Source */ @Cacheable(forever = true) private static DataSource bonecp() { final BoneCPDataSource src = new BoneCPDataSource(); src.setDriverClass("org.postgresql.Driver"); src.setJdbcUrl(Manifests.read("Aintshy-PgsqlJdbc")); src.setUser(Manifests.read("Aintshy-PgsqlUser")); src.setPassword(Manifests.read("Aintshy-PgsqlPassword")); return src; }
@Bean(destroyMethod = "close") public DataSource mainDataSource() { BoneCPDataSource dataSource = new BoneCPDataSource(); dataSource.setDriverClass(jdbcDriverClass); dataSource.setJdbcUrl(jdbcUrl); dataSource.setUsername(jdbcUsername); dataSource.setPassword(jdbcPassword); dataSource.setIdleConnectionTestPeriodInMinutes(2); dataSource.setIdleMaxAge(2, TimeUnit.HOURS); dataSource.setMaxConnectionsPerPartition(60); dataSource.setMinConnectionsPerPartition(20); dataSource.setPartitionCount(3); dataSource.setAcquireIncrement(10); dataSource.setStatementsCacheSize(50); return dataSource; } }
private BoneCPDataSource createDataSource() { ResourceHelper.forName(config.getJdbcDriver(), getClass()); BoneCPDataSource datasource = new BoneCPDataSource(); datasource.setDriverClass(config.getJdbcDriver()); datasource.setJdbcUrl(config.getJdbcUrl()); datasource.setUsername(config.getJdbcUser()); datasource.setPassword(config.getJdbcPassword()); datasource.setMinConnectionsPerPartition(config.getPoolMinConnections()); datasource.setMaxConnectionsPerPartition(config.getPoolMaxConnections()); return datasource; } }
private BoneCPDataSource createBoneCPDataSource(Properties props) throws Exception { BoneCPDataSource dataSource = null; if (props == null) { dataSource = new BoneCPDataSource(); dataSource.setMaxConnectionsPerPartition(maxActive); dataSource.setMinConnectionsPerPartition(minIdle); } else { BoneCPConfig config = new BoneCPConfig(props); dataSource = new BoneCPDataSource(config); } dataSource.setJdbcUrl(jdbcUrl); dataSource.setDriverClass(jdbcDriver); dataSource.setUsername(username); dataSource.setPassword(password); return dataSource; }
pool.setJdbcUrl( config.url().get() );
pool.setJdbcUrl( config.url().get() );
private BoneCPDataSource createNewDataSource() { BoneCPDataSource target = new BoneCPDataSource(); target.setDriverClass(config.getDriverClassName()); target.setJdbcUrl(config.getJdbcUrl()); target.setUsername(config.getUserName()); target.setPassword(config.getPassword()); target.setIdleConnectionTestPeriodInMinutes(config.getIdleConnectionTestPeriodInMinutes()); target.setIdleMaxAgeInMinutes(config.getIdleMaxAgeInMinutes()); target.setMaxConnectionsPerPartition(config.getMaxConnectionsPerPartition()); target.setMinConnectionsPerPartition(config.getMinConnectionsPerPartition()); target.setPartitionCount(config.getPartitionCount()); target.setAcquireIncrement(config.getAcquireIncrement()); target.setStatementsCacheSize(config.getStatementsCacheSize()); target.setDisableJMX(true); return target; }