KprAIModelPower/sql.properties

#spring.datasource.data.jdbc-url=jdbc:postgresql_postGIS://119.96.165.176:5432/water_smart_develop_branch?useSSL=false&useAffectedRows=false&allowMultiQueries=true
spring.datasource.data.jdbc-url=jdbc:postgresql_postGIS://1.197.77.125: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

#oracle
spring.datasource.oracle.jdbc-url=jdbc:oracle:thin:@10.127.16.117:1521/ORCLPDB1
spring.datasource.oracle.username=v_cqzls
spring.datasource.oracle.password=CQzls#2025
#spring.datasource.oracle.username=v_jiangjin
#spring.datasource.oracle.password=JiangJin@1127
spring.datasource.oracle.driver-class-name=oracle.jdbc.driver.OracleDriver

#pgsql ˮ��Ԥ�����ݿ�Դ
#spring.datasource.db2.jdbc-url=jdbc:postgresql_postGIS://140.246.183.164: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.jdbc-url=jdbc:postgresql_postGIS://10.101.5.50:5432/water_volume_prediction?useSSL=false&useAffectedRows=false&allowMultiQueries=true
#spring.datasource.db2.jdbc-url=jdbc:postgresql_postGIS://10.101.3.104:5432/water_volume_prediction_jiangjin2?useSSL=false&useAffectedRows=false&allowMultiQueries=true
spring.datasource.db2.username=postgres
spring.datasource.db2.password=ygt.23417.postgres
#spring.datasource.db2.password=kpr.23417.postgres
spring.datasource.db2.driver-class-name=org.postgis.DriverWrapper
#spring,database.name=water_volume_prediction_jiangjin2
spring,database.name=water_volume_prediction

spring.datasource.child2pg.jdbc-url=jdbc:postgresql_postGIS://10.101.5.50:5432/water_level_prediction?useSSL=false&useAffectedRows=false&allowMultiQueries=true&rewriteBatchedStatements=true
spring.datasource.child2pg.username=postgres
spring.datasource.child2pg.password=ygt.23417.postgres
spring.datasource.child2pg.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