准备
修改pom.xml
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.40</version>
</dependency>
<dependency>
<groupId>org.apache.tomcat</groupId>
<artifactId>tomcat-jdbc</artifactId>
<version>${tomcat-version}</version>
</dependency>
<dependency>
<groupId>org.apache.tomcat</groupId>
<artifactId>tomcat-servlet-api</artifactId>
<version>${tomcat-version}</version>
</dependency>
常规配置(每次都好用)
@Bean
public DataSource dataSource(){
PoolProperties p = new PoolProperties()
p.setUrl("jdbc:mysql://localhost:3306/app")
p.setDriverClassName("com.mysql.jdbc.Driver")
p.setUsername("root")
p.setPassword("uroot")
p.setJmxEnabled(true)
p.setTestWhileIdle(false)
p.setTestOnBorrow(true)
p.setValidationQuery("SELECT 1")
p.setTestOnReturn(false)
p.setValidationInterval(30000)
p.setTimeBetweenEvictionRunsMillis(30000)
p.setMaxActive(100)
p.setInitialSize(10)
p.setMaxWait(10000)
p.setRemoveAbandonedTimeout(60)
p.setMinEvictableIdleTimeMillis(30000)
p.setMinIdle(10)
p.setLogAbandoned(true)
p.setRemoveAbandoned(true)
p.setJdbcInterceptors(
"org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;" +
"org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer")
DataSource datasource = new DataSource()
datasource.setPoolProperties(p)
return datasource
}
SpringBoot 配置(有时候莫名不好用)
spring.datasource.tomcat.password=[数据库密码]
spring.datasource.tomcat.username=[数据库用户名]
spring.datasource.tomcat.url=jdbc:mysql://127.0.0.1:3306/app
spring.datasource.tomcat.driver-class-name=com.mysql.jdbc.Driver
#该选项用来验证数据库连接的有效性。
#SELECT 1(mysql), select 1 from dual(oracle), SELECT 1(MS Sql Server) 。
spring.datasource.tomcat.validation-query=SELECT 1
#连接池的最大数据库连接数。设为0表示无限制。
spring.datasource.tomcat.max-active=100
#最大建立连接等待时间。如果超过此时间将接到异常。设为-1表示无限制。
spring.datasource.tomcat.max-wait=10000
#最大空闲数,数据库连接的最大空闲时间。默认100
#超过空闲时间,数据库连接将被标记为不可用,然后被释放。设为0表示无限制。
spring.datasource.tomcat.max-idle=100
spring.datasource.tomcat.min-idle=10
spring.datasource.tomcat.jmx-enabled=true
spring.datasource.tomcat.test-on-borrow=true
spring.datasource.tomcat.test-while-idle=false
spring.datasource.tomcat.test-on-return=false
spring.datasource.tomcat.validation-interval=30000
spring.datasource.tomcat.time-between-eviction-runs-millis=30000
spring.datasource.tomcat.initial-size=10
spring.datasource.tomcat.remove-abandoned-timeout=60
spring.datasource.tomcat.log-abandoned=true
spring.datasource.tomcat.remove-abandoned=true
spring.datasource.tomcat.jdbc-interceptors=org.apache.tomcat.jdbc.pool.interceptor.ConnectionState