dataSource:
dbCreate: update
url: jdbc:mysql://xxxxx:3306/xxxx
username: xx
password: xxxxx
pooled: true
properties:
jmxEnabled: true
initialSize: 5
maxActive: 50
minIdle: 5
maxIdle: 25
maxWait: 10000
maxAge: 600000
logAbandoned: true
timeBetweenEvictionRunsMillis: 5000
minEvictableIdleTimeMillis: 10000
numTestsPerEvictionRun: 5
validationQuery: SELECT 1
validationQueryTimeout: 3
validationInterval: 15000
testOnBorrow: true
testWhileIdle: true
testOnReturn: false
jdbcInterceptors: ConnectionState
defaultTransactionIsolation: 2 # TRANSACTION_READ_COMMITTED
removeAbandoned: true
removeAbandonedTimeout: 10
关键在于:
pooled: true //默认是false,设置true时properties的配置信息才会生效.