Java PGPoolingDataSource.setPortNumber方法代码示例

import org.postgresql.ds.PGPoolingDataSource; //导入方法依赖的package包/类
@BeforeClass(alwaysRun = true)
static public void setUpDataSource() throws Exception {
    File propertiesFile = new File("config/application.properties");
    if (!propertiesFile.exists()) {
        throw new IllegalStateException(
                "Missing configuration file, please create config/application.properties based on sample.");
    }
    Properties props = new Properties();
    try (FileInputStream fis = new FileInputStream(propertiesFile)) {
        props.load(fis);
    }

    PGPoolingDataSource dataSource = new PGPoolingDataSource();
    dataSource.setServerName(props.getProperty("db.server"));
    dataSource.setDatabaseName(props.getProperty("db.database"));
    dataSource.setUser(props.getProperty("db.user"));
    dataSource.setPassword(props.getProperty("db.password"));
    dataSource.setPortNumber(Integer.parseInt(props.getProperty("db.port")));
    BaseITest.dataSource = dataSource;
}
 

import org.postgresql.ds.PGPoolingDataSource; //导入方法依赖的package包/类
@Override
public DataSource getDataSource() {
    URI uri = getURIFromEnv();
    String host = uri.getHost();
    int port = uri.getPort();
    String db = uri.getPath().substring(1);
    String username = uri.getUserInfo().split(":")[0];
    String password = uri.getUserInfo().split(":")[1];

    PGPoolingDataSource ds = new PGPoolingDataSource();
    ds.setSsl(true);
    ds.setSslMode("verify-full");
    ds.setUser(username);
    ds.setServerName(host);
    ds.setPortNumber(port);
    ds.setPassword(password);
    ds.setDatabaseName(db);
    ds.setInitialConnections(0);
    Integer maxConnections = getMaxConnectionsFromEnv();
    if(maxConnections != null)
        ds.setMaxConnections(maxConnections);
    return ds;
}
 

import org.postgresql.ds.PGPoolingDataSource; //导入方法依赖的package包/类
private DataSource lookup( String name )
{
    Configuration map = configurationService.getConfiguration( name );

    PGPoolingDataSource ds = new PGPoolingDataSource();
    ds.setApplicationName( "OpenData" );
    ds.setDataSourceName( map.getString( "name", () -> map.getString( "database" ) ) );
    ds.setMaxConnections( map.getInt( "connections.max", 10 ) );
    ds.setInitialConnections( map.getInt( "connections.initial", 0 ) );

    ds.setUser( Objects.requireNonNull( map.getString( "username" ), "username required" ) );
    ds.setPassword( Objects.requireNonNull( map.getString( "password" ), "password required" ) );
    ds.setServerName( Objects.requireNonNull( map.getString( "hostname" ), "hostname required" ) );
    ds.setDatabaseName( map.getString( "database", () -> map.getString( "name" ) ) );
    ds.setPortNumber( map.getInt( "port", 0 ) );

    return ds;
}
 

import org.postgresql.ds.PGPoolingDataSource; //导入方法依赖的package包/类
public PGPoolingDataSource build(Environment environment) {
    final PGPoolingDataSource pg_ds = new PGPoolingDataSource();
    pg_ds.setDataSourceName("pg_ds");
    pg_ds.setServerName(this.getHost());
    pg_ds.setDatabaseName(this.getDb());
    pg_ds.setUser(this.getUser());
    pg_ds.setPassword(this.getPassword());
    pg_ds.setPortNumber(this.getPort());
    pg_ds.setMaxConnections(this.getMaxConnections());
    environment.lifecycle().manage(new Managed() {
        @Override
        public void start() {
        }

        @Override
        public void stop() {
            pg_ds.close();
        }
    });
    return pg_ds;
}
 

import org.postgresql.ds.PGPoolingDataSource; //导入方法依赖的package包/类
@Test
public void createConnectionPool() throws SQLException {
    PGPoolingDataSource connectionPool = new PGPoolingDataSource();
    connectionPool.setApplicationName(CONFIG.DB_SERVER_NAME);
    connectionPool.setServerName(CONFIG.DB_SERVER_NAME);
    connectionPool.setPortNumber(CONFIG.DB_PORT_NUMBER);
    connectionPool.setDatabaseName(CONFIG.DB_NAME);
    connectionPool.setUser(CONFIG.DB_USER);
    connectionPool.setPassword(CONFIG.DB_PASSWORD);
    connectionPool.setMaxConnections(CONFIG.DB_MAX_CONNECTIONS);

    Connection c = connectionPool.getConnection();

    // request id for user dola with mode 1
    CallableStatement s = c.prepareCall("{ ? = call request_id( ? , ? ) }");
    s.registerOutParameter(1, Types.INTEGER);
    s.setString(2, "blubbedi");
    s.setInt(3, 1);
    s.execute();

    Integer client_id = s.getInt(1);
    s.close();
    assertNotNull("returned client id is null", client_id);
}
 

import org.postgresql.ds.PGPoolingDataSource; //导入方法依赖的package包/类
public PostgresqlConnectionProvider(@NonNls @NotNull final String serverDnsHostName, @NonNls @NotNull final String databaseName, @NonNls @NotNull final String applicationName, @NonNls @NotNull final String userName, @NonNls @NotNull final String password)
{
	dataSource = new PGPoolingDataSource();
	dataSource.setDataSourceName(randomUUID().toString());
	dataSource.setInitialConnections(2);
	dataSource.setMaxConnections(10);

	dataSource.setServerName(serverDnsHostName);
	dataSource.setPortNumber(DefaultPostgresPort);
	dataSource.setTcpKeepAlive(true);
	dataSource.setSocketTimeout(ThirtySeconds);

	dataSource.setSsl(false);
	dataSource.setProtocolVersion(0);
	dataSource.setSendBufferSize(FourKilobytes);
	dataSource.setReceiveBufferSize(FourKilobytes);
	dataSource.setBinaryTransfer(true);

	dataSource.setDatabaseName(databaseName);
	dataSource.setApplicationName(applicationName);
	dataSource.setUser(userName);
	dataSource.setPassword(password);
}
 

import org.postgresql.ds.PGPoolingDataSource; //导入方法依赖的package包/类
private static DataSource getDataSource(SCEIApplicationConfig config) {
    final PGPoolingDataSource source = new PGPoolingDataSource();
    source.setDataSourceName("PostgresDB");
    source.setServerName(config.getDatabaseServerName());
    source.setDatabaseName(config.getDatabaseName());
    source.setPortNumber(config.getDatabasePort());
    source.setUser(config.getDatabaseUser());
    source.setPassword(config.getDatabasePassword());
    source.setMaxConnections(10);
    return source;
}
 

import org.postgresql.ds.PGPoolingDataSource; //导入方法依赖的package包/类
private void connectToDatabase() throws ClassNotFoundException {
    String type = getConfig().getString("database.type"),
            host = getConfig().getString("database.host"),
            dbName = getConfig().getString("database.db_name"),
            user = getConfig().getString("database.user"),
            pass = getConfig().getString("database.pass");
    int port = getConfig().getInt("database.port");

    SQLBackend dbType = SQLBackend.parse(type);
    stmts = new StatementProvider("/db", dbType);

    switch(dbType) {
        case MYSQL:
            Class.forName("com.mysql.jdbc.Driver");
            MysqlConnectionPoolDataSource msqlpool = new MysqlConnectionPoolDataSource();
            msqlpool.setDatabaseName(dbName);
            msqlpool.setUser(user);
            msqlpool.setPassword(pass);
            msqlpool.setServerName(host);
            msqlpool.setPort(port);

            connections = msqlpool;
            break;
        case POSTGRES:
            Class.forName("org.postgresql.Driver");
            PGPoolingDataSource pgpool = new PGPoolingDataSource();
            pgpool.setDataSourceName("mcanalytics-pg-pool");
            pgpool.setServerName(host);
            pgpool.setPortNumber(port);
            pgpool.setDatabaseName(dbName);
            pgpool.setUser(user);
            pgpool.setPassword(pass);
            pgpool.setMaxConnections(10);

            connections = pgpool;
            break;
        default:
            throw new IllegalStateException("unsupported database type in config.yml");
    }

}
 

import org.postgresql.ds.PGPoolingDataSource; //导入方法依赖的package包/类
private DataSource setDataSource(EmbeddedPostgres server) throws Exception {
  PGPoolingDataSource dataSource = new PGPoolingDataSource();
  dataSource.setUser("kloopzcm");
  dataSource.setPassword("testpwd");
  dataSource.setPortNumber(server.getPort());
  dataSource.setDatabaseName("kloopzdb");

  Flyway flyway = new Flyway();
  flyway.setPlaceholderReplacement(false);
  flyway.setLocations("classpath:deployer");
  flyway.setDataSource(dataSource);
  flyway.migrate();

  return dataSource;
}