tomcat的jdbc连接池PoolExhaustedException

异常

Could not get JDBC Connection; nested exception is org.apache.tomcat.jdbc.pool.PoolExhaustedException: [XNIO-2 task-6] Timeout: Pool empty. Unable to fetch a connection in 30 seconds, none available[size:100; busy:100; idle:0; lastwait:30000

修改配置

spring:
  datasource:
    url: "jdbc:mysql://localhost:3306/spring_ddd"
    driverClassName: com.mysql.jdbc.Driver
    username: "root"
    password: ""
    # Number of ms to wait before throwing an exception if no connection is available.
    tomcat:
      max-wait: 10000
    # Maximum number of active connections that can be allocated from this pool at the same time.
      max-active: 200
      validation-query: "SELECT 1"
      test-on-borrow: true
      initial-size: 1   

doc

• Working with SQL databases

想获取最新内容，请关注微信公众号

qrcode_for_gh_121b87c80448_258.jpg