sql.properties 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. spring.datasource.data.jdbc-url=jdbc:postgresql://140.246.183.164:5432/water_smart_develop_branch?useSSL=false&useAffectedRows=false&allowMultiQueries=true
  2. spring.datasource.data.username=postgres
  3. spring.datasource.data.password=kpr.23417.postgres
  4. spring.datasource.data.driver-class-name=org.postgresql.Driver
  5. spring.datasource.data.max-wait=60000
  6. spring.datasource.data.maximum-pool-size=200
  7. spring.datasource.data.minimum-idle=1
  8. spring.datasource.data.validation-query=SELECT 1
  9. spring.datasource.data.connection-test-query=SELECT 1
  10. spring.datasource.data.test-on-borrow=false
  11. spring.datasource.data.test-on-return=false
  12. spring.datasource.data.test-while-idle=true
  13. spring.datasource.data.max-lifetime=120000
  14. spring.datasource.data.idle-timeout=30000
  15. spring.datasource.data.connection-timeout=30000
  16. # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  17. spring.datasource.data.time-between-eviction-runs-millis=60000
  18. # 配置一个连接在池中最小生存的时间,单位是毫秒
  19. spring.datasource.data.minEvictableIdleTimeMillis=300000
  20. spring.datasource.data2.jdbc-url=jdbc:postgresql://140.246.183.164:5432/water_smart_central?useSSL=false&useAffectedRows=false&allowMultiQueries=true&useUnicode=true&characterEncoding=utf-8
  21. spring.datasource.data2.username=postgres
  22. spring.datasource.data2.password=kpr.23417.postgres
  23. spring.datasource.data2.driver-class-name=org.postgresql.Driver
  24. spring.datasource.data2.max-wait=60000
  25. spring.datasource.data2.maximum-pool-size=200
  26. spring.datasource.data2.minimum-idle=1
  27. spring.datasource.data2.validation-query=SELECT 1
  28. spring.datasource.data2.connection-test-query=SELECT 1
  29. spring.datasource.data2.test-on-borrow=false
  30. spring.datasource.data2.test-on-return=false
  31. spring.datasource.data2.test-while-idle=true
  32. spring.datasource.data2.max-lifetime=120000
  33. spring.datasource.data2.idle-timeout=30000
  34. spring.datasource.data2.connection-timeout=30000
  35. # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
  36. spring.datasource.data2.time-between-eviction-runs-millis=60000
  37. # 配置一个连接在池中最小生存的时间,单位是毫秒
  38. spring.datasource.data2.minEvictableIdleTimeMillis=300000