Java ConfigurationDBRef类代码示例

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
public void setUp() {
    MysqlDataSource mySQLDataSource = new MysqlDataSource();
    mySQLDataSource.setUser(SupportDatabaseService.DBUSER);
    mySQLDataSource.setPassword(SupportDatabaseService.DBPWD);
    mySQLDataSource.setURL("jdbc:mysql://localhost/test");

    String envName = "java:comp/env/jdbc/MySQLDB";
    SupportInitialContextFactory.addContextEntry(envName, mySQLDataSource);

    ConfigurationDBRef config = new ConfigurationDBRef();
    Properties properties = new Properties();
    properties.put("java.naming.factory.initial", SupportInitialContextFactory.class.getName());
    config.setDataSourceConnection(envName, properties);

    databaseDSConnFactory = new DatabaseDSConnFactory((ConfigurationDBRef.DataSourceConnection) config.getConnectionFactoryDesc(), config.getConnectionSettings());
}
 

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
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);
    }
}
 

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
public void setUp()
{
    MysqlDataSource mySQLDataSource = new MysqlDataSource();
    mySQLDataSource.setUser(SupportDatabaseService.DBUSER);
    mySQLDataSource.setPassword(SupportDatabaseService.DBPWD);
    mySQLDataSource.setURL("jdbc:mysql://localhost/test");

    String envName = "java:comp/env/jdbc/MySQLDB";
    SupportInitialContextFactory.addContextEntry(envName, mySQLDataSource);

    ConfigurationDBRef config = new ConfigurationDBRef();
    Properties properties = new Properties();
    properties.put("java.naming.factory.initial", SupportInitialContextFactory.class.getName());
    config.setDataSourceConnection(envName, properties);

    databaseDSConnFactory = new DatabaseDSConnFactory((ConfigurationDBRef.DataSourceConnection)config.getConnectionFactoryDesc(), config.getConnectionSettings());
}
 

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
public ConfigurationDBAdapter() {
    jdbcConnections = new HashMap<String, ConfigurationDBRef>();
    dmlQueries = new ArrayList<DMLQuery>();
    upsertQueries = new ArrayList<UpsertQuery>();
    upsertQueries = new ArrayList<UpsertQuery>();
    executors = new HashMap<String, Executor>();
}
 

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
public void configure(Configuration configuration) throws Exception {
    ConfigurationDBRef configDB = new ConfigurationDBRef();
    configDB.setDriverManagerConnection(SupportDatabaseService.DRIVER, SupportDatabaseService.FULLURL, new Properties());
    configDB.setConnectionLifecycleEnum(ConfigurationDBRef.ConnectionLifecycleEnum.RETAIN);
    configDB.setConnectionCatalog("test");
    configDB.setConnectionReadOnly(true);
    configDB.setConnectionTransactionIsolation(1);
    configDB.setConnectionAutoCommit(true);
    configuration.addDatabaseReference("MyDB", configDB);
}
 

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
protected static ConfigurationDBRef getDBConfig() {
    ConfigurationDBRef configDB = new ConfigurationDBRef();
    configDB.setDriverManagerConnection(SupportDatabaseService.DRIVER, SupportDatabaseService.FULLURL, new Properties());
    configDB.setConnectionLifecycleEnum(ConfigurationDBRef.ConnectionLifecycleEnum.RETAIN);
    configDB.setConnectionCatalog("test");
    configDB.setConnectionReadOnly(true);
    configDB.setConnectionAutoCommit(true);
    return configDB;
}
 

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
public void configure(Configuration configuration) throws Exception {
    ConfigurationDBRef configDB = new ConfigurationDBRef();
    configDB.setDriverManagerConnection(SupportDatabaseService.DRIVER, SupportDatabaseService.FULLURL, new Properties());
    configDB.setConnectionLifecycleEnum(ConfigurationDBRef.ConnectionLifecycleEnum.RETAIN);

    configuration.getEngineDefaults().getLogging().setEnableQueryPlan(true);
    configuration.getEngineDefaults().getLogging().setEnableJDBC(true);
    configuration.addDatabaseReference("MyDB", configDB);
}
 

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
public void configure(Configuration configuration) throws Exception {
    Properties props = new Properties();
    props.put("driverClassName", SupportDatabaseService.DRIVER);
    props.put("url", SupportDatabaseService.FULLURL);
    props.put("username", SupportDatabaseService.DBUSER);
    props.put("password", SupportDatabaseService.DBPWD);

    ConfigurationDBRef configDB = new ConfigurationDBRef();
    // for DBCP, use setDataSourceFactoryDBCP
    configDB.setDataSourceFactory(props, SupportDataSourceFactory.class.getName());
    configDB.setConnectionLifecycleEnum(ConfigurationDBRef.ConnectionLifecycleEnum.POOLED);
    configDB.setLRUCache(100);

    configuration.addDatabaseReference("MyDB", configDB);
}
 

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
public void configure(Configuration configuration) throws Exception {
    ConfigurationDBRef configDB = new ConfigurationDBRef();
    configDB.setDriverManagerConnection(SupportDatabaseService.DRIVER, SupportDatabaseService.FULLURL, new Properties());
    configDB.setConnectionLifecycleEnum(ConfigurationDBRef.ConnectionLifecycleEnum.RETAIN);

    /**
     * Turn this cache setting off to turn off indexing since without cache there is no point in indexing.
     */
    configDB.setLRUCache(100000);
    configuration.getEngineDefaults().getLogging().setEnableQueryPlan(true);
    configuration.addDatabaseReference("MyDB", configDB);
}
 

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
public void configure(Configuration configuration) throws Exception {
    ConfigurationDBRef configDB = new ConfigurationDBRef();
    configDB.setDriverManagerConnection(SupportDatabaseService.DRIVER, SupportDatabaseService.FULLURL, new Properties());
    configDB.setConnectionCatalog("test");
    configDB.setExpiryTimeCache(60, 120);

    configuration.getEngineDefaults().getLogging().setEnableQueryPlan(true);
    configuration.addDatabaseReference("MyDB", configDB);
}
 

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
public void configure(Configuration configuration) throws Exception {
    ConfigurationDBRef configDB = new ConfigurationDBRef();
    configDB.setDriverManagerConnection(SupportDatabaseService.DRIVER, SupportDatabaseService.FULLURL, new Properties());
    configDB.setConnectionLifecycleEnum(ConfigurationDBRef.ConnectionLifecycleEnum.RETAIN);
    configDB.setLRUCache(100000);
    configDB.setConnectionCatalog("test");
    configuration.addDatabaseReference("MyDB", configDB);
}
 

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
private static Map<String, DBOutputTypeDesc> compileResultMetaData(ResultSetMetaData resultMetaData,
                                                                   ColumnSettings columnSettings
)
        throws SQLException {
    Map<String, DBOutputTypeDesc> outputProperties = new HashMap<String, DBOutputTypeDesc>();
    for (int i = 0; i < resultMetaData.getColumnCount(); i++) {
        String columnName = resultMetaData.getColumnLabel(i + 1);
        if (columnName == null) {
            columnName = resultMetaData.getColumnName(i + 1);
        }
        int columnType = resultMetaData.getColumnType(i + 1);
        String javaClass = resultMetaData.getColumnTypeName(i + 1);

        ConfigurationDBRef.ColumnChangeCaseEnum caseEnum = columnSettings.getColumnCaseConversionEnum();
        if ((caseEnum != null) && (caseEnum == ConfigurationDBRef.ColumnChangeCaseEnum.LOWERCASE)) {
            columnName = columnName.toLowerCase(Locale.ENGLISH);
        }
        if ((caseEnum != null) && (caseEnum == ConfigurationDBRef.ColumnChangeCaseEnum.UPPERCASE)) {
            columnName = columnName.toUpperCase(Locale.ENGLISH);
        }

        DatabaseTypeBinding binding = null;
        String javaTypeBinding = null;
        if (columnSettings.getJavaSqlTypeBinding() != null) {
            javaTypeBinding = columnSettings.getJavaSqlTypeBinding().get(columnType);
        }
        if (javaTypeBinding != null) {
            binding = DatabaseTypeEnum.getEnum(javaTypeBinding).getBinding();
        }
        DBOutputTypeDesc outputType = new DBOutputTypeDesc(columnType, javaClass, binding);
        outputProperties.put(columnName, outputType);
    }
    return outputProperties;
}
 

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
/**
 * Ctor.
 *
 * @param metadataOriginEnum       defines how to obtain output columnn metadata
 * @param columnCaseConversionEnum defines if to change case on output columns
 * @param javaSqlTypeBinding       is the Java sql types mapping to Java class
 */
public ColumnSettings(ConfigurationDBRef.MetadataOriginEnum metadataOriginEnum,
                      ConfigurationDBRef.ColumnChangeCaseEnum columnCaseConversionEnum,
                      Map<Integer, String> javaSqlTypeBinding) {
    this.metadataOriginEnum = metadataOriginEnum;
    this.columnCaseConversionEnum = columnCaseConversionEnum;
    this.javaSqlTypeBinding = javaSqlTypeBinding;
}
 

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
/**
 * Ctor.
 *
 * @param mapDatabaseRef    is a map of database name and database configuration entries
 * @param schedulingService is for scheduling callbacks for a cache
 * @param scheduleBucket    is a system bucket for all scheduling callbacks for caches
 * @param engineImportService engine imports
 */
public DatabaseConfigServiceImpl(Map<String, ConfigurationDBRef> mapDatabaseRef,
                                 SchedulingService schedulingService,
                                 ScheduleBucket scheduleBucket,
                                 EngineImportService engineImportService) {
    this.mapDatabaseRef = mapDatabaseRef;
    this.connectionFactories = new HashMap<String, DatabaseConnectionFactory>();
    this.schedulingService = schedulingService;
    this.scheduleBucket = scheduleBucket;
    this.engineImportService = engineImportService;
}
 

import com.espertech.esper.client.ConfigurationDBRef; //导入依赖的package包/类
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);
    }
}