AWSNeptune连接池设置
创始人
2024-09-26 16:01:39
0

在使用AWS Neptune数据库时,我们可以使用以下代码示例来设置连接池:

import com.amazonaws.regions.Regions;
import com.amazonaws.services.neptune.AmazonNeptune;
import com.amazonaws.services.neptune.AmazonNeptuneClientBuilder;
import com.amazonaws.services.neptune.model.DBInstanceNotFoundException;

import java.util.Properties;

import org.apache.commons.dbcp2.BasicDataSource;

public class NeptuneConnectionPool {

    private BasicDataSource dataSource;

    public NeptuneConnectionPool(String endpoint, String port, String dbName, String username, String password, Regions region) throws Exception {
        dataSource = new BasicDataSource();

        dataSource.setUsername(username);
        dataSource.setPassword(password);
        dataSource.setUrl("jdbc:aws://" + endpoint + ":" + port + "/" + dbName + "?region=" + region.getName());
        dataSource.setDriverClassName("com.amazon.neptune.driver.GremlinDriver");

        // maximum number of active connections to allocate
        dataSource.setMaxTotal(20);

        // maximum number of connections to allow in the idle state
        dataSource.setMaxIdle(0);

        // minimum number of connections to allow in the idle state
        dataSource.setMinIdle(0);

        // maximum waiting time for an idle connection to become available
        dataSource.setMaxWaitMillis(10000);

        // validate connection before borrowing it from pool
        dataSource.setValidationQuery("SELECT 1");

        // check idle connection periodically
        dataSource.setTimeBetweenEvictionRunsMillis(60000);

        // validate idle connections during idle connection check
        dataSource.setTestWhileIdle(true);
    }

    public AmazonNeptune getConnection() throws DBInstanceNotFoundException {
        AmazonNeptune client = AmazonNeptuneClientBuilder.standard().withCredentials(new DefaultAWSCredentialsProviderChain()).build();
        client.describeDBInstances();
        client.shutdown();
        return client;
    }

    public BasicDataSource getDataSource() {
        return dataSource;
    }

    public void close() {
        try {
            dataSource.close();
        } catch (Exception e) {
        }
    }

}

其中,我们可以设置以下参数:

  • dataSource.setMaxTotal(20):连接池最大连接数
  • dataSource.setMaxIdle(0):最大空闲连接数
  • dataSource.setMinIdle(0):最小空闲连接数
  • `dataSource.setMaxWaitMillis(100

相关内容

热门资讯

6分钟辅助!hhpoker是真... 6分钟辅助!hhpoker是真的假的,hhpoker真的有透视吗,演示教程(真是有挂)1、每一步都需...
第七分钟辅助!we poker... 第七分钟辅助!we poker插件,we poker免费辅助器,手筋教程(有挂方式)暗藏猫腻,小编详...
七分钟辅助!aa poker辅... 七分钟辅助!aa poker辅助包,pokemmo脚本辅助器下载,讲义教程(有挂秘籍)1、pokem...
第四分钟辅助!wepoker辅... 第四分钟辅助!wepoker辅助器安装包定制,aapoker透视脚本,大纲教程(有挂总结)所有人都在...
第四分钟辅助!wpk透视辅助靠... 第四分钟辅助!wpk透视辅助靠谱吗,wepoker透视苹果系统,诀窍教程(有挂猫腻);运wepoke...
七分钟辅助!aapoker透视... 七分钟辅助!aapoker透视脚本入口,wejoker开挂,学习教程(有挂教程)1、打开软件启动之后...
第四分钟辅助!淘宝买wepok... 第四分钟辅助!淘宝买wepoker透视有用吗,wpk俱乐部怎么作弊,积累教程(有挂规律)1、下载好淘...
6分钟辅助!we-poker软... 6分钟辅助!we-poker软件,购买的wpk辅助在哪里下载,积累教程(有挂技巧)购买的wpk辅助在...
第2分钟辅助!如何下载wepo... 第2分钟辅助!如何下载wepoker安装包,newpoker怎么安装脚本,教程书教程(今日头条)1、...
4分钟辅助!wepoker钻石... 4分钟辅助!wepoker钻石怎么看底牌,wepoker辅助器有哪些功能,法门教程(有挂详细)该软件...