本文整理汇总了Java中com.zaxxer.hikari.HikariConfig.setConnectionInitSql方法的典型用法代码示例。如果您正苦于以下问题:Java HikariConfig.setConnectionInitSql方法的具体用法?Java HikariConfig.setConnectionInitSql怎么用?Java HikariConfig.setConnectionInitSql使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类com.zaxxer.hikari.HikariConfig
的用法示例。
在下文中一共展示了HikariConfig.setConnectionInitSql方法的7个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: createDataSource
import com.zaxxer.hikari.HikariConfig; //导入方法依赖的package包/类
@Override
public DataSource createDataSource(DataSourceConfig dataSourceConfig) {
HikariConfig hikariConfig = new HikariConfig();
hikariConfig.setJdbcUrl(dataSourceConfig.getUrl());
hikariConfig.setUsername(dataSourceConfig.getUser());
hikariConfig.setPassword(dataSourceConfig.getPassword());
hikariConfig.addDataSourceProperty("cachePrepStmts", dataSourceConfig.isCachePrepStmts());
hikariConfig.addDataSourceProperty("prepStmtCacheSize", dataSourceConfig.getPrepStmtCacheSize());
hikariConfig.addDataSourceProperty("prepStmtCacheSqlLimit", dataSourceConfig.getPrepStmtCacheSqlLimit());
hikariConfig.setDriverClassName(dataSourceConfig.getDriverClassName());
hikariConfig.setPoolName(dataSourceConfig.getPoolName());
if (dataSourceConfig.getConnectionInitSql() != null) {
hikariConfig.setConnectionInitSql(dataSourceConfig.getConnectionInitSql());
}
hikariConfig.setMaximumPoolSize(dataSourceConfig.getMaximumPoolSize());
return new HikariDataSource(hikariConfig);
}
示例2: dataSource
import com.zaxxer.hikari.HikariConfig; //导入方法依赖的package包/类
@Bean
@ConditionalOnMissingBean
public DataSource dataSource() {
HikariConfig configuration = new HikariConfig();
configuration.setJdbcUrl(url);
configuration.setUsername(username);
configuration.setPassword(password);
configuration.setAutoCommit(false);
configuration.setMaximumPoolSize(maxPoolSize);
configuration.setConnectionTimeout(connectionTimeout);
configuration.setMaxLifetime(maxLifetime);
Properties properties = new Properties();
properties.setProperty("cachePrepStmts", cachePrepStmts);
properties.setProperty("prepStmtCacheSize", prepStmtCacheSize);
properties.setProperty("prepStmtCacheSqlLimit", prepStmtCacheSqlLimit);
properties.setProperty("useServerPrepStmts", useServerPrepStmts);
configuration.setDataSourceProperties(properties);
configuration.setConnectionInitSql("SET NAMES " + connectionCharacter);
return new HikariDataSource(configuration);
}
示例3: setup
import com.zaxxer.hikari.HikariConfig; //导入方法依赖的package包/类
protected void setup(Jecon jecon, HikariConfig hikariConfig) {
this.jecon = jecon;
if (config == null) {
config = jecon.getConfigStruct();
}
this.prefix = config.getDbConfig().prefix;
hikariConfig.setJdbcUrl(config.getDbConfig().url);
hikariConfig.setInitializationFailFast(true);
hikariConfig.setAutoCommit(true);
hikariConfig.setConnectionInitSql("/* Jecon */SELECT 1");
if (config.getDbConfig().poolSize > 0) {
hikariConfig.setMaximumPoolSize(config.getDbConfig().poolSize);
}
if (config.getDbConfig().timeout > 0) {
hikariConfig.setIdleTimeout(config.getDbConfig().timeout);
}
hikariConfig.setDataSourceProperties(config.getDbConfig().propaties);
// HikariDataSourceをインスタンス化
this.hikariDc = new HikariDataSource(hikariConfig);
this.createTable();
}
示例4: getHikariConfig
import com.zaxxer.hikari.HikariConfig; //导入方法依赖的package包/类
private HikariConfig getHikariConfig(AgroalDataSourceConfiguration dataSourceConfiguration) {
if ( dataSourceConfiguration.isXA() ) {
throw new UnsupportedOperationException( "Unsupported. Hikari does not support XA" );
}
HikariConfig hikariConfig = new HikariConfig();
hikariConfig.setDataSourceJNDI( dataSourceConfiguration.jndiName() );
hikariConfig.setLeakDetectionThreshold( poolConfiguration.leakTimeout().toMillis() );
hikariConfig.setIdleTimeout( poolConfiguration.reapTimeout().toMillis() );
hikariConfig.setValidationTimeout( poolConfiguration.validationTimeout().toMillis() );
if ( factoryConfiguration.jdbcTransactionIsolation().isDefined() ) {
hikariConfig.setTransactionIsolation( "TRANSACTION_" + factoryConfiguration.jdbcTransactionIsolation().name() );
}
hikariConfig.setJdbcUrl( factoryConfiguration.jdbcUrl() );
hikariConfig.setAutoCommit( factoryConfiguration.autoCommit() );
hikariConfig.setConnectionInitSql( factoryConfiguration.initialSql() );
Principal principal = factoryConfiguration.principal();
if ( principal != null ) {
hikariConfig.setUsername( factoryConfiguration.principal().getName() );
}
for ( Object credential : factoryConfiguration.credentials() ) {
if ( credential instanceof SimplePassword ) {
hikariConfig.setPassword( ( (SimplePassword) credential ).getWord() );
}
}
hikariConfig.setMaximumPoolSize( poolConfiguration.maxSize() );
hikariConfig.setConnectionTimeout( poolConfiguration.acquisitionTimeout().toMillis() );
hikariConfig.setDriverClassName( factoryConfiguration.driverClassName() );
return hikariConfig;
}
示例5: DatabaseConnectionPool
import com.zaxxer.hikari.HikariConfig; //导入方法依赖的package包/类
public DatabaseConnectionPool(DatabaseProperties properties) {
HikariConfig hikariConfig = new HikariConfig();
hikariConfig.setDriverClassName("com.mysql.jdbc.Driver");
hikariConfig.setJdbcUrl(properties.getDatasourceUrl());
hikariConfig.setUsername(properties.getDatasourceUser());
hikariConfig.setPassword(properties.getDatasourcePassword());
hikariConfig.setConnectionInitSql(properties.getConnectionInitSql());
hikariConfig.addDataSourceProperty("cachePrepStmts", "true");
hikariConfig.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");
hikariConfig.addDataSourceProperty("prepStmtCacheSize", "250");
hikariConfig.addDataSourceProperty("useServerPrepStmts", "true");
dataSource = new HikariDataSource(hikariConfig);
}
示例6: createIndexEngine
import com.zaxxer.hikari.HikariConfig; //导入方法依赖的package包/类
private IndexEngine createIndexEngine() {
if (System.getProperty("postgres") != null) {
HikariConfig config = new HikariConfig();
config.setMaximumPoolSize(50);
config.setLeakDetectionThreshold(2000);
config.setConnectionInitSql("SET log_statement = 'all'; SET search_path = 'public'");
return new CascadingIndexEngine(new PostgreSQLIndexEngine(getPostgreSQLDataSource(), config),
new MemoryIndexEngine());
} else {
return new MemoryIndexEngine();
}
}
示例7: build
import com.zaxxer.hikari.HikariConfig; //导入方法依赖的package包/类
@Override
public ManagedDataSource build(final MetricRegistry metricRegistry, final String name) {
final Properties properties = new Properties();
for (final Map.Entry<String, String> property : this.properties.entrySet()) {
properties.setProperty(property.getKey(), property.getValue());
}
final HikariConfig config = new HikariConfig();
config.setDataSourceProperties(properties);
if (this.autoCommitByDefault.isPresent()) {
config.setAutoCommit(this.autoCommitByDefault.get());
}
config.setCatalog(this.defaultCatalog);
if (this.readOnlyByDefault.isPresent()) {
config.setReadOnly(this.readOnlyByDefault.get());
}
config.setDriverClassName(this.driverClass);
config.setConnectionInitSql(this.initializationQuery);
config.setMaximumPoolSize(this.maxSize);
config.setMinimumIdle(this.minSize);
if (this.getMaxConnectionAge().isPresent()) {
config.setMaxLifetime(this.maxConnectionAge.toMilliseconds());
}
config.setPoolName(name);
config.setJdbcUrl(this.url);
config.setUsername(this.user);
config.setPassword(this.user != null && this.password == null ? "" : this.password);
config.setConnectionTestQuery(this.validationQuery);
if (this.getValidationQueryTimeout().isPresent()) {
config.setValidationTimeout(this.validationQueryTimeout.toMilliseconds());
}
if (this.defaultTransactionIsolation.isPresent()) {
config.setTransactionIsolation(this.defaultTransactionIsolation.get().toString());
}
return new ManagedPooledDataSource(config, metricRegistry);
}