/** * Load Database credentials * @return credentials */ private DatabaseCredentials loadDatabaseCredentials() { DatabaseCredentials databaseCredentials = new DatabaseCredentials(); try { databaseCredentials.setDatabasePort(Integer.parseInt(properties.getProperty("DatabasePort"))); } catch (Exception e) { databaseCredentials.setDatabasePort(DatabaseCredentials.DEFAULT_DATABASE_PORT); } try { databaseCredentials.setDatabasePageLimit(Integer.parseInt(properties.getProperty("DatabasePageLimit"))); } catch (Exception e) { databaseCredentials.setDatabasePageLimit(DatabaseCredentials.DEFAULT_DATABASE_PAGE_LIMIT); } try { databaseCredentials.setDatabaseConnections(Integer.parseInt(properties.getProperty("DatabaseConnections"))); } catch (Exception e) { databaseCredentials.setDatabaseConnections(DatabaseCredentials.DEFAULT_DATABASE_CONNECTIONS); } databaseCredentials.setDatabaseHost(properties.getProperty("DatabaseHost")); databaseCredentials.setDatabaseUsername(properties.getProperty("DatabaseUsername")); databaseCredentials.setDatabasePassword(properties.getProperty("DatabasePassword")); databaseCredentials.setDatabaseName(properties.getProperty("DatabaseName")); return databaseCredentials; }
static HikariConfig getHikariConfig(DatabaseCredentials c) { Properties props = new Properties(); String URL = String.format("jdbc:postgresql://%s:%d/%s?stringtype=unspecified", c.getDatabaseHost(), c.getDatabasePort(), c.getDatabaseName()); props.setProperty("dataSourceClassName", "org.postgresql.ds.PGSimpleDataSource"); props.setProperty("dataSource.url", URL); props.setProperty("dataSource.serverName", c.getDatabaseHost()); props.setProperty("dataSource.portNumber", Integer.toString(c.getDatabasePort())); props.setProperty("dataSource.user", c.getDatabaseUsername()); props.setProperty("dataSource.password", c.getDatabasePassword()); props.setProperty("dataSource.databaseName", c.getDatabaseName()); // this should be at least 30 seconds lower than underlying database props.setProperty("maxLifetime", "240000"); // set based on concurrency preference (corresponding to data ingestion in RabbitMQ) props.setProperty("maximumPoolSize", String.format("%d", Loader.getSettings().getDatabaseCredentials().getDatabaseConnections())); return new HikariConfig(props); } }
public CDREndpoint() { pageLimit = Loader.getSettings().getDatabaseCredentials().getDatabasePageLimit(); }
public UDREndpoint() { pageLimit = Loader.getSettings().getDatabaseCredentials().getDatabasePageLimit(); }
/** * Load Database credentials * @return credentials */ private DatabaseCredentials loadDatabaseCredentials() { DatabaseCredentials databaseCredentials = new DatabaseCredentials(); try { databaseCredentials.setDatabasePort(Integer.parseInt(properties.getProperty("DatabasePort"))); } catch (Exception e) { databaseCredentials.setDatabasePort(DatabaseCredentials.DEFAULT_DATABASE_PORT); } try { databaseCredentials.setDatabasePageLimit(Integer.parseInt(properties.getProperty("DatabasePageLimit"))); } catch (Exception e) { databaseCredentials.setDatabasePageLimit(DatabaseCredentials.DEFAULT_DATABASE_PAGE_LIMIT); } try { databaseCredentials.setDatabaseConnections(Integer.parseInt(properties.getProperty("DatabaseConnections"))); } catch (Exception e) { databaseCredentials.setDatabaseConnections(DatabaseCredentials.DEFAULT_DATABASE_CONNECTIONS); } databaseCredentials.setDatabaseHost(properties.getProperty("DatabaseHost")); databaseCredentials.setDatabaseUsername(properties.getProperty("DatabaseUsername")); databaseCredentials.setDatabasePassword(properties.getProperty("DatabasePassword")); databaseCredentials.setDatabaseName(properties.getProperty("DatabaseName")); return databaseCredentials; }
static HikariConfig getHikariConfig(DatabaseCredentials c) { Properties props = new Properties(); String URL = String.format("jdbc:postgresql://%s:%d/%s?stringtype=unspecified", c.getDatabaseHost(), c.getDatabasePort(), c.getDatabaseName()); props.setProperty("dataSourceClassName", "org.postgresql.ds.PGSimpleDataSource"); props.setProperty("dataSource.url", URL); props.setProperty("dataSource.serverName", c.getDatabaseHost()); props.setProperty("dataSource.portNumber", Integer.toString(c.getDatabasePort())); props.setProperty("dataSource.user", c.getDatabaseUsername()); props.setProperty("dataSource.password", c.getDatabasePassword()); props.setProperty("dataSource.databaseName", c.getDatabaseName()); // this should be at least 30 seconds lower than underlying database props.setProperty("maxLifetime", "240000"); // set based on concurrency preference (corresponding to data ingestion in RabbitMQ) props.setProperty("maximumPoolSize", String.format("%d", Loader.getSettings().getDatabaseCredentials().getDatabaseConnections())); return new HikariConfig(props); } }
public BillEndpoint() { pageLimit = Loader.getSettings().getDatabaseCredentials().getDatabasePageLimit(); }
/** * Load Database credentials * @return credentials */ private DatabaseCredentials loadDatabaseCredentials() { DatabaseCredentials databaseCredentials = new DatabaseCredentials(); try { databaseCredentials.setDatabasePort(Integer.parseInt(properties.getProperty("DatabasePort"))); } catch (Exception e) { databaseCredentials.setDatabasePort(DatabaseCredentials.DEFAULT_DATABASE_PORT); } try { databaseCredentials.setDatabasePageLimit(Integer.parseInt(properties.getProperty("DatabasePageLimit"))); } catch (Exception e) { databaseCredentials.setDatabasePageLimit(DatabaseCredentials.DEFAULT_DATABASE_PAGE_LIMIT); } try { databaseCredentials.setDatabaseConnections(Integer.parseInt(properties.getProperty("DatabaseConnections"))); } catch (Exception e) { databaseCredentials.setDatabaseConnections(DatabaseCredentials.DEFAULT_DATABASE_CONNECTIONS); } databaseCredentials.setDatabaseHost(properties.getProperty("DatabaseHost")); databaseCredentials.setDatabaseUsername(properties.getProperty("DatabaseUsername")); databaseCredentials.setDatabasePassword(properties.getProperty("DatabasePassword")); databaseCredentials.setDatabaseName(properties.getProperty("DatabaseName")); return databaseCredentials; }
static HikariConfig getHikariConfig(DatabaseCredentials c) { Properties props = new Properties(); String URL = String.format("jdbc:postgresql://%s:%d/%s?stringtype=unspecified", c.getDatabaseHost(), c.getDatabasePort(), c.getDatabaseName()); props.setProperty("dataSourceClassName", "org.postgresql.ds.PGSimpleDataSource"); props.setProperty("dataSource.url", URL); props.setProperty("dataSource.serverName", c.getDatabaseHost()); props.setProperty("dataSource.portNumber", Integer.toString(c.getDatabasePort())); props.setProperty("dataSource.user", c.getDatabaseUsername()); props.setProperty("dataSource.password", c.getDatabasePassword()); props.setProperty("dataSource.databaseName", c.getDatabaseName()); // this should be at least 30 seconds lower than underlying database props.setProperty("maxLifetime", "240000"); // set based on concurrency preference (corresponding to data ingestion in RabbitMQ) props.setProperty("maximumPoolSize", String.format("%d", Loader.getSettings().getDatabaseCredentials().getDatabaseConnections())); return new HikariConfig(props); } }