KprAIModelPower/sql.properties

spring.datasource.data.jdbc-url=jdbc:postgresql_postGIS://119.96.165.176:5432/watersmart?useSSL=false&useAffectedRows=false&allowMultiQueries=true
spring.datasource.data.username=postgres
spring.datasource.data.password=kpr.23417.postgres
spring.datasource.data.driver-class-name=org.postgis.DriverWrapper

#pgsql 自来水水量预测数据库源
spring.datasource.db2.jdbc-url=jdbc:postgresql_postGIS://119.96.165.176:5432/water_volume_prediction?useSSL=false&useAffectedRows=false&allowMultiQueries=true
spring.datasource.db2.username=postgres
spring.datasource.db2.password=kpr.23417.postgres
spring.datasource.db2.driver-class-name=org.postgis.DriverWrapper


spring.datasource.data2.jdbc-url=jdbc:postgresql://119.96.165.176:5432/water_smart_central?useSSL=false&useAffectedRows=false&allowMultiQueries=true&useUnicode=true&characterEncoding=utf-8
spring.datasource.data2.username=postgres
spring.datasource.data2.password=kpr.23417.postgres
spring.datasource.data2.driver-class-name=org.postgresql.Driver


spring.datasource.data2.max-wait=60000
spring.datasource.data2.maximum-pool-size=200
spring.datasource.data2.minimum-idle=1
spring.datasource.data2.validation-query=SELECT 1
spring.datasource.data2.connection-test-query=SELECT 1
spring.datasource.data2.test-on-borrow=false
spring.datasource.data2.test-on-return=false
spring.datasource.data2.test-while-idle=true
spring.datasource.data2.max-lifetime=60000
spring.datasource.data2.idle-timeout=30000
spring.datasource.data2.connection-timeout=30000
# 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
spring.datasource.data2.time-between-eviction-runs-millis=60000
# 配置一个连接在池中最小生存的时间，单位是毫秒
spring.datasource.data2.minEvictableIdleTimeMillis=300000

spring.datasource.data.max-wait=60000
spring.datasource.data.maximum-pool-size=200
spring.datasource.data.minimum-idle=1
spring.datasource.data.validation-query=SELECT 1
spring.datasource.data.connection-test-query=SELECT 1
spring.datasource.data.test-on-borrow=false
spring.datasource.data.test-on-return=false
spring.datasource.data.test-while-idle=true
spring.datasource.data.max-lifetime=120000
spring.datasource.data.idle-timeout=30000
spring.datasource.data.connection-timeout=30000
# 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
spring.datasource.data.time-between-eviction-runs-millis=60000
# 配置一个连接在池中最小生存的时间，单位是毫秒
spring.datasource.data.minEvictableIdleTimeMillis=300000