protected DataSource createDataSource(HostAndPort bindingHostAndPort) { PGSimpleDataSource ds = new PGSimpleDataSource(); ds.setPortNumber(bindingHostAndPort.getPort()); ds.setServerName(bindingHostAndPort.getHost()); ds.setUser(config.getUsername()); ds.setPassword(config.getPassword()); ds.setDatabaseName(config.getDb()); ds.setSsl(false); try ( Connection conn = ds.getConnection(); Statement stat = conn.createStatement(); ResultSet rs = stat.executeQuery("SELECT 1")) { rs.next(); } catch (SQLException ex) { throw new RuntimeException(ex.getLocalizedMessage()); } return ds; }
@Override public DataSource dataSource() { PGSimpleDataSource dataSource = new PGSimpleDataSource(); dataSource.setDatabaseName( "high_performance_java_persistence" ); dataSource.setServerName( host() ); dataSource.setPortNumber( port() ); dataSource.setUser( username() ); dataSource.setPassword( password() ); dataSource.setSsl( false ); return dataSource; }
public static PGSimpleDataSource getPostgresDataSource(PostgresIOTestPipelineOptions options) { PGSimpleDataSource dataSource = new PGSimpleDataSource(); dataSource.setDatabaseName(options.getPostgresDatabaseName()); dataSource.setServerName(options.getPostgresServerName()); dataSource.setPortNumber(options.getPostgresPort()); dataSource.setUser(options.getPostgresUsername()); dataSource.setPassword(options.getPostgresPassword()); dataSource.setSsl(options.getPostgresSsl()); return dataSource; }