Spring boot Hibernate error “Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set” when working with multiple data sources

by

I figure it out.

Modify method entityManagerFactory for both Db2Configuration and OracleConfiguration to supply them with the information about hibernate dialect:

for DB2

@Primary
@Bean(name = "db2EntityManagerFactory")
public LocalContainerEntityManagerFactoryBean entityManagerFactory(
        EntityManagerFactoryBuilder builder
        , @Qualifier("db2DataSource") DataSource dataSource) {

    final HashMap<String, Object> hibernateProperties = new HashMap<String, Object>();
    hibernateProperties.put("hibernate.dialect", "org.hibernate.dialect.DB2390Dialect");

    return builder
            .dataSource(dataSource)
            .packages("project.dataconfig.db2.entity")
            .properties(hibernateProperties)
            .persistenceUnit("db2persistanceunit")
            .build();
}

for Oracle

@Bean(name = "oracleEntityManagerFactory")
public LocalContainerEntityManagerFactoryBean entityManagerFactory(
        EntityManagerFactoryBuilder builder
        , @Qualifier("oracleDataSource") DataSource dataSource) {

    final HashMap<String, Object> hibernateProperties = new HashMap<String, Object>();
    hibernateProperties.put("hibernate.dialect", "org.hibernate.dialect.Oracle10gDialect");

    return builder
            .dataSource(dataSource)
            .packages("project.dataconfig.oracle.entity")
            .properties(hibernateProperties)
            .persistenceUnit("oraclepersistanceunit")
            .build();
}

After this, my console shows when running app, indicating all is good:

HHH000400: Using dialect: org.hibernate.dialect.DB2390Dialect
 Initialized JPA EntityManagerFactory for persistence unit 'db2persistanceunit'
HHH000204: Processing PersistenceUnitInfo [name: oraclepersistanceunit]
HHH000400: Using dialect: org.hibernate.dialect.Oracle10gDialect
Initialized JPA EntityManagerFactory for persistence unit 'oraclepersistanceunit'

My actuator /health endpoint also sees both databases as up and running.

More Related Contents:

  1. How to do bulk (multi row) inserts with JpaRepository?
  2. No more data to read from socket error
  3. hibernate oracle sequence produces large gap
  4. How to use Spring managed Hibernate interceptors in Spring Boot?
  5. Disable all Database related auto configuration in Spring Boot
  6. Spring Data JPA – Pass column name and value as parameters
  7. HIbernate issue with Oracle Trigger for generating id from a sequence
  8. How to generate a ddl creation script with a modern Spring Boot + Data JPA and Hibernate setup?
  9. Apparent connection leak detected with Hikari CP
  10. ORA-04091: table [blah] is mutating, trigger/function may not see it
  11. Spring Boot Data JPA – Modifying update query – Refresh persistence context
  12. Why has javax.persistence-api been replaced by jakarta.persistence-api in spring data jpa starter?
  13. Difference between LockModeType Jpa
  14. How do I escape a reserved word in Oracle?
  15. How to put more than 1000 values into an Oracle IN clause [duplicate]
  16. Is it possible to use raw SQL within a Spring Repository
  17. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  18. Fetch Oracle table type from stored procedure using JDBC
  19. “Safe” TO_NUMBER()
  20. Oracle client ORA-12541: TNS:no listener [closed]
  21. Create an Excel Spreadsheet from a Oracle Database
  22. How do I turn off Oracle password expiration?
  23. Spring Data JDBC / Spring Data JPA vs Hibernate
  24. ORACLE IIF Statement
  25. Oracle Age calculation from Date of birth and Today
  26. How to list active / open connections in Oracle?
  27. Connection cannot be cast to oracle.jdbc.OracleConnection
  28. How to get the week day name from a date?
  29. DBMS_JOB vs DBMS_SCHEDULER
  30. How to change default nls_date_format for oracle jdbc client

Leave a Comment