Camel Spring Boot JPA with mutiple datasources not finding correct persistence unit-CodePudding

I have a spring boot service, using JPA and Apache camel. I configured two different datasources following https://www.baeldung.com/spring-data-jpa-multiple-databases So far the datasources themself seem to be in place. However camel is not picking them based on the persistenceUnit name. When I remove all code related to one of those datasources then it suddenly works. To me it seems like the persistenceUnit name is not correctly set. I always get the following error:

javax.persistence.PersistenceException: No Persistence provider for EntityManager named domain

I also compared with my approach with Spring Boot Camel JPA with multiple Datasources

Datasource 1:


import org.hibernate.jpa.HibernatePersistenceProvider;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.context.annotation.PropertySource;
import org.springframework.core.env.Environment;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter;
import org.springframework.transaction.PlatformTransactionManager;

import javax.persistence.PersistenceContext;
import javax.sql.DataSource;
import java.util.HashMap;

@Configuration
@PropertySource({"classpath:database.properties"})
@EnableJpaRepositories(
        basePackages = {"com.myapp.persistence.domain"},
        entityManagerFactoryRef = "domainEntityManager",
        transactionManagerRef = "domainTransactionManager")
public class PersistenceDomainAutoConfiguration {

    @Autowired
    private Environment env;

    @Bean
    @Primary
    @ConfigurationProperties(prefix = "spring.datasource")
    public DataSource domainDataSource() {
        return DataSourceBuilder.create().build();
    }

    @Bean
    @Primary
    @PersistenceContext(unitName = "domain")
    public LocalContainerEntityManagerFactoryBean domainEntityManager() {
        final LocalContainerEntityManagerFactoryBean em = new LocalContainerEntityManagerFactoryBean();
        em.setDataSource(domainDataSource());
        em.setPackagesToScan("com.myapp.model.domain","com.myapp.legacy");
        em.setPersistenceProviderClass(HibernatePersistenceProvider.class);
        em.setPersistenceUnitName("domain");
        final HibernateJpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
        em.setJpaVendorAdapter(vendorAdapter);
        final HashMap<String, Object> properties = new HashMap<String, Object>();
        properties.put("hibernate.hbm2ddl.auto", env.getProperty("hibernate.hbm2ddl.auto"));
        properties.put("hibernate.dialect",
                "org.hibernate.dialect.PostgreSQLDialect");
        em.setJpaPropertyMap(properties);

        return em;
    }


    @Bean
    public PlatformTransactionManager domainTransactionManager() {
        final JpaTransactionManager transactionManager = new JpaTransactionManager();
        transactionManager.setEntityManagerFactory(domainEntityManager().getObject());
        return transactionManager;
    }

}

Datasource 2:

package com.myapp.configuration;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;
import org.springframework.core.env.Environment;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter;
import org.springframework.transaction.PlatformTransactionManager;

import javax.persistence.PersistenceContext;
import javax.sql.DataSource;
import java.util.HashMap;

@Configuration
@PropertySource({"classpath:database.properties"})
@EnableJpaRepositories(
        basePackages = "com.myapp.persistence.lookup",
        entityManagerFactoryRef = "lookupEntityManager",
        transactionManagerRef = "lookupTransactionManager")
public class PersistenceLookupAutoConfiguration {

    @Autowired
    private Environment env;

    @Bean
    @ConfigurationProperties(prefix="spring.currency-datasource")
    public DataSource lookupDataSource() {
        return DataSourceBuilder.create().build();
    }

    @Bean
    @PersistenceContext(unitName = "lookup")
    public LocalContainerEntityManagerFactoryBean lookupEntityManager() {
        final LocalContainerEntityManagerFactoryBean em = new LocalContainerEntityManagerFactoryBean();
        em.setDataSource(lookupDataSource());
        em.setPackagesToScan("com.myapp.model.lookup");
        em.setPersistenceUnitName("lookup");

        final HibernateJpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
        em.setJpaVendorAdapter(vendorAdapter);
        final HashMap<String, Object> properties = new HashMap<String, Object>();
        properties.put("hibernate.hbm2ddl.auto", env.getProperty("hibernate.hbm2ddl.auto"));
        properties.put("hibernate.dialect", "org.hibernate.dialect.SQLServerDialect");
        em.setJpaPropertyMap(properties);

        return em;
    }


    @Bean
    public PlatformTransactionManager lookupTransactionManager() {
        final JpaTransactionManager transactionManager = new JpaTransactionManager();
        transactionManager.setEntityManagerFactory(lookupEntityManager().getObject());
        return transactionManager;
    }
}

Camelroute excerpt:

...
.to("jpa:com.myapp.model.domain.Event?entityType=java.util.ArrayList&persistenceUnit=domain")

CodePudding user response：

use entityManagerFactory options instance of persistenceUnit