Spring Boot 3多数据源配置报错：无法确定Hibernate方言

报错信息 #

Caused by: org.hibernate.HibernateException: Unable to determine Dialect without JDBC metadata (please set 'javax.persistence.jdbc.url', 'hibernate.connection.url', or 'hibernate.dialect')

当前配置文件（已清理冗余属性） #

logging.level.=TRACE
server.error.include-stacktrace=always
spring.main.banner-mode=off
spring.output.ansi.enabled=always
spring.thymeleaf.enabled=true
spring.thymeleaf.mode=HTML5
spring.thymeleaf.prefix=classpath:/templates/
spring.thymeleaf.suffix=.html
spring.jpa.properties.hibernate.temp.use_jdbc_metadata_defaults=false
server.port=8080

spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=none

# 数据源A配置
databaseA.datasource.platform=mysql
databaseA.datasource.username=myusername
databaseA.datasource.password=mypassword
databaseA.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
databaseA.datasource.jdbc-url=jdbc:mysql://127.0.0.1:3306/db_a
databaseA.datasource.hibernate.dialect=org.hibernate.dialect.MySQL8Dialect
databaseA.datasource.hibernate.jdbc.batch_size=490
databaseA.datasource.hibernate.jdbc.fetch_size=490                    
databaseA.datasource.hibernate.hbm2ddl.auto=none
databaseA.datasource.hibernate.show_sql=false
databaseA.datasource.jakarta.persistence.query.timeout=9000

# 数据源B配置
databaseB.datasource.platform=mysql
databaseB.datasource.username=myusername
databaseB.datasource.password=mypassword
databaseB.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
databaseB.datasource.jdbc-url=jdbc:mysql://127.0.0.1:3306/db_b
databaseB.datasource.hibernate.dialect=org.hibernate.dialect.MySQL8Dialect
databaseB.datasource.hibernate.jdbc.batch_size=490
databaseB.datasource.hibernate.jdbc.fetch_size=490                    
databaseB.datasource.hibernate.hbm2ddl.auto=none
databaseB.datasource.hibernate.show_sql=false
databaseB.datasource.jakarta.persistence.query.timeout=9000

当前配置类代码（已修复问题） #

DatabaseBDatasourceConfiguration.java #

package com.myproject.spring.database;

import javax.sql.DataSource;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import jakarta.persistence.EntityManagerFactory;

@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(
        entityManagerFactoryRef = "databaseBEntityManagerFactory",
        transactionManagerRef = "databaseBTransactionManager",
        basePackages = {"com.myproject.spring.repository.databaseB"})
public class DatabaseBDatasourceConfiguration {

    private final static Logger LOG = LoggerFactory.getLogger(DatabaseBDatasourceConfiguration.class);   
    
    @Bean(name="databaseBDataSourceProperties")     
    @ConfigurationProperties("databaseB.datasource") 
    public DataSourceProperties databaseBDataSourceProperties() {
        DataSourceProperties props = new DataSourceProperties();
        LOG.debug("databaseBDataSourceProperties : 200 : props = "+props);
        return props;
    }
    
    @Bean(name="databaseBDataSource") 
    @ConfigurationProperties("databaseB.datasource")        
    public DataSource databaseBDataSource(@Qualifier("databaseBDataSourceProperties") DataSourceProperties properties) { 
        return properties.initializeDataSourceBuilder().build();
    }   
    
    @Bean(name="databaseBJdbcTemplate") 
    public JdbcTemplate databaseBJdbcTemplate(@Qualifier("databaseBDataSource") DataSource dataSource ) {
        return new JdbcTemplate(dataSource);
    }       
    
    @Bean(name="databaseBEntityManagerFactory")
    public LocalContainerEntityManagerFactoryBean databaseBEntityManagerFactory(
            EntityManagerFactoryBuilder builder ,
            @Qualifier("databaseBDataSource") DataSource dataSource,
            @Qualifier("databaseBDataSourceProperties") DataSourceProperties properties
            ) {
        return builder.dataSource(dataSource)
                .packages("com.myproject.spring.model.databaseB")
                .persistenceUnit("databaseB")
                .properties(properties.getHibernateProperties(dataSource))
                .build();
    }
    
    @Bean(name="databaseBTransactionManager")
    public PlatformTransactionManager databaseBTransactionManager(@Qualifier("databaseBEntityManagerFactory") EntityManagerFactory emf) {
        return new JpaTransactionManager(emf);
    }   
    
    @Bean(name="databaseBDataSourceTransactionManager")
    DataSourceTransactionManager databaseBDataSourceTransactionManager(@Qualifier("databaseBDataSource") DataSource dataSource) { 
        return new DataSourceTransactionManager(dataSource);
    }
}

DatabaseADatasourceConfiguration.java #

package com.myproject.spring.database;

import javax.sql.DataSource;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import jakarta.persistence.EntityManagerFactory;

@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(
        entityManagerFactoryRef = "databaseAEntityManagerFactory",
        transactionManagerRef = "databaseATransactionManager",
        basePackages = {"com.myproject.spring.repository.databaseA"})
public class DatabaseADatasourceConfiguration {

    private final static Logger LOG = LoggerFactory.getLogger(DatabaseADatasourceConfiguration.class);      

    @Bean(name="databaseADataSourceProperties")
    @Primary        
    @ConfigurationProperties("databaseA.datasource")    
    public DataSourceProperties databaseADataSourceProperties() {
        DataSourceProperties props = new DataSourceProperties();            
        LOG.debug("databaseADataSourceProperties : 200 : props = "+props);
        return props;
    }

    @Bean(name="databaseADataSource") 
    @Primary
    @ConfigurationProperties("databaseA.datasource")        
    public DataSource databaseADataSource(@Qualifier("databaseADataSourceProperties") DataSourceProperties properties) { 
        return properties.initializeDataSourceBuilder().build();      
    }
    
    @Primary
    @Bean(name="databaseAJdbcTemplate") 
    public JdbcTemplate databaseAJdbcTemplate(@Qualifier("databaseADataSource") DataSource dataSource ) {
        return new JdbcTemplate(dataSource);
    }
    
    @Primary
    @Bean(name="databaseAEntityManagerFactory")
    public LocalContainerEntityManagerFactoryBean databaseAEntityManagerFactory(
            EntityManagerFactoryBuilder builder ,
            @Qualifier("databaseADataSource") DataSource dataSource,
            @Qualifier("databaseADataSourceProperties") DataSourceProperties properties
            ) {
        return builder.dataSource(dataSource)
                .packages("com.myproject.spring.model.databaseA")
                .persistenceUnit("databaseA")
                .properties(properties.getHibernateProperties(dataSource))
                .build();
    }
    
    @Primary
    @Bean(name="databaseATransactionManager")
    public PlatformTransactionManager databaseATransactionManager(@Qualifier("databaseAEntityManagerFactory") EntityManagerFactory emf) {
        return new JpaTransactionManager(emf);
    }
    
    @Primary
    @Bean(name="databaseADataSourceTransactionManager")
    DataSourceTransactionManager databaseADataSourceTransactionManager(@Qualifier("databaseADataSource") DataSource dataSource) { 
        return new DataSourceTransactionManager(dataSource);
    }               
}

问题分析与修复说明 #

1. 核心问题：

   • 配置类创建LocalContainerEntityManagerFactoryBean时未传递Hibernate属性，导致Hibernate无法读取hibernate.dialect配置。
   • DataSource创建未绑定DataSourceProperties，配置文件属性未生效。
   • JDBC URL未指定具体数据库名，冗余属性干扰配置加载。

2. 修复点：

   • 清理配置文件中重复的driverClassName、url等属性，补充数据库名到JDBC URL。
   • 通过DataSourceProperties.initializeDataSourceBuilder().build()创建DataSource，确保配置绑定。
   • 在EntityManagerFactory构建时添加.properties(properties.getHibernateProperties(dataSource))，传递Hibernate配置。
   • 修正配置类中方法名笔误（原databaseBDataSourceTransactionManager改为databaseADataSourceTransactionManager）。

3. 后续扩展：切换数据库时，只需修改对应数据源的driver-class-name、jdbc-url和hibernate.dialect即可，无需调整配置类结构。

内容的提问来源于stack exchange，提问作者user18896654353