Skip to content

Commit a8adb33

Browse files
committed
添加验证数据库间隔时间
1 parent c90bb54 commit a8adb33

File tree

5 files changed

+10
-0
lines changed

5 files changed

+10
-0
lines changed

admin/src/main/resources/config/application.properties

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -9,8 +9,10 @@ spring.datasource.driver-class-name=com.mysql.jdbc.Driver
99
spring.datasource.max-active=100
1010
spring.datasource.max-idle=100
1111
spring.datasource.min-idle=10
12+
#每小时访问一次数据库,避免断开
1213
spring.datasource.testOnBorrow=true
1314
spring.datasource.validationQuery=SELECT 1
15+
spring.datasource.minEvictableIdleTimeMillis=3600000
1416
#jpa
1517
spring.jpa.database-platform=org.hibernate.dialect.MySQL5Dialect
1618
spring.jpa.hibernate.ddl-auto=update

admin/src/test/resources/config/application.properties

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -9,8 +9,10 @@ spring.datasource.driver-class-name=com.mysql.jdbc.Driver
99
spring.datasource.max-active=100
1010
spring.datasource.max-idle=100
1111
spring.datasource.min-idle=10
12+
#每小时访问一次数据库,避免断开
1213
spring.datasource.testOnBorrow=true
1314
spring.datasource.validationQuery=SELECT 1
15+
spring.datasource.minEvictableIdleTimeMillis=3600000
1416
#jpa
1517
spring.jpa.database-platform=org.hibernate.dialect.MySQL5Dialect
1618
spring.jpa.hibernate.ddl-auto=update

core/src/main/resources/config/application.properties

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -9,8 +9,10 @@ spring.datasource.driver-class-name=com.mysql.jdbc.Driver
99
spring.datasource.max-active=100
1010
spring.datasource.max-idle=100
1111
spring.datasource.min-idle=10
12+
#每小时访问一次数据库,避免断开
1213
spring.datasource.testOnBorrow=true
1314
spring.datasource.validationQuery=SELECT 1
15+
spring.datasource.minEvictableIdleTimeMillis=3600000
1416
#jpa
1517
spring.jpa.database-platform=org.hibernate.dialect.MySQL5Dialect
1618
spring.jpa.hibernate.ddl-auto=update

web/src/main/resources/config/application.properties

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -9,8 +9,10 @@ spring.datasource.driver-class-name=com.mysql.jdbc.Driver
99
spring.datasource.max-active=100
1010
spring.datasource.max-idle=100
1111
spring.datasource.min-idle=10
12+
#每小时访问一次数据库,避免断开
1213
spring.datasource.testOnBorrow=true
1314
spring.datasource.validationQuery=SELECT 1
15+
spring.datasource.minEvictableIdleTimeMillis=3600000
1416
#jpa
1517
spring.jpa.database-platform=org.hibernate.dialect.MySQL5Dialect
1618
spring.jpa.hibernate.ddl-auto=update

web/src/test/resources/config/application.properties

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -9,8 +9,10 @@ spring.datasource.driver-class-name=com.mysql.jdbc.Driver
99
spring.datasource.max-active=100
1010
spring.datasource.max-idle=100
1111
spring.datasource.min-idle=10
12+
#每小时访问一次数据库,避免断开
1213
spring.datasource.testOnBorrow=true
1314
spring.datasource.validationQuery=SELECT 1
15+
spring.datasource.minEvictableIdleTimeMillis=3600000
1416
#jpa
1517
spring.jpa.database-platform=org.hibernate.dialect.MySQL5Dialect
1618
spring.jpa.hibernate.ddl-auto=update

0 commit comments

Comments
 (0)