ConfigurationDBRef dbConfig = new ConfigurationDBRef(); dbConfig.setDriverManagerConnection("org.postgresql.Driver", "jdbc:postgresql://localhost:5432/database_name", "user", "password"); Configuration engineConfig = new Configuration(); engineConfig.addDatabaseReference("database_alias", dbConfig); esperEngine = EPServiceProviderManager.getDefaultProvider(engineConfig);
/** * Adds a mapping of a java.sql.Types type to a Java type. * <p> * The mapping dictates to the engine how the output column should be * represented as a Java Object. * <p> * Accepts a Java class for the Java type parameter. See {@link DatabaseTypeEnum} for valid values. * @param sqlType is a java.sql.Types constant, for which output columns are converted to java type * @param javaTypeName is a Java class */ public void addSqlTypesBinding(int sqlType, Class javaTypeName) { addSqlTypesBinding(sqlType, javaTypeName.getName()); }
public ColumnSettings getQuerySetting(String databaseName) throws DatabaseConfigException { ConfigurationDBRef config = mapDatabaseRef.get(databaseName); if (config == null) { throw new DatabaseConfigException("Cannot locate configuration information for database '" + databaseName + '\''); } return new ColumnSettings(config.getMetadataRetrievalEnum(), config.getColumnChangeCase(), config.getSqlTypesMapping()); } }
public DatabaseConnectionFactory getConnectionFactory(String databaseName) throws DatabaseConfigException { // check if we already have a reference DatabaseConnectionFactory factory = connectionFactories.get(databaseName); if (factory != null) { return factory; } ConfigurationDBRef config = mapDatabaseRef.get(databaseName); if (config == null) { throw new DatabaseConfigException("Cannot locate configuration information for database '" + databaseName + '\''); } ConfigurationDBRef.ConnectionSettings settings = (ConfigurationDBRef.ConnectionSettings) config.getConnectionSettings(); if (config.getConnectionFactoryDesc() instanceof ConfigurationDBRef.DriverManagerConnection) { ConfigurationDBRef.DriverManagerConnection dmConfig = (ConfigurationDBRef.DriverManagerConnection) config.getConnectionFactoryDesc(); factory = new DatabaseDMConnFactory(dmConfig, settings); } else { ConfigurationDBRef.DataSourceConnection dsConfig = (ConfigurationDBRef.DataSourceConnection) config.getConnectionFactoryDesc(); factory = new DatabaseDSConnFactory(dsConfig, settings); } connectionFactories.put(databaseName, factory); return factory; }
ConfigurationDBRef configDBRef = new ConfigurationDBRef(); configuration.addDatabaseReference(name, configDBRef); configDBRef.setDataSourceConnection(lookup, properties); String password = subElement.getAttributes().getNamedItem("password").getTextContent(); Properties properties = handleProperties(subElement, "connection-arg"); configDBRef.setDriverManagerConnection(className, url, userName, password, properties); configDBRef.setConnectionLifecycleEnum(ConfigurationDBRef.ConnectionLifecycleEnum.valueOf(value.toUpperCase())); configDBRef.setConnectionAutoCommit(Boolean.parseBoolean(autoCommit)); configDBRef.setConnectionTransactionIsolation(Integer.parseInt(transactionIsolation)); configDBRef.setConnectionCatalog(catalog); configDBRef.setConnectionReadOnly(Boolean.parseBoolean(readOnly)); configDBRef.setColumnChangeCase(parsed); configDBRef.setMetadataOrigin(parsed); configDBRef.addSqlTypesBinding(sqlTypeInt, javaType); configDBRef.setExpiryTimeCache(Double.parseDouble(maxAge), Double.parseDouble(purgeInterval), refTypeEnum); configDBRef.setLRUCache(Integer.parseInt(size));
Properties pps = new Properties(); String[] props = dbInfo.getProps(); ConfigurationDBRef configDB = new ConfigurationDBRef(); for(String prop : props) { String[] fields = prop.split("="); configDB.setDataSourceFactory(pps, dbInfo.getSourceFactory()); cacheReferenceType = ConfigurationCacheReferenceType.HARD; configDB.setExpiryTimeCache(dbInfo.getMaxAgeSeconds(), dbInfo.getPurgeIntervalSeconds(), cacheReferenceType); connectionLifecycle = ConfigurationDBRef.ConnectionLifecycleEnum.POOLED; configDB.setConnectionLifecycleEnum(connectionLifecycle); this.configuration.addDatabaseReference(dbInfo.getDbName(), configDB); LOG.info("Recreate Data Source : " + dbInfo.getDbName());
public ConnectionCache getConnectionCache(String databaseName, String preparedStatementText) throws DatabaseConfigException { ConfigurationDBRef config = mapDatabaseRef.get(databaseName); if (config == null) { throw new DatabaseConfigException("Cannot locate configuration information for database '" + databaseName + '\''); } DatabaseConnectionFactory connectionFactory = getConnectionFactory(databaseName); boolean retain = config.getConnectionLifecycleEnum().equals(ConfigurationDBRef.ConnectionLifecycleEnum.RETAIN); if (retain) { return new ConnectionCacheImpl(connectionFactory, preparedStatementText); } else { return new ConnectionNoCacheImpl(connectionFactory, preparedStatementText); } }
Properties pps = new Properties(); String[] props = dbInfo.getProps(); ConfigurationDBRef configDB = new ConfigurationDBRef(); for(String prop : props) { String[] fields = prop.split("="); configDB.setDataSourceFactory(pps, dbInfo.getSourceFactory()); cacheReferenceType = ConfigurationCacheReferenceType.HARD; configDB.setExpiryTimeCache(dbInfo.getMaxAgeSeconds(), dbInfo.getPurgeIntervalSeconds(), cacheReferenceType); connectionLifecycle = ConfigurationDBRef.ConnectionLifecycleEnum.POOLED; configDB.setConnectionLifecycleEnum(connectionLifecycle); this.configuration.addDatabaseReference(dbInfo.getDbName(), configDB); LOG.info("Recreate Data Source : " + dbInfo.getDbName());
Properties pps = new Properties(); String[] props = dbInfo.getProps(); ConfigurationDBRef configDB = new ConfigurationDBRef(); for(String prop : props) { String[] fields = prop.split("="); configDB.setDataSourceFactory(pps, dbInfo.getSourceFactory()); cacheReferenceType = ConfigurationCacheReferenceType.HARD; configDB.setExpiryTimeCache(dbInfo.getMaxAgeSeconds(), dbInfo.getPurgeIntervalSeconds(), cacheReferenceType); connectionLifecycle = ConfigurationDBRef.ConnectionLifecycleEnum.POOLED; configDB.setConnectionLifecycleEnum(connectionLifecycle); this.configuration.addDatabaseReference(dbInfo.getDbName(), configDB);
Properties pps = new Properties(); String[] props = dbInfo.getProps(); ConfigurationDBRef configDB = new ConfigurationDBRef(); for(String prop : props) { String[] fields = prop.split("="); configDB.setDataSourceFactory(pps, dbInfo.getSourceFactory()); cacheReferenceType = ConfigurationCacheReferenceType.HARD; configDB.setExpiryTimeCache(dbInfo.getMaxAgeSeconds(), dbInfo.getPurgeIntervalSeconds(), cacheReferenceType); connectionLifecycle = ConfigurationDBRef.ConnectionLifecycleEnum.POOLED; configDB.setConnectionLifecycleEnum(connectionLifecycle); this.configuration.addDatabaseReference(dbInfo.getDbName(), configDB); LOG.info("Add Data Source : " + dbInfo.getDbName());