private Object loadSimpleDataSource(Reference ref) { PGSimpleDataSource ds = new PGSimpleDataSource(); return loadBaseDataSource(ds, ref); }
private Object loadSimpleDataSource(Reference ref) { PGSimpleDataSource ds = new PGSimpleDataSource(); return loadBaseDataSource(ds, ref); }
@Override protected DataSource createDataSource() { final PGSimpleDataSource datasource = new PGSimpleDataSource(); datasource.setServerName(hostname); datasource.setPortNumber(port); datasource.setUser(username); datasource.setPassword(password); datasource.setDatabaseName(database); datasource.setApplicationName("Hermes Unit Tests"); return datasource; }
/** Returns a data source for the PostgreSQL database. */ protected DataSource createDataSource() throws SQLException { DataSource candidate = super.createDataSource(); if (candidate instanceof BaseDataSource) { // Any kind of DataSource from the PostgreSQL driver. return candidate; } final PGSimpleDataSource source = new PGSimpleDataSource(); final Properties p = load(); int portNumber; try { portNumber = Integer.parseInt(p.getProperty("portNumber", "5432")); } catch (NumberFormatException exception) { portNumber = 5432; Logging.unexpectedException( "org.geotools.referencing.factory", DataSource.class, "<init>", exception); } source.setPortNumber(portNumber); source.setServerName(p.getProperty("serverName", "localhost")); source.setDatabaseName(p.getProperty("databaseName", "EPSG")); source.setUser(p.getProperty("user", "Geotools")); source.setPassword(p.getProperty("password", "Geotools")); source.setProperty("stringtype", "unspecified"); schema = p.getProperty("schema", null); return source; }
private Object loadSimpleDataSource(Reference ref) { PGSimpleDataSource ds = new PGSimpleDataSource(); return loadBaseDataSource(ds, ref); }
private Object loadSimpleDataSource(Reference ref) { PGSimpleDataSource ds = new PGSimpleDataSource(); return loadBaseDataSource(ds, ref); }
public static void setupInitialContext() throws Exception { System.setProperty(Context.INITIAL_CONTEXT_FACTORY, "org.apache.naming.java.javaURLContextFactory"); System.setProperty(Context.URL_PKG_PREFIXES, "org.apache.naming"); InitialContext ic = new InitialContext(); ic.createSubcontext("jdbc"); PGSimpleDataSource ds = new PGSimpleDataSource(); ds.setDatabaseName("postgres"); ds.setUser("postgres"); ds.setPassword("admin"); ic.bind("jdbc/something", ds); }
ic.createSubcontext("java:comp"); ic.createSubcontext("java:comp/env"); ic.createSubcontext("java:comp/env/jdbc"); final PGSimpleDataSource ds = new PGSimpleDataSource(); ds.setUrl("jdbc:postgresql://localhost:5432/mydb"); ds.setUser("postgres"); ds.setPassword("pg"); ic.bind("java:comp/env/jdbc/mydb", ds);
public DataSource getDatabase(String userName, String dbName, Map<String, String> properties) { final PGSimpleDataSource ds = new PGSimpleDataSource(); ds.setServerName("localhost"); ds.setPortNumber(port); ds.setDatabaseName(dbName); ds.setUser(userName); properties.forEach((propertyKey, propertyValue) -> { try { ds.setProperty(propertyKey, propertyValue); } catch (SQLException e) { throw new RuntimeException(e); } }); return ds; }
/** * Create a new Datasource given DBInfo. * More common usage is to call createDatasource(). */ public DataSource createDataSourceFromConnectionInfo(final ConnectionInfo connectionInfo) throws SQLException { final PGSimpleDataSource ds = new PGSimpleDataSource(); ds.setPortNumber(connectionInfo.getPort()); ds.setDatabaseName(connectionInfo.getDbName()); ds.setUser(connectionInfo.getUser()); Set<Entry<String, String>> properties = connectionInfo.getProperties().entrySet(); for (Entry<String, String> property : properties) { ds.setProperty(property.getKey(), property.getValue()); } return ds; }
@Override public void initialize() throws IOException, SQLException { super.initialize(); dataSource = new PGSimpleDataSource(); ((PGSimpleDataSource) dataSource).setDatabaseName(databaseName); ((PGSimpleDataSource) dataSource).setUser(username); ((PGSimpleDataSource) dataSource).setPassword(password); ((PGSimpleDataSource) dataSource).setUrl(jdbcConnectionString); }
public static synchronized void INIT() { PGSimpleDataSource ds = new PGSimpleDataSource(); ds.setUrl(PG_URL); try (final Connection cnx = ds.getConnection(); final Statement st = cnx.createStatement()) { st.execute(TestSuite.getResourceAsString(PG_SQL)); } catch (Exception ex) { throw new RuntimeException(ex); } TestSuite.setupSessionFactoryBuilder(ds); } }
@BeforeClass public static void init() throws SQLException, IOException { PGSimpleDataSource pgDs = new PGSimpleDataSource(); pgDs.setUrl(PG_URL); sessionFactory = JsonHandlersTestApi.setUpDb(pgDs, PG_SQL); }
Database() { data_source = new PGSimpleDataSource(); data_source.setServerName(Config.INSTANCE.db_host); data_source.setPortNumber(Config.INSTANCE.db_port); data_source.setDatabaseName(Config.INSTANCE.db_database); data_source.setUser(Config.INSTANCE.db_user); data_source.setPassword(Config.INSTANCE.db_password); data_source.setApplicationName("jpgAgent: " + Config.INSTANCE.hostname); if (Config.INSTANCE.disable_prepared_statement) { data_source.setPreparedStatementCacheQueries(0); } }
@Override public DataSource actualDataSource() { PGSimpleDataSource dataSource = new PGSimpleDataSource(); dataSource.setDatabaseName(jdbcDatabase); dataSource.setUser(jdbcUser); dataSource.setPassword(jdbcPassword); dataSource.setServerName(jdbcHost); dataSource.setPortNumber(Integer.valueOf(jdbcPort)); return dataSource; }
@Override public DataSource dataSource() { PGSimpleDataSource dataSource = new PGSimpleDataSource(); dataSource.setDatabaseName("high_performance_java_persistence"); dataSource.setServerName("localhost"); dataSource.setUser("postgres"); dataSource.setPassword("admin"); return dataSource; }
@Ignore @Test public void testPostgres() throws Exception { PGSimpleDataSource dataSource = new PGSimpleDataSource(); dataSource.setPortNumber(5432); dataSource.setUser("sa"); dataSource.setPassword("sa"); dataSource.setServerName("localhost"); dataSource.setDatabaseName("commitmarkableresource"); doTest(dataSource); }
@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; }
private void addTenantConnectionProvider(String tenantId) { PGSimpleDataSource defaultDataSource = (PGSimpleDataSource) database().dataSourceProvider().dataSource(); Properties properties = properties(); PGSimpleDataSource tenantDataSource = new PGSimpleDataSource(); tenantDataSource.setDatabaseName(defaultDataSource.getDatabaseName()); tenantDataSource.setCurrentSchema(tenantId); tenantDataSource.setServerName(defaultDataSource.getServerName()); tenantDataSource.setUser(defaultDataSource.getUser()); tenantDataSource.setPassword(defaultDataSource.getPassword()); properties.put( Environment.DATASOURCE, dataSourceProxyType().dataSource(tenantDataSource) ); addTenantConnectionProvider(tenantId, tenantDataSource, properties); }
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; }