I am trying to set up a second data source in my Spring application. Below are the 2 configuration classes for the 2 data sources:

Primary data source config:
@Configuration @EnableTransactionManagement @EnableJpaRepositories(basePackages = "com.XYXYale.persistence.XY",        entityManagerFactoryRef = "awEntityManagerFactory",        transactionManagerRef= "awTransactionManager" public class Datasource1DataSourceConfig {    @Value("${spring.first-datasource.url}")    private String url;    @Value("${spring.first-datasource.username}")    private String username;    @Value("${spring.first-datasource.password}")    private String pw;    @Value("${spring.first-datasource.driver-class-name}")    private String driver;    @Bean    @Primary    @ConfigurationProperties("spring.first-datasource")    public DataSourceProperties awDataSourceProperties() {        return new DataSourceProperties();    @Bean    @Primary    @Qualifier("awEntityManagerFactory")    public DataSource awDataSource() {        DriverManagerDataSource dataSource                = new DriverManagerDataSource();        dataSource.setDriverClassName(                driver);        dataSource.setUrl(url);        dataSource.setUsername(username);        dataSource.setPassword(pw);        return dataSource;    @Primary    @Bean(name = "awEntityManagerFactory")    public LocalContainerEntityManagerFactoryBean awEntityManagerFactory() {        LocalContainerEntityManagerFactoryBean em = new LocalContainerEntityManagerFactoryBean();        em.setDataSource(awDataSource());        em.setPersistenceUnitName("XY");        em.setPackagesToScan(new String[] { "com.XY.XY.domain.XY" });        HibernateJpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();        vendorAdapter.setDatabasePlatform("org.hibernate.dialect.MySQLDialect");        em.setJpaVendorAdapter(vendorAdapter);        return em;    @Primary    @Bean    public PlatformTransactionManager awTransactionManager() {        JpaTransactionManager transactionManager                = new JpaTransactionManager();        transactionManager.setEntityManagerFactory(                awEntityManagerFactory().getObject());        return transactionManager; }

Second data source config


@Configuration @EnableTransactionManagement @EnableJpaRepositories(basePackages = "com.XYXYale.persistence.YX",        entityManagerFactoryRef = "sndEntityManagerFactory",        transactionManagerRef= "sndTransactionManager" public class SndDataSourceConfig {    @Value("${spring.second-datasource.jdbcUrl}")    private String url;    @Value("${spring.second-datasource.username}")    private String username;    @Value("${spring.second-datasource.password}")    private String pw;    @Value("${spring.second-datasource.driver-class-name}")    private String driver;    @Bean    @ConfigurationProperties("spring.second-datasource")    public DataSourceProperties sndDataSourceProperties() {        return new DataSourceProperties();    @Bean    @Qualifier("sndEntityManagerFactory")    public DataSource sndDataSource() {        DriverManagerDataSource dataSource                = new DriverManagerDataSource();        dataSource.setDriverClassName(                driver);        dataSource.setUrl(url);        dataSource.setUsername(username);        dataSource.setPassword(pw);        return dataSource;    @Bean(name = "sndEntityManagerFactory")    public LocalContainerEntityManagerFactoryBean sndEntityManagerFactory() {        LocalContainerEntityManagerFactoryBean em = new LocalContainerEntityManagerFactoryBean();        em.setDataSource(sndDataSource());        em.setPersistenceUnitName("snd");        em.setPackagesToScan(new String[] { "com.XY.XY.domain.YX" });        HibernateJpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();        vendorAdapter.setDatabasePlatform("org.hibernate.dialect.MySQLDialect");        em.setJpaVendorAdapter(vendorAdapter);        return em;    @Bean    public PlatformTransactionManager sndTransactionManager() {        JpaTransactionManager transactionManager                = new JpaTransactionManager();        transactionManager.setEntityManagerFactory(                sndEntityManagerFactory().getObject());        return transactionManager; }

Until now I had Spring Auto configure the data source I had. My domain classes were generated by Database schemes in IntelliJ. So there is under the "Persistence Tab" in Intelli J one EntityManager that was there from the auto configured data source and two more for both aw and snd data sources.

I have several Repositories that are implemented like that:

@Repository public interface DemoRepo extends CrudRepository<Demo, String>, DemoRepoCustom{ }

Then there is for custom methods outside the CRUD Repo features an interface like that:
@NoRepositoryBean public interface DemoRepoCustom {    Demo returnDemoContent(); }

The implementation of that interface looks like that:

public class DemoRepoImpl extends QuerydslRepositorySupport implements DemoRepoCustom {    public DemoRepoImpl() {        super(Demo.class);    public Demo returnDemoContent(){        return something; }

The Repos are used by Autowiring them:
@Autowired DemoRepo demoRepo;

I am getting this exception:


Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'demoRepositoryImpl': Unsatisfied dependency expressed through method 'setEntityManager' parameter 0; nested exception is org.springframework.beans.factory.NoUniqueBeanDefinitionException: No qualifying bean of type 'javax.persistence.EntityManager' available: expected single matching bean but found 2: org.springframework.orm.jpa.SharedEntityManagerCreator#0,org.springframework.orm.jpa.SharedEntityManagerCreator#1    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:678)    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:90)    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:376)    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1411)    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:592)    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:307)    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)    at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1255)    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1175)    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:595)    ... 55 more Caused by: org.springframework.beans.factory.NoUniqueBeanDefinitionException: No qualifying bean of type 'javax.persistence.EntityManager' available: expected single matching bean but found 2: org.springframework.orm.jpa.SharedEntityManagerCreator#0,org.springframework.orm.jpa.SharedEntityManagerCreator#1    at org.springframework.beans.factory.config.DependencyDescriptor.resolveNotUnique(DependencyDescriptor.java:221)    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1233)    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1175)    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:670)    ... 70 more

I would highly appreciate any help. I found nothing online that covered that problem. Only if EntitityManagers are implemented manually, which is not the case here.

@Bean(name = "sndEntityManagerFactory")    public LocalContainerEntityManagerFactoryBean sndEntityManagerFactory() { ..}
I think you can change either the bean name or the qualifier name. Since the names are the same, the container cannot tell which one to inject. https://www.kickstarter.com/projects/paulwheaton/low-tech-0