spring 没有类型为“javax.persistence. qualityManager”的合格Bean可用：需要单个匹配Bean，但找到2

kd3sttzy  于 2023-11-16  发布在  Spring
关注(0)|答案(5)|浏览(119)

我有两个实体管理器配置用于两个单独的数据库，但是当我尝试自动连接实体管理器来配置我的GraphQLEutor bean时，我得到一个异常，说明有两个bean匹配标准，即使我在PersistenceContext中指定了一个单元名称。

异常

org.springframework.beans.factory.BeanCreationException：创建名为“graphQLEutor”的bean时出错：注入资源依赖失败;嵌套的异常是org.springframework.beans.factory. NoUniqueBeanCreationException：没有可用的类型为“javax.persistence. questionManager”的合格bean：应为单个匹配bean，但找到2：org.springframework.orm.jpa.SharedManagerCreator#0，org. springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues上的org.springframework.orm.jpa.SharedNotityManagerCreator#1（CommonAnnotationBeanPostProcessor.java：321）~[spring-context-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean（AbstractAutowireCapableBeanFactory.java：1264）~[spring-beans-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory. documentBean（AbstractAutowireCapableBeanFactory.java：553）~[spring-beans-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory. BeanBean（AbstractAutowireCapableBeanFactory.java：483）~[spring-beans-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org. springframework. beans. factory. support. AbstractBeanFactory $1.getObject（AbstractBeanFactory.java：306）~[spring-beans-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java：230）~[spring-beans-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean（AbstractBeanFactory.java：302）~[spring-beans-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java：197）~[spring-beans-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons（DefaultListableBeanFactory.java：761）~[spring-beans-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.context.support.AbstractApplicationContext. finishBeanFactoryList（AbstractApplicationContext.java：867）~[spring-context-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh（AbstractApplicationContext.java：543）~[spring-context-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework. Boot 子.context.embedded.EmbeddedWebApplicationContext.refresh（EmbeddedWebApplicationContext.java：122）~[spring-boot-1.5.4.RELEASE.jar：1.5.4.RELEASE] at org.springframework.boot.SpringApplication.refresh（SpringApplication.java：693）[spring-boot-1.5.4.RELEASE.jar：1.5.4.RELEASE] at org.springframework.boot.SpringApplication.refreshContext（SpringApplication.java：360）[spring-boot-1.5.4.RELEASE.jar：1.5.4.RELEASE] at org.springframework.boot.SpringApplication.run（SpringApplication.java：303）[spring-boot-1.5.4.RELEASE.jar：1.5.4.RELEASE] at org.springframework.boot.SpringApplication.run（SpringApplication.java：1118）[spring-boot-1.5.4.RELEASE.jar：1.5.4.RELEASE] at org.springframework.boot.SpringApplication.run（SpringApplication.java：1107）[spring-boot-1.5.4.RELEASE.jar：1.5.4.RELEASE] at com.ogl.JpaDemoApplication.main（JpaDemoApplication.java：15）[classes/：na] Caused by：org.springframework.beans.factory. NoUniqueBeanExceptionException：No qualifying bean of type 'javax.persistence. PastityManager' available：expected single matching bean but found 2：org.springframework.orm.jpa.SharedManagerCreator#0，org.springframework.orm.jpa.SharedDataManagerCreator#1位于org.springframework.beans.factory.config.DependencyDescriptor.resolveNotUnique（DependencyDescriptor.java：173）~[spring-beans-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency（DefaultListableBeanFactory.java：1116）~[spring-beans-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency（DefaultListableBeanFactory.java：1066）~[spring-beans-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource（CommonAnnotationBeanPostProcessor.java：518）~[spring-context-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource（CommonAnnotationBeanPostProcessor.java：496）~[spring-context-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject（CommonAnnotationBeanPostProcessor.java：627）~[spring-context-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject（InjectionMetadata.java：169）~[spring-beans-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.beans.factory.annotation.InjectionMetadata.inject（InjectionMetadata.java：88）~[spring-beans-4.3.9.RELEASE.jar：4.3.9.RELEASE] at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues（CommonAnnotationBeanPostProcessor.java：318）~[spring-context-4.3.9.RELEASE.jar：4.3.9.RELEASE].省略17个公共帧

实体管理器1

package com.ogl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.env.Environment;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.orm.jpa.vendor.Database;
import org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter;
import org.springframework.transaction.PlatformTransactionManager;

import javax.sql.DataSource;

@Configuration
@EnableJpaRepositories(basePackages = "com.ogl.system", entityManagerFactoryRef = "companyEntityManagerFactory", transactionManagerRef = "companyTransactionManager")
public class SystemJpaConfig {

  private final Environment environment;

  @Autowired
  public SystemJpaConfig(Environment environment) {
    this.environment = environment;
  }

  @Bean("systemEntityManagerFactory")
  public LocalContainerEntityManagerFactoryBean systemEntityManagerFactory() {
    LocalContainerEntityManagerFactoryBean entityManagerFactoryBean = new LocalContainerEntityManagerFactoryBean();
    entityManagerFactoryBean.setPackagesToScan("com.ogl.system");
    entityManagerFactoryBean.setPersistenceUnitName("system");
    entityManagerFactoryBean.setDataSource(systemDataSource());

    HibernateJpaVendorAdapter adapter = new HibernateJpaVendorAdapter();
    adapter.setDatabase(Database.POSTGRESQL);
    adapter.setShowSql(true);
    adapter.setGenerateDdl(false);

    entityManagerFactoryBean.setJpaVendorAdapter(adapter);

    return entityManagerFactoryBean;
  }

  @Bean
  DataSource systemDataSource() {
    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName(environment.getProperty("p4.datasource.driver"));
    dataSource.setUrl(environment.getProperty("p4.system.url"));
    dataSource.setUsername(environment.getProperty("p4.system.user"));
    dataSource.setPassword(environment.getProperty("p4.system.password"));

    return dataSource;
  }

  @Bean
  public PlatformTransactionManager systemTransactionManager() {
    JpaTransactionManager transactionManager = new JpaTransactionManager();
    transactionManager.setEntityManagerFactory((systemEntityManagerFactory().getObject()));

    return transactionManager;
  }
}

字符串

实体管理器2

package com.ogl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.env.Environment;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.orm.jpa.vendor.Database;
import org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter;
import org.springframework.transaction.PlatformTransactionManager;

import javax.sql.DataSource;

@Configuration
@EnableJpaRepositories(basePackages = "com.ogl.company", entityManagerFactoryRef = "companyEntityManagerFactory", transactionManagerRef = "companyTransactionManager")
public class CompanyJpaConfig {

  private final Environment environment;

  @Autowired
  public CompanyJpaConfig(Environment environment) {
    this.environment = environment;
  }

  @Primary
  @Bean("companyEntityManagerFactory")
  public LocalContainerEntityManagerFactoryBean companyEntityManagerFactory() {
    LocalContainerEntityManagerFactoryBean entityManagerFactoryBean = new LocalContainerEntityManagerFactoryBean();
    entityManagerFactoryBean.setPackagesToScan("com.ogl.company");
    entityManagerFactoryBean.setPersistenceUnitName("company");
    entityManagerFactoryBean.setDataSource(companyDataSource());

    HibernateJpaVendorAdapter adapter = new HibernateJpaVendorAdapter();
    adapter.setDatabase(Database.POSTGRESQL);
    adapter.setShowSql(true);
    adapter.setGenerateDdl(false);

    entityManagerFactoryBean.setJpaVendorAdapter(adapter);

    return entityManagerFactoryBean;
  }

  @Bean
  DataSource companyDataSource() {
    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName(environment.getProperty("p4.datasource.driver"));
    dataSource.setUrl(environment.getProperty("p4.company.url"));
    dataSource.setUsername(environment.getProperty("p4.company.user"));
    dataSource.setPassword(environment.getProperty("p4.company.password"));

    return dataSource;
  }

  @Primary
  @Bean
  public PlatformTransactionManager companyTransactionManager() {
    JpaTransactionManager transactionManager = new JpaTransactionManager();
    transactionManager.setEntityManagerFactory((companyEntityManagerFactory().getObject()));

    return transactionManager;
  }
}

型

注射

package com.ogl;

import org.crygier.graphql.GraphQLExecutor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

@Configuration
@ComponentScan
public class GraphQLJpaConfig {

  @PersistenceContext(unitName = "company")
  private EntityManager entityManager;

  @Bean
  public GraphQLExecutor graphQLExecutor() {
    return new GraphQLExecutor(entityManager);
  }
}

型

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.ogl</groupId>
    <artifactId>jpa-demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>jar</packaging>

    <name>jpa-demo</name>
    <description>Demo project for JPA</description>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.4.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>com.graphql-java</groupId>
            <artifactId>graphql-java</artifactId>
            <version>2.3.0</version>
        </dependency>
        <dependency>
            <groupId>com.crygier</groupId>
            <artifactId>graphql-jpa</artifactId>
            <version>0.3</version>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>
</project>

型

spring

5条答案

按热度按时间
uyhoqukh

uyhoqukh1#

你已经定义了两个entitymanager。现在你必须告诉spring应该注入哪一个。为此，你可以使用@Qualifier Annotation：

@PersistenceContext(unitName = "company")
@Qualifier(<Name of the entitimanager you want to use>)
private EntityManager entityManager;

字符串

赞(0）分享  回复(0）举报  2023-11-16
i5desfxk

i5desfxk2#

找到了一个解决方案，通过使用@Component标记我正在用GraphityManager注入的类，然后将该类自动连接到使用GraphQLEutor的类中：

标记为@Component的新类

package p4;

import org.crygier.graphql.GraphQLExecutor;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.stereotype.Component;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

@Component
public class CompanyGraphQLComponent {

  @PersistenceContext(unitName = "company")
  private EntityManager entityManager;

  public GraphQLExecutor graphQLExecutor() {
    return new GraphQLExecutor(entityManager);
  }
}

字符串

类自动布线CompanyGraphQLComponent

package p4.rest.controllers;

import core_services.persistence.CompanyContextHolder;
import core_services.records.system.Company;
import graphql.ExecutionResult;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.MediaType;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import p4.CompanyGraphQLComponent;
import p4.records.GraphQLQuery;

@RestController
public class GraphQLController {
  @Autowired
  private CompanyGraphQLComponent companyGraphQLComponent;

  @RequestMapping(value = "/graphql", consumes = MediaType.APPLICATION_JSON_VALUE)
  public ExecutionResult postJson(@RequestBody GraphQLQuery graphQLQuery) {
    return companyGraphQLComponent.graphQLExecutor().execute(graphQLQuery.getQuery(), graphQLQuery.getVariables());
  }
}

型

赞(0）分享  回复(0）举报  2023-11-16
ojsjcaue

ojsjcaue3#

你能不能试着在其中一个配置文件中给entityManagerFactory和transactionManager一次注解@Primary？

赞(0）分享  回复(0）举报  2023-11-16
f0brbegy

f0brbegy4#

我有两个问题，标记一个作为主要解决问题

赞(0）分享  回复(0）举报  2023-11-16
pbpqsu0x

pbpqsu0x5#

SystemJpaConfig.java

@Bean
public EntityManager entityManagerSystem(EntityManagerFactoryBuilder builder) {
    return systemEntityManagerFactory().getObject().createEntityManager();
}

字符串
CompanyJpaConfig.java

@Bean
@Primary
public EntityManager entityManagerSystem(EntityManagerFactoryBuilder builder) {
    return companyEntityManagerFactory().getObject().createEntityManager();
}

型

赞(0）分享  回复(0）举报  2023-11-16
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com