修改后的配置如下springdatasourceprimaryjdbc-url=jdbcpostgresql19216801865432postgis_szjguseUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&serverTimezone=AsiaShanghaispringdatasourceprimarydriver-

修改后的配置如下:

spring.datasource.primary.jdbc-url=jdbc:postgresql://192.168.0.186:5432/postgis_szjg?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&serverTimezone=Asia/Shanghai
spring.datasource.primary.driver-class-name=org.postgresql.Driver
spring.datasource.primary.username=postgres
spring.datasource.primary.password=123456
spring.datasource.primary.db-type=com.zaxxer.hikari.HikariDataSource
spring.datasource.primary.initial-size=5
spring.datasource.primary.min-idle=5
spring.datasource.primary.max-active=100
spring.datasource.primary.max-wait=60000
spring.datasource.primary.validation-query=select version()
spring.datasource.primary.time-between-eviction-runs-millis=60000
spring.datasource.primary.min-evictable-idle-time-millis=300000
spring.datasource.primary.test-while-idle=true
spring.datasource.primary.test-on-borrow=true
spring.datasource.primary.test-on-return=false
spring.datasource.primary.pool-prepared-statements=false
spring.datasource.primary.max-pool-prepared-statement-per-connection-size=20
spring.jpa.properties.primary.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect


spring.datasource.second.jdbc-url=jdbc:oracle:thin:@192.168.0.231:1521:ORCL
spring.datasource.second.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.second.username=KLMY_DZ
spring.datasource.second.password=KLMY_DZ_2023
spring.datasource.second.db-type=com.zaxxer.hikari.HikariDataSource
spring.jpa.properties.second.hibernate.dialect=org.hibernate.dialect.OracleDialect

修改后的配置spring.jpa.properties.second.hibernate.dialect=org.hibernate.dialect.OracleDialect未生效