private DBI ensureDBI(CacheScheduler.EntryImpl<JdbcExtractionNamespace> id, JdbcExtractionNamespace namespace) { final CacheScheduler.EntryImpl<JdbcExtractionNamespace> key = id; DBI dbi = null; if (dbiCache.containsKey(key)) { dbi = dbiCache.get(key); } if (dbi == null) { final DBI newDbi = new DBI( namespace.getConnectorConfig().getConnectURI(), namespace.getConnectorConfig().getUser(), namespace.getConnectorConfig().getPassword() ); dbiCache.putIfAbsent(key, newDbi); dbi = dbiCache.get(key); } return dbi; }
connectorConfig.getConnectURI(), connectorConfig.getUser(), connectorConfig.getPassword() ); dbi.registerMapper(new KeyValueResultSetMapper(keyColumn, valueColumn));
protected BasicDataSource getDatasource(MetadataStorageConnectorConfig connectorConfig) { BasicDataSource dataSource = new BasicDataSource(); dataSource.setUsername(connectorConfig.getUser()); dataSource.setPassword(connectorConfig.getPassword()); String uri = connectorConfig.getConnectURI(); dataSource.setUrl(uri); dataSource.setTestOnBorrow(true); dataSource.setValidationQuery(getValidationQuery()); return dataSource; }
protected BasicDataSource getDatasource() { MetadataStorageConnectorConfig connectorConfig = getConfig(); BasicDataSource dataSource; try { Properties dbcpProperties = connectorConfig.getDbcpProperties(); if (dbcpProperties != null) { dataSource = BasicDataSourceFactory.createDataSource(dbcpProperties); } else { dataSource = new BasicDataSource(); } } catch (Exception e) { throw new RuntimeException(e); } dataSource.setUsername(connectorConfig.getUser()); dataSource.setPassword(connectorConfig.getPassword()); String uri = connectorConfig.getConnectURI(); dataSource.setUrl(uri); dataSource.setValidationQuery(getValidationQuery()); dataSource.setTestOnBorrow(true); return dataSource; }
Assert.assertEquals(connectURI, config.getConnectURI()); Assert.assertEquals(user, config.getUser()); Assert.assertEquals(pwd, config.getPassword()); Properties dbcpProperties = config.getDbcpProperties(); Assert.assertEquals(dbcpProperties.getProperty("maxConnLifetimeMillis"), "1200000");
private void testMetadataStorageConnectionConfig( boolean createTables, String host, int port, String connectURI, String user, String pwdString, String pwd ) throws Exception { MetadataStorageConnectorConfig config = jsonMapper.readValue( "{" + "\"createTables\": \"" + createTables + "\"," + "\"host\": \"" + host + "\"," + "\"port\": \"" + port + "\"," + "\"connectURI\": \"" + connectURI + "\"," + "\"user\": \"" + user + "\"," + "\"password\": " + pwdString + "}", MetadataStorageConnectorConfig.class ); Assert.assertEquals(host, config.getHost()); Assert.assertEquals(port, config.getPort()); Assert.assertEquals(connectURI, config.getConnectURI()); Assert.assertEquals(user, config.getUser()); Assert.assertEquals(pwd, config.getPassword()); Assert.assertNull(config.getDbcpProperties()); }
protected BasicDataSource getDatasource(MetadataStorageConnectorConfig connectorConfig) { BasicDataSource dataSource = new BasicDataSource(); dataSource.setUsername(connectorConfig.getUser()); dataSource.setPassword(connectorConfig.getPassword()); String uri = connectorConfig.getConnectURI(); dataSource.setUrl(uri); dataSource.setTestOnBorrow(true); dataSource.setValidationQuery(getValidationQuery()); return dataSource; }
protected BasicDataSource getDatasource() { MetadataStorageConnectorConfig connectorConfig = getConfig(); BasicDataSource dataSource = new BasicDataSource(); dataSource.setUsername(connectorConfig.getUser()); dataSource.setPassword(connectorConfig.getPassword()); String uri = connectorConfig.getConnectURI(); dataSource.setUrl(uri); dataSource.setValidationQuery(getValidationQuery()); dataSource.setTestOnBorrow(true); return dataSource; }