private Object loadPoolingDataSource(Reference ref) { // If DataSource exists, return it String name = getProperty(ref, "dataSourceName"); PGPoolingDataSource pds = PGPoolingDataSource.getDataSource(name); if (pds != null) { return pds; } // Otherwise, create a new one pds = new PGPoolingDataSource(); pds.setDataSourceName(name); loadBaseDataSource(pds, ref); String min = getProperty(ref, "initialConnections"); if (min != null) { pds.setInitialConnections(Integer.parseInt(min)); } String max = getProperty(ref, "maxConnections"); if (max != null) { pds.setMaxConnections(Integer.parseInt(max)); } return pds; }
@Override public DataSource createDataSource(Properties properties) throws SQLException { if (properties == null) { properties = new Properties(); } PGPoolingDataSource dataSource = new PGPoolingDataSource(); // Set dataSourceName, databaseName, user, and password dataSource.setDataSourceName(properties.getProperty(JDBC_DATASOURCE_NAME)); String url = properties.getProperty(JDBC_URL); if(url != null) { dataSource.setUrl(url); } dataSource.setPortNumber(Integer.valueOf(properties.getProperty(JDBC_PORT_NUMBER, Integer.toString(dataSource.getPortNumber())))); dataSource.setServerName(properties.getProperty(JDBC_SERVER_NAME, dataSource.getServerName())); dataSource.setUser(properties.getProperty(JDBC_USER, dataSource.getUser())); dataSource.setPassword(properties.getProperty(JDBC_PASSWORD, dataSource.getPassword())); dataSource.setDatabaseName(properties.getProperty(JDBC_DATABASE_NAME, dataSource.getDatabaseName())); return new DataSourceWrapper(dataSource); }
|| !dbName.equals(old.getDatabaseName()) || !server.equals(old.getServerName()) || !port.equals(old.getPortNumber()) || !user.equals(old.getUser()) || !pass.equals(old.getPassword()) || !maxConnections.equals(old.getMaxConnections()) || !initialConnections.equals(old.getInitialConnections()); PGPoolingDataSource nu = new PGPoolingDataSource(); nu.setServerName(server); nu.setPortNumber(port); nu.setDatabaseName(dbName); nu.setUser(user); nu.setPassword(pass); nu.setMaxConnections(maxConnections); nu.setInitialConnections(initialConnections); nu.initialize(); old.close(); } catch (Exception e) { log.debug("[IGNORED] Exception while closing the datasource: ", e);
ds = new PGPoolingDataSource(); ds.setMaxConnections(Integer.parseInt((String) db.get("perf_maxconnections"))); ds.setServerName((String) db.get("perf_servername")); ds.setPortNumber(Integer.parseInt((String) db.get("perf_port"))); ds.setDatabaseName((String) db.get("perf_db")); ds.setUser((String) db.get("perf_user")); ds.setPassword((String) db.get("perf_password")); ds.setSsl((Boolean) Boolean.parseBoolean((String) db.get("perf_ssl"))); ds.setInitialConnections(Integer.parseInt((String) db.get("perf_initialconnections"))); System.out.println("Binding to " + ds.getServerName() + ":" + ds.getPortNumber()); InitialContextFactoryForTest.bind("java:fgsmsPerformance", ds); ds = new PGPoolingDataSource(); ds.setMaxConnections(Integer.parseInt((String) db.get("config_maxconnections"))); ds.setServerName((String) db.get("config_servername")); ds.setPortNumber(Integer.parseInt((String) db.get("config_port"))); ds.setDatabaseName((String) db.get("config_db")); ds.setUser((String) db.get("config_user")); ds.setPassword((String) db.get("config_password")); ds.setSsl((Boolean) Boolean.parseBoolean((String) db.get("config_ssl"))); ds.setInitialConnections(Integer.parseInt((String) db.get("config_initialconnections"))); System.out.println("Binding to " + ds.getServerName() + ":" + ds.getPortNumber()); InitialContextFactoryForTest.bind("java:fgsmsConfig", ds); } catch (Exception ex) {
static PGPoolingDataSource createDataSource(PostGISOpts pgopts) { PGPoolingDataSource dataSource = new PGPoolingDataSource(); dataSource.setServerName(pgopts.host()); dataSource.setDatabaseName(pgopts.db()); dataSource.setPortNumber(pgopts.port()); dataSource.setUser(pgopts.user()); if (pgopts.passwd() != null) { dataSource.setPassword(Password.toString(pgopts.passwd())); } return dataSource; }
public PostgresStore(PostgresConfiguration config, String schema) { this.pool = new PGPoolingDataSource(); this.pool.setUrl(config.getJdbcUrl()); this.pool.setUser(config.getUsername()); this.pool.setPassword(config.getPassword()); this.pool.setCurrentSchema(schema); }
@Override public Map<String, ?> properties(RequestContext ctx) throws Exception { Map<String, Object> result = new HashMap<>(); PGPoolingDataSource ds = this.ds; result.put("server", ds.getServerName() ); result.put("port", ds.getPortNumber()); result.put("db", ds.getDatabaseName()); result.put("user", ds.getUser()); result.put("password", ds.getPassword()); result.put("max-connections", ds.getMaxConnections()); result.put("initial-connections", ds.getInitialConnections()); List<String> schemas = configuration.exposedSchemas(); if (schemas != null && schemas.size() > 0) { result.put("schemas", schemas); } schemas = configuration.blockedSchemas(); if (schemas != null && schemas.size() > 0) { result.put("blocked-schemas", schemas); } if (configuration.defaultSchema() != null) { result.put("default-schema", configuration.defaultSchema()); } result.put("allow-create-schema", configuration.allowCreateSchema()); result.put("include-total-count", configuration.includeTotalCount()); return result; }
source = new PGPoolingDataSource(); source.setDataSourceName(properties.getProperty("DATABASE_NAME")); source.setServerName("127.0.0.1"); source.setDatabaseName(properties.getProperty("DATABASE_NAME")); source.setUser(properties.getProperty("DATABASE_USER")); source.setPassword(properties.getProperty("DATABASE_PASS")); source.setMaxConnections(50); DataModel model =new PostgreSQLJDBCDataModel( source, "mahout_teble", "user_id", "item_id", "preference", "timestamp" ) )
@Override public void close() { if (db != null) { db.close(); } db = null; }
public void testConfigure() throws Exception { Database db = new Database(); db.configure(props); assertTrue(db.getDataSource() != null); assertTrue(db.getDataSource() instanceof PGPoolingDataSource); assertEquals("PostgreSQL", db.getPlatform()); assertEquals("dbserver.mydomain.org", ((PGPoolingDataSource) db.getDataSource()).getServerName()); assertEquals("test", ((PGPoolingDataSource) db.getDataSource()).getDatabaseName()); assertEquals(10, ((PGPoolingDataSource) db.getDataSource()).getMaxConnections()); }
@Override public DataSource createDataSource(Properties properties) throws SQLException { if (properties == null) { properties = new Properties(); } if(properties.getProperty(JDBC_DATASOURCE_NAME) == null) { properties.setProperty(JDBC_DATASOURCE_NAME, DataSourceFactoryImpl.class.getSimpleName() + "_" + dataSourceCount.getAndAdd(1)); } PGPoolingDataSource dataSource = PGPoolingDataSource.getDataSource(properties.getProperty(JDBC_DATASOURCE_NAME)); if(dataSource == null) { dataSource = new PGPoolingDataSource(); // Set dataSourceName, databaseName, user, and password dataSource.setDataSourceName(properties.getProperty(JDBC_DATASOURCE_NAME)); String url = properties.getProperty(JDBC_URL); if(url != null) { dataSource.setUrl(url); } dataSource.setPortNumber(Integer.valueOf(properties.getProperty(JDBC_PORT_NUMBER, Integer.toString(dataSource.getPortNumber())))); dataSource.setServerName(properties.getProperty(JDBC_SERVER_NAME, dataSource.getServerName())); dataSource.setUser(properties.getProperty(JDBC_USER, dataSource.getUser())); dataSource.setPassword(properties.getProperty(JDBC_PASSWORD, dataSource.getPassword())); dataSource.setDatabaseName(properties.getProperty(JDBC_DATABASE_NAME, dataSource.getDatabaseName())); } return new DataSourceWrapper(dataSource); }
@Override public void stop() { PGPoolingDataSource ds = this.ds; this.ds = null; if ( ds != null ) { ds.close(); } }
@Override public DataSource createDataSource(Properties properties) throws SQLException { if (properties == null) { properties = new Properties(); } if(properties.getProperty(JDBC_DATASOURCE_NAME) == null) { properties.setProperty(JDBC_DATASOURCE_NAME, DataSourceFactoryImpl.class.getSimpleName() + "_" + dataSourceCount.getAndAdd(1)); } PGPoolingDataSource dataSource = PGPoolingDataSource.getDataSource(properties.getProperty(JDBC_DATASOURCE_NAME)); if(dataSource == null) { dataSource = new PGPoolingDataSource(); // Set dataSourceName, databaseName, user, and password dataSource.setDataSourceName(properties.getProperty(JDBC_DATASOURCE_NAME)); String url = properties.getProperty(JDBC_URL); if(url != null) { dataSource.setUrl(url); } dataSource.setPortNumber(Integer.valueOf(properties.getProperty(JDBC_PORT_NUMBER, Integer.toString(dataSource.getPortNumber())))); dataSource.setServerName(properties.getProperty(JDBC_SERVER_NAME, dataSource.getServerName())); dataSource.setUser(properties.getProperty(JDBC_USER, dataSource.getUser())); dataSource.setPassword(properties.getProperty(JDBC_PASSWORD, dataSource.getPassword())); dataSource.setDatabaseName(properties.getProperty(JDBC_DATABASE_NAME, dataSource.getDatabaseName())); } return new DataSourceWrapper(dataSource); }
private Object loadPoolingDataSource(Reference ref) { // If DataSource exists, return it String name = getProperty(ref, "dataSourceName"); PGPoolingDataSource pds = PGPoolingDataSource.getDataSource(name); if (pds != null) { return pds; } // Otherwise, create a new one pds = new PGPoolingDataSource(); pds.setDataSourceName(name); loadBaseDataSource(pds, ref); String min = getProperty(ref, "initialConnections"); if (min != null) { pds.setInitialConnections(Integer.parseInt(min)); } String max = getProperty(ref, "maxConnections"); if (max != null) { pds.setMaxConnections(Integer.parseInt(max)); } return pds; }
import javax.servlet.ServletContextEvent; import javax.servlet.ServletContextListener; public class MyClass implements ServletContextListener { private String db = "foo"; @Override public void contextDestroyed(ServletContextEvent sce) { PGPoolingDataSource connectionPool = (PGPoolingDataSource)new InitialContext().lookup(db); if(connectionPool != null) { connectionPool.close(); new InitialContext().unbind(db); } } }
private Object loadPoolingDataSource(Reference ref) { // If DataSource exists, return it String name = getProperty(ref, "dataSourceName"); PGPoolingDataSource pds = PGPoolingDataSource.getDataSource(name); if (pds != null) { return pds; } // Otherwise, create a new one pds = new PGPoolingDataSource(); pds.setDataSourceName(name); loadBaseDataSource(pds, ref); String min = getProperty(ref, "initialConnections"); if (min != null) { pds.setInitialConnections(Integer.parseInt(min)); } String max = getProperty(ref, "maxConnections"); if (max != null) { pds.setMaxConnections(Integer.parseInt(max)); } return pds; }
/** * {@inheritDoc} */ @Override public void finalize() throws Throwable { super.finalize(); if (datasource instanceof com.zaxxer.hikari.HikariDataSource) { LOG.info("Finalise - Closing datasource for Database " + getURL() + "(" + toString() + ") with ClassLoader " + getClass().getClassLoader()); ((com.zaxxer.hikari.HikariDataSource) datasource).close(); } else if (datasource instanceof org.postgresql.ds.PGPoolingDataSource) { LOG.info("Finalise - Closing datasource for Database " + getURL() + "(" + toString() + ") with ClassLoader " + getClass().getClassLoader()); ((org.postgresql.ds.PGPoolingDataSource) datasource).close(); } else if (datasource instanceof org.postgresql.jdbc2.optional.PoolingDataSource) { LOG.info("Finalise - Closing datasource for Database " + getURL() + "(" + toString() + ") with ClassLoader " + getClass().getClassLoader()); ((org.postgresql.jdbc2.optional.PoolingDataSource) datasource).close(); } else { LOG.warn("Finalise - Could not close datasource for Database " + getURL() + "(" + toString() + ") with ClassLoader " + getClass().getClassLoader() + " - " + datasource.getClass().toString()); } }
private Object loadPoolingDataSource(Reference ref) { // If DataSource exists, return it String name = getProperty(ref, "dataSourceName"); PGPoolingDataSource pds = PGPoolingDataSource.getDataSource(name); if (pds != null) { return pds; } // Otherwise, create a new one pds = new PGPoolingDataSource(); pds.setDataSourceName(name); loadBaseDataSource(pds, ref); String min = getProperty(ref, "initialConnections"); if (min != null) { pds.setInitialConnections(Integer.parseInt(min)); } String max = getProperty(ref, "maxConnections"); if (max != null) { pds.setMaxConnections(Integer.parseInt(max)); } return pds; }
/** * {@inheritDoc} */ @Override public void finalize() throws Throwable { super.finalize(); if (datasource instanceof com.zaxxer.hikari.HikariDataSource) { LOG.info("Finalise - Closing datasource for Database " + getURL() + "(" + toString() + ") with ClassLoader " + getClass().getClassLoader()); ((com.zaxxer.hikari.HikariDataSource) datasource).close(); } else if (datasource instanceof org.postgresql.ds.PGPoolingDataSource) { LOG.info("Finalise - Closing datasource for Database " + getURL() + "(" + toString() + ") with ClassLoader " + getClass().getClassLoader()); ((org.postgresql.ds.PGPoolingDataSource) datasource).close(); } else if (datasource instanceof org.postgresql.jdbc2.optional.PoolingDataSource) { LOG.info("Finalise - Closing datasource for Database " + getURL() + "(" + toString() + ") with ClassLoader " + getClass().getClassLoader()); ((org.postgresql.jdbc2.optional.PoolingDataSource) datasource).close(); } else { LOG.warn("Finalise - Could not close datasource for Database " + getURL() + "(" + toString() + ") with ClassLoader " + getClass().getClassLoader() + " - " + datasource.getClass().toString()); } }
LOG.info("Shutdown - Closing datasource for Database " + getURL() + "(" + toString() + ") with ClassLoader " + getClass().getClassLoader()); ((org.postgresql.ds.PGPoolingDataSource) datasource).close(); } else if (datasource instanceof org.postgresql.jdbc2.optional.PoolingDataSource) { LOG.info("Shutdown - Closing datasource for Database " + getURL() + "(" + toString()