Druid连接池 can not open connection
频繁对数据表进行删除和插入,几次就崩了,求指导
连接池设置:
##druid连接池
druid.filters:stat
druid.maxActive=10
druid.initialSize=1
druid.maxWait=60000
druid.minIdle=1
druid.timeBetweenEvictionRunsMillis=60000
druid.minEvictableIdleTimeMillis=300000
druid.validationQuery=SELECT 'x' FROM DUAL
druid.testWhileIdle=true
druid.testOnBorrow=false
druid.testOnReturn=false
druid.removeAbandoned=true
druid.removeAbandonedTimeout=120
错误信息(部分):
com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 60040, active 10
at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1124)
org.hibernate.exception.GenericJDBCException: Cannot open connection
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection