本文整理汇总了Java中org.apache.commons.dbcp2.BasicDataSource.setValidationQuery方法的典型用法代码示例。如果您正苦于以下问题:Java BasicDataSource.setValidationQuery方法的具体用法?Java BasicDataSource.setValidationQuery怎么用?Java BasicDataSource.setValidationQuery使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.commons.dbcp2.BasicDataSource
的用法示例。
在下文中一共展示了BasicDataSource.setValidationQuery方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: getBasicDataSource
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
private static BasicDataSource getBasicDataSource(DatasourceConfiguration configuration) {
BasicDataSource dbcpDataSource = new BasicDataSource();
dbcpDataSource.setDriverClassName(configuration.getDriverClassname());
dbcpDataSource.setUrl(configuration.getUrl());
dbcpDataSource.setUsername(configuration.getUser());
dbcpDataSource.setPassword(configuration.getPassword());
// Enable statement caching (Optional)
dbcpDataSource.setPoolPreparedStatements(true);
dbcpDataSource.setValidationQuery("Select 1 ");
dbcpDataSource.setMaxOpenPreparedStatements(50);
dbcpDataSource.setLifo(true);
dbcpDataSource.setMaxTotal(10);
dbcpDataSource.setInitialSize(2);
return dbcpDataSource;
}
示例2: invokeGetDataSource
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
public DataSource invokeGetDataSource() {
BasicDataSource bds = new BasicDataSource();
bds.setDriverClassName("com.mysql.jdbc.Driver");
bds.setUrl("jdbc:mysql://127.0.0.1:3306/inst02");
bds.setUsername("root");
bds.setPassword("123456");
bds.setMaxTotal(50);
bds.setInitialSize(20);
bds.setMaxWaitMillis(60000);
bds.setMinIdle(6);
bds.setLogAbandoned(true);
bds.setRemoveAbandonedOnBorrow(true);
bds.setRemoveAbandonedOnMaintenance(true);
bds.setRemoveAbandonedTimeout(1800);
bds.setTestWhileIdle(true);
bds.setTestOnBorrow(false);
bds.setTestOnReturn(false);
bds.setValidationQuery("select 'x' ");
bds.setValidationQueryTimeout(1);
bds.setTimeBetweenEvictionRunsMillis(30000);
bds.setNumTestsPerEvictionRun(20);
return bds;
}
示例3: invokeGetDataSource
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
public DataSource invokeGetDataSource() {
BasicDataSource bds = new BasicDataSource();
bds.setDriverClassName("com.mysql.jdbc.Driver");
bds.setUrl("jdbc:mysql://127.0.0.1:3306/inst01");
bds.setUsername("root");
bds.setPassword("123456");
bds.setMaxTotal(50);
bds.setInitialSize(20);
bds.setMaxWaitMillis(60000);
bds.setMinIdle(6);
bds.setLogAbandoned(true);
bds.setRemoveAbandonedOnBorrow(true);
bds.setRemoveAbandonedOnMaintenance(true);
bds.setRemoveAbandonedTimeout(1800);
bds.setTestWhileIdle(true);
bds.setTestOnBorrow(false);
bds.setTestOnReturn(false);
bds.setValidationQuery("select 'x' ");
bds.setValidationQueryTimeout(1);
bds.setTimeBetweenEvictionRunsMillis(30000);
bds.setNumTestsPerEvictionRun(20);
return bds;
}
示例4: init
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
@PostConstruct
/**
* Creates security data-source to be used with the sample DB
*/
public void init() {
securityDataSource = new BasicDataSource();
securityDataSource.setDriverClassName(com.mysql.jdbc.Driver.class.getName());
securityDataSource.setUrl("jdbc:mysql://localhost:3306/java_one_2014");
securityDataSource.setUsername("java_one");
securityDataSource.setPassword("");
securityDataSource.setInitialSize(5);
securityDataSource.setMaxTotal(30);
securityDataSource.setMaxIdle(15);
securityDataSource.setMaxWaitMillis(3000);
securityDataSource.setLogAbandoned(true);
securityDataSource.setTestWhileIdle(true);
securityDataSource.setTestOnBorrow(true);
securityDataSource.setValidationQuery("select 1");
}
示例5: setupDataSource
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
/**
* TODO: write documentation
*
* @throws ClassNotFoundException
*/
private void setupDataSource() throws ClassNotFoundException {
// request classloader to load JDBC driver class
Class.forName(jdbcDriverClassName);
// prepare and configure data source
dataSource = new BasicDataSource();
dataSource.setDefaultAutoCommit(true);
dataSource.setDriverClassName(jdbcDriverClassName);
dataSource.setUsername(jdbcLogin);
dataSource.setPassword(jdbcPass);
dataSource.setUrl(jdbcUrl + jdbcSchema);
dataSource.setValidationQuery("select 1");
dataSource.setDefaultQueryTimeout(1000);
dataSource.setMaxConnLifetimeMillis(100000);
}
示例6: initialize
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
@Override
public Addon initialize(ServiceConfig serviceConfig) {
BasicDataSource dataSource = new BasicDataSource();
dataSource.setUrl(url);
dataSource.setDriverClassName(driverClassName);
dataSource.setUsername(username);
dataSource.setPassword(password);
dataSource.setValidationQuery(validationQuery);
return this.withDataSource(dataSource);
}
示例7: getValidationQuery
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
@Override
public void getValidationQuery() {
BasicDataSource dataSource = createDataSource();
dataSource.setValidationQuery("SELECT FROM FOO");
assertThat(
new CommonsDbcp2DataSourcePoolMetadata(dataSource).getValidationQuery())
.isEqualTo("SELECT FROM FOO");
}
开发者ID:vikrammane23,项目名称:https-github.com-g0t4-jenkins2-course-spring-boot,代码行数:9,代码来源:CommonsDbcp2DataSourcePoolMetadataTests.java
示例8: chatDataSource
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
@Bean
public DataSource chatDataSource() throws ConfigurationException, IOException {
BasicDataSource datasource = new BasicDataSource();
String path = this.configuration().getString(GlobalConfig.DB_PATH);
if (path == null) {
path = GlobalConfig.DB_PATH_DEFAULT;
}
datasource.setUsername(this.configuration().getString(GlobalConfig.DB_USERNAME));
datasource.setPassword(this.configuration().getString(GlobalConfig.DB_PASSWORD));
datasource.setDriverClassName("org.h2.Driver");
datasource.setUrl("jdbc:h2:" + path);
datasource.setMaxIdle(3);
datasource.setMaxWaitMillis(5000);
datasource.setRemoveAbandonedOnBorrow(true);
datasource.setRemoveAbandonedOnBorrow(true);
datasource.setRemoveAbandonedTimeout(20);
datasource.setLogAbandoned(true);
datasource.setValidationQuery("select 1");
datasource.setMinEvictableIdleTimeMillis(3600000);
datasource.setTimeBetweenEvictionRunsMillis(1800000);
datasource.setNumTestsPerEvictionRun(10);
datasource.setTestOnBorrow(true);
datasource.setTestOnReturn(false);
datasource.addConnectionProperty("useUnicode", "yes");
datasource.addConnectionProperty("characterEncoding", "utf8");
return datasource;
}
示例9: setupDataSourcePool
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
@Override
protected BasicDataSource setupDataSourcePool( DataSourceConfiguration config )
throws Exception
{
BasicDataSource pool = new BasicDataSource();
Class.forName( config.driver().get() );
pool.setDriverClassName( config.driver().get() );
pool.setUrl( config.url().get() );
if ( !config.username().get().equals( "" ) ) {
pool.setUsername( config.username().get() );
pool.setPassword( config.password().get() );
}
if ( config.minPoolSize().get() != null ) {
pool.setMinIdle( config.minPoolSize().get() );
}
if ( config.maxPoolSize().get() != null ) {
pool.setMaxTotal( config.maxPoolSize().get() );
}
if ( config.loginTimeoutSeconds().get() != null ) {
pool.setLoginTimeout( config.loginTimeoutSeconds().get() );
}
if ( config.maxConnectionAgeSeconds().get() != null ) {
pool.setMinEvictableIdleTimeMillis( config.maxConnectionAgeSeconds().get() * 1000 );
}
if ( config.validationQuery().get() != null ) {
pool.setValidationQuery( config.validationQuery().get() );
}
return pool;
}
示例10: load
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
@Override
public BasicDataSource load(List<String> key) {
BasicDataSource dataSource = new BasicDataSource();
dataSource.setUrl(key.get(0));
dataSource.setDriverClassName(key.get(1));
dataSource.setValidationQuery("SELECT 1");
LOG.info("load DataSource:" + dataSource + ", " + key.get(0) + " " + key.get(1));
return dataSource;
}
示例11: retrySetup
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
private void retrySetup(BasicDataSource ds) {
if (!"org.hibernate.dialect.HSQLDialect".equals(mainEnv.getDialect())) {
ds.setTestOnBorrow(dbcpEnv.isTestOnBorrow());
ds.setValidationQuery(dbcpEnv.getValidationQuery());
ds.setMaxTotal(dbcpEnv.getMaxTotal());
ds.setMinEvictableIdleTimeMillis(dbcpEnv.getMinEvictableIdleTime());
ds.setTimeBetweenEvictionRunsMillis(dbcpEnv.getTimeBetweenEvictionRuns());
ds.setNumTestsPerEvictionRun(dbcpEnv.getNumTestsPerEvictionRun());
ds.setTestWhileIdle(dbcpEnv.isTestWhileIdle());
ds.setTestOnReturn(dbcpEnv.isTestOnReturn());
}
}
示例12: setupDataSource
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
private static DataSource setupDataSource(String dbUrl, String dbUserName, String dbPassword) {
BasicDataSource dataSource = new BasicDataSource();
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUrl(dbUrl + "?useSSL=false&serverTimezone=UTC");
dataSource.setUsername(dbUserName);
dataSource.setPassword(dbPassword);
dataSource.setValidationQuery("SELECT 1;");
dataSource.setTestOnBorrow(true); // test each connection when borrowing from the pool with the validation query
dataSource.setMaxConnLifetimeMillis(1000 * 60 * 60); // max connection life time 1h. mysql drops connection after 8h.
return dataSource;
}
示例13: setImcmsDataSourceProperties
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
private void setImcmsDataSourceProperties(BasicDataSource basicDataSource) {
basicDataSource.setDriverClassName(imcmsProperties.getProperty("JdbcDriver"));
basicDataSource.setUrl(imcmsProperties.getProperty("JdbcUrl"));
basicDataSource.setUsername(imcmsProperties.getProperty("User"));
basicDataSource.setPassword(imcmsProperties.getProperty("Password"));
basicDataSource.setTestOnBorrow(true);
basicDataSource.setValidationQuery("select 1");
basicDataSource.setDefaultAutoCommit(false);
basicDataSource.setMaxTotal(20);
basicDataSource.setMaxTotal(Integer.parseInt(imcmsProperties.getProperty("MaxConnectionCount")));
}
示例14: dataSource
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
@Scope("prototype")
@Bean(destroyMethod = "close")
public DataSource dataSource() {
BasicDataSource ds = new BasicDataSource();
ds.setDriverClassName(env.getRequiredProperty("JdbcDriver"));
ds.setUsername(env.getRequiredProperty("User"));
ds.setPassword(env.getRequiredProperty("Password"));
ds.setTestOnBorrow(true);
ds.setValidationQuery("select 1");
ds.setMaxTotal(1);
return ds;
}
示例15: provideDataSource
import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
@Provides
@Singleton
private DataSource provideDataSource() {
BasicDataSource dataSource = new BasicDataSource();
dataSource.setDriverClassName(DRIVER_CLASS_NAME);
dataSource.setUsername(USERNAME);
dataSource.setPassword(PASSWORD);
dataSource.setUrl(URL);
dataSource.setValidationQuery(VALIDATION_QUERY);
return dataSource;
}