数据库连接池连接异常com.alibaba.druid.pool.GetConnectionTimeoutException

问题

Caused by: com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 45000, active 100, runningSqlCount 2

原因

1.事务没提交

开启了事务，但是没有关闭事务，导致连接池一直被占用

事务管理代码：

@Autowired
    private PlatformTransactionManager platformTransactionManager;
    
    protected TransactionStatus startTx() {
        TransactionStatus transactionStatus = platformTransactionManager
                .getTransaction(new DefaultTransactionDefinition(
                        TransactionDefinition.PROPAGATION_REQUIRES_NEW));
        return transactionStatus;
    }
    protected void commitTx(TransactionStatus transactionStatus) {
        if(transactionStatus != null){
            platformTransactionManager.commit(transactionStatus);
        }
    }
    protected void rollbackTx(TransactionStatus transactionStatus) {
        if(transactionStatus != null){
            platformTransactionManager.rollback(transactionStatus);
        }
    }

启动事务没提交

TransactionStatus transactionStatus = null;
transactionStatus = startTx();

应该提交事务，释放连接池

commitTx(transactionStatus);

异常回滚事务

rollbackTx(transactionStatus);

2. 连接没关闭

打开了数据库连接，没有关闭，连接池被占用

Connection conn = null;
ResultSet rs = null;

conn = jdbcTemplate.getDataSource().getConnection();

rs = conn.getMetaData().getTables(null, null, table, null);

应该在完成数据库相关操作后，关闭连接，释放连接池

if (rs != null) {
       rs.close();
 }
  if (conn != null) {
       conn.close();
 }