Alibaba Druid 源码阅读（四）数据库连接池中连接获取探索

最新推荐文章于 2024-05-01 21:12:49 发布

_萧_

最新推荐文章于 2024-05-01 21:12:49 发布

阅读量1.2k

点赞数

分类专栏：数据库 Java 文章标签：数据库 database mysql

本文链接：https://blog.csdn.net/github_35735591/article/details/121295986

版权

Alibaba Druid 源码阅读（四）数据库连接池中连接获取探索

简介

上文中分析了数据库连接池的初始化部分，接下来我们来看看获取连接部分的代码

数据库连接池中连接获取

下面的相关的代码，在代码中加了自己的相关注释：

    public DruidPooledConnection getConnection(long maxWaitMillis) throws SQLException {
   
        // 上文分析过的初始化
        init();

        // 由于没有配置 filter，直接走：getConnectionDirect
        if (filters.size() > 0) {
   
            FilterChainImpl filterChain = new FilterChainImpl(this);
            return filterChain.dataSource_connect(this, maxWaitMillis);
        } else {
   
            return getConnectionDirect(maxWaitMillis);
        }
    }

    public DruidPooledConnection getConnectionDirect(long maxWaitMillis) throws SQLException {
   
        int notFullTimeoutRetryCnt = 0;
        for (;;) {
   
            // handle notFullTimeoutRetry
            DruidPooledConnection poolableConnection;
            try {
   
                // 获取连接，具体后面再看
                poolableConnection = getConnectionInternal(maxWaitMillis);
            } catch (GetConnectionTimeoutException ex) {
   
                if (notFullTimeoutRetryCnt <= this.notFullTimeoutRetryCount && !isFull()) {
   
                    notFullTimeoutRetryCnt++;
                    if (LOG.isWarnEnabled()) {
   
                        LOG.warn("get connection timeout retry : " + notFullTimeoutRetryCnt);
                    }
                    continue;
                }
                throw ex;
            }

            // 下面看意思是做了一些连接有效性的检查
            // 无效的就跳过这次，重新去获取一次
            if (testOnBorrow) {
   
                boolean validate = testConnectionInternal(poolableConnection.holder, poolableConnection.conn);
                if (!validate) {
   
                    if (LOG.isDebugEnabled()) {
   
                        LOG.debug("skip not validate connection.");
                    }

                    discardConnection(poolableConnection.holder);
                    continue;
                }
            } else {
   
                if (poolableConnection.conn.isClosed()) {
   
                    discardConnection(poolableConnection.holder); // 传入null，避免重复关闭
                    continue;
                }

                // 这段感觉有段阻塞超时等待的感觉，留待确认
                if (testWhileIdle) {
   
                    final DruidConnectionHolder holder = poolableConnection.holder;
                    long currentTimeMillis             = System.currentTimeMillis();
                    long lastActiveTimeMillis          = holder.lastActiveTimeMillis;
                    long lastExecTimeMillis            = holder.lastExecTimeMillis;
                    long lastKeepTimeMillis            = holder.lastKeepTimeMillis;

                    if (checkExecuteTime
                            && lastExecTimeMillis != lastActiveTimeMillis) {
   
                        lastActiveTimeMillis = lastExecTimeMillis;
                    }

                    if (lastKeepTimeMillis > lastActiveTimeMillis) {
   
                        lastActiveTimeMillis = lastKeepTimeMillis;
                    }

                    long idleMillis                    = currentTimeMillis - lastActiveTimeMillis;

                    long timeBetweenEvictionRunsMillis =