Spring Boot 多数据源方言设置冲突解决方案

"To resolve the conflict in the Hibernate dialect configuration for the primary and secondary data sources, you can modify the configuration as follows:\n\nproperties\nspring.datasource.primary.jdbc-url=jdbc:postgresql://192.168.0.186:5432/postgis_szjg?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&serverTimezone=Asia/Shanghai\nspring.datasource.primary.driver-class-name=org.postgresql.Driver\nspring.datasource.primary.username=postgres\nspring.datasource.primary.password=123456\nspring.datasource.primary.db-type=com.zaxxer.hikari.HikariDataSource\nspring.datasource.primary.initial-size=5\nspring.datasource.primary.min-idle=5\nspring.datasource.primary.max-active=100\nspring.datasource.primary.max-wait=60000\nspring.datasource.primary.validation-query=select version()\nspring.datasource.primary.time-between-eviction-runs-millis=60000\nspring.datasource.primary.min-evictable-idle-time-millis=300000\nspring.datasource.primary.test-while-idle=true\nspring.datasource.primary.test-on-borrow=true\nspring.datasource.primary.test-on-return=false\nspring.datasource.primary.pool-prepared-statements=false\nspring.datasource.primary.max-pool-prepared-statement-per-connection-size=20\nspring.jpa.properties.hibernate.default-dialect=org.hibernate.dialect.PostgreSQLDialect\n\nspring.datasource.second.jdbc-url=jdbc:oracle:thin:@192.168.0.231:1521:ORCL\nspring.datasource.second.driver-class-name=oracle.jdbc.driver.OracleDriver\nspring.datasource.second.username=KLMY_DZ\nspring.datasource.second.password=KLMY_DZ_2023\nspring.datasource.second.db-type=com.zaxxer.hikari.HikariDataSource\nspring.jpa.properties.hibernate.dialect=org.hibernate.dialect.OracleDialect\n\n\nIn this configuration, I have replaced spring.jpa.properties.hibernate.dialect with spring.jpa.properties.hibernate.default-dialect for the primary data source. This way, the Hibernate dialect for the secondary data source remains org.hibernate.dialect.OracleDialect, and the primary data source uses org.hibernate.dialect.PostgreSQLDialect.