spring error Error creating bean with name 'XXX' define in file (다른 entity의 id를 repository를 통해 가져올 수 없음)

Question

안녕하세요. 현재 product의 id를 ReviewService에서 사용하려고 reviewRepository에 다음과 같이 작성을 하였습니다. 아래는 에러 코드와 reviewrepository, review entity, review service, product entity의 id 선언 부분입니다. 에러코드org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'reviewController' defined in file [C:\Users\개인정보\shoppingmall\product\controller\ReviewController.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'reviewService' defined in file [C:\Users\개인정보\shoppingmall\product\service\ReviewService.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'reviewRepository' defined in io.elice.shoppingmall.product.repository.ReviewRepository defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Could not create query for public abstract java.util.List io.elice.shoppingmall.product.repository.ReviewRepository.findByProductId(java.lang.Long); Reason: Failed to create query for method public abstract java.util.List io.elice.shoppingmall.product.repository.ReviewRepository.findByProductId(java.lang.Long); Cannot compare left expression of type 'io.elice.shoppingmall.product.entity.Product' with right expression of type 'java.lang.Long' at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:798) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:237) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1354) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1191) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:561) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:975) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:959) ~[spring-context-6.1.3.jar:6.1.3] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:624) ~[spring-context-6.1.3.jar:6.1.3] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) ~[spring-boot-3.2.2.jar:3.2.2] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754) ~[spring-boot-3.2.2.jar:3.2.2] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:456) ~[spring-boot-3.2.2.jar:3.2.2] at org.springframework.boot.SpringApplication.run(SpringApplication.java:334) ~[spring-boot-3.2.2.jar:3.2.2] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1354) ~[spring-boot-3.2.2.jar:3.2.2] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) ~[spring-boot-3.2.2.jar:3.2.2] at io.elice.shoppingmall.ShoppingMallApplication.main(ShoppingMallApplication.java:12) ~[main/:na] Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'reviewService' defined in file [C:\Users\개인정보\shoppingmall\product\service\ReviewService.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'reviewRepository' defined in io.elice.shoppingmall.product.repository.ReviewRepository defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Could not create query for public abstract java.util.List io.elice.shoppingmall.product.repository.ReviewRepository.findByProductId(java.lang.Long); Reason: Failed to create query for method public abstract java.util.List io.elice.shoppingmall.product.repository.ReviewRepository.findByProductId(java.lang.Long); Cannot compare left expression of type 'io.elice.shoppingmall.product.entity.Product' with right expression of type 'java.lang.Long' at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:798) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:237) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1354) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1191) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:561) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:907) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:785) ~[spring-beans-6.1.3.jar:6.1.3] ... 19 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reviewRepository' defined in io.elice.shoppingmall.product.repository.ReviewRepository defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Could not create query for public abstract java.util.List io.elice.shoppingmall.product.repository.ReviewRepository.findByProductId(java.lang.Long); Reason: Failed to create query for method public abstract java.util.List io.elice.shoppingmall.product.repository.ReviewRepository.findByProductId(java.lang.Long); Cannot compare left expression of type 'io.elice.shoppingmall.product.entity.Product' with right expression of type 'java.lang.Long' at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1773) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:599) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:907) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:785) ~[spring-beans-6.1.3.jar:6.1.3] ... 33 common frames omitted Caused by: org.springframework.data.repository.query.QueryCreationException: Could not create query for public abstract java.util.List io.elice.shoppingmall.product.repository.ReviewRepository.findByProductId(java.lang.Long); Reason: Failed to create query for method public abstract java.util.List io.elice.shoppingmall.product.repository.ReviewRepository.findByProductId(java.lang.Long); Cannot compare left expression of type 'io.elice.shoppingmall.product.entity.Product' with right expression of type 'java.lang.Long' at org.springframework.data.repository.query.QueryCreationException.create(QueryCreationException.java:101) ~[spring-data-commons-3.2.2.jar:3.2.2] at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.lookupQuery(QueryExecutorMethodInterceptor.java:115) ~[spring-data-commons-3.2.2.jar:3.2.2] at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.mapMethodsToQuery(QueryExecutorMethodInterceptor.java:99) ~[spring-data-commons-3.2.2.jar:3.2.2] at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.lambda$new$0(QueryExecutorMethodInterceptor.java:88) ~[spring-data-commons-3.2.2.jar:3.2.2] at java.base/java.util.Optional.map(Optional.java:260) ~[na:na] at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.(QueryExecutorMethodInterceptor.java:88) ~[spring-data-commons-3.2.2.jar:3.2.2] at org.springframework.data.repository.core.support.RepositoryFactorySupport.getRepository(RepositoryFactorySupport.java:357) ~[spring-data-commons-3.2.2.jar:3.2.2] at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport.lambda$afterPropertiesSet$5(RepositoryFactoryBeanSupport.java:279) ~[spring-data-commons-3.2.2.jar:3.2.2] at org.springframework.data.util.Lazy.getNullable(Lazy.java:135) ~[spring-data-commons-3.2.2.jar:3.2.2] at org.springframework.data.util.Lazy.get(Lazy.java:113) ~[spring-data-commons-3.2.2.jar:3.2.2] at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport.afterPropertiesSet(RepositoryFactoryBeanSupport.java:285) ~[spring-data-commons-3.2.2.jar:3.2.2] at org.springframework.data.jpa.repository.support.JpaRepositoryFactoryBean.afterPropertiesSet(JpaRepositoryFactoryBean.java:132) ~[spring-data-jpa-3.2.2.jar:3.2.2] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1820) ~[spring-beans-6.1.3.jar:6.1.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1769) ~[spring-beans-6.1.3.jar:6.1.3] ... 44 common frames omitted Caused by: java.lang.IllegalArgumentException: Failed to create query for method public abstract java.util.List io.elice.shoppingmall.product.repository.ReviewRepository.findByProductId(java.lang.Long); Cannot compare left expression of type 'io.elice.shoppingmall.product.entity.Product' with right expression of type 'java.lang.Long' at org.springframework.data.jpa.repository.query.PartTreeJpaQuery.(PartTreeJpaQuery.java:106) ~[spring-data-jpa-3.2.2.jar:3.2.2] at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$CreateQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:124) ~[spring-data-jpa-3.2.2.jar:3.2.2] at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$CreateIfNotFoundQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:258) ~[spring-data-jpa-3.2.2.jar:3.2.2] at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$AbstractQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:95) ~[spring-data-jpa-3.2.2.jar:3.2.2] at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.lookupQuery(QueryExecutorMethodInterceptor.java:111) ~[spring-data-commons-3.2.2.jar:3.2.2] ... 56 common frames omitted Caused by: org.hibernate.query.SemanticException: Cannot compare left expression of type 'io.elice.shoppingmall.product.entity.Product' with right expression of type 'java.lang.Long' at org.hibernate.query.sqm.internal.TypecheckUtil.assertComparable(TypecheckUtil.java:358) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.query.sqm.tree.predicate.SqmComparisonPredicate.(SqmComparisonPredicate.java:48) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.query.sqm.tree.predicate.SqmComparisonPredicate.(SqmComparisonPredicate.java:34) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.query.sqm.internal.SqmCriteriaNodeBuilder.equal(SqmCriteriaNodeBuilder.java:2121) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.query.sqm.internal.SqmCriteriaNodeBuilder.equal(SqmCriteriaNodeBuilder.java:192) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.springframework.data.jpa.repository.query.JpaQueryCreator$PredicateBuilder.build(JpaQueryCreator.java:312) ~[spring-data-jpa-3.2.2.jar:3.2.2] at org.springframework.data.jpa.repository.query.JpaQueryCreator.toPredicate(JpaQueryCreator.java:210) ~[spring-data-jpa-3.2.2.jar:3.2.2] at org.springframework.data.jpa.repository.query.JpaQueryCreator.create(JpaQueryCreator.java:121) ~[spring-data-jpa-3.2.2.jar:3.2.2] at org.springframework.data.jpa.repository.query.JpaQueryCreator.create(JpaQueryCreator.java:1) ~[spring-data-jpa-3.2.2.jar:3.2.2] at org.springframework.data.repository.query.parser.AbstractQueryCreator.createCriteria(AbstractQueryCreator.java:119) ~[spring-data-commons-3.2.2.jar:3.2.2] at org.springframework.data.repository.query.parser.AbstractQueryCreator.createQuery(AbstractQueryCreator.java:95) ~[spring-data-commons-3.2.2.jar:3.2.2] at org.springframework.data.repository.query.parser.AbstractQueryCreator.createQuery(AbstractQueryCreator.java:81) ~[spring-data-commons-3.2.2.jar:3.2.2] at org.springframework.data.jpa.repository.query.PartTreeJpaQuery$QueryPreparer.(PartTreeJpaQuery.java:218) ~[spring-data-jpa-3.2.2.jar:3.2.2] at org.springframework.data.jpa.repository.query.PartTreeJpaQuery$CountQueryPreparer.(PartTreeJpaQuery.java:361) ~[spring-data-jpa-3.2.2.jar:3.2.2] at org.springframework.data.jpa.repository.query.PartTreeJpaQuery.(PartTreeJpaQuery.java:102) ~[spring-data-jpa-3.2.2.jar:3.2.2] ... 60 common frames omittedReviewRepositorypackage io.elice.shoppingmall.product.repository; import io.elice.shoppingmall.product.entity.Review; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.stereotype.Repository; import java.util.List; @Repository public interface ReviewRepository extends JpaRepository { List findByProductId(Long id); }Review entitypackage io.elice.shoppingmall.product.entity; import jakarta.persistence.*; import lombok.*; import java.time.LocalDate; @AllArgsConstructor @NoArgsConstructor @Entity @Getter @Setter @Builder public class Review { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long reviewId; @Column(nullable = false) private String context; @Column(name = "writer_nickname", nullable = false) private String writerNickname; @Column(name = "created_date", nullable = false) private LocalDate createdDate; @Column(nullable = false) private int rating; // @ManyToOne // @JoinColumn(name = "user_id", nullable = false) // private User userId; @ManyToOne @JoinColumn(name = "productId", nullable = false) private Product product; public void updateReview(String context, String writerNickname, LocalDate createdDate, int rating, Product product) { this.context = context; this.writerNickname = writerNickname; this.createdDate = createdDate; this.rating = rating; this.product = product; } }product entity id선언 부분 @Id @Column(name = "productId") @GeneratedValue(strategy = GenerationType.IDENTITY) private long productId;review servicepackage io.elice.shoppingmall.product.service; import io.elice.shoppingmall.product.dto.ReviewRequestDto; import io.elice.shoppingmall.product.entity.Review; import io.elice.shoppingmall.product.repository.ProductRepository; import io.elice.shoppingmall.product.repository.ReviewRepository; import jakarta.transaction.Transactional; import lombok.RequiredArgsConstructor; import org.springframework.stereotype.Service; import java.util.List; import java.util.Optional; @Service @RequiredArgsConstructor public class ReviewService { private final ReviewRepository reviewRepository; private final ProductRepository productRepository; // 등록 @Transactional public Review saveReview(Review review){ return reviewRepository.save(review); } // 리뷰 ID로 조회 public Review getReviewById(Long id){ Optional optionalReview = reviewRepository.findById(id); return optionalReview.orElse(null); } // 특정 상품의 리뷰 목록 조회 public List getReviewsByProductId(Long productId){ return reviewRepository.findByProductId(productId); } // 전체 조회 public List reviewList(){ return reviewRepository.findAll(); } // 수정 @Transactional public Review updateReview(Long id, ReviewRequestDto requestDto) { Optional optionalReview = reviewRepository.findById(id); if (optionalReview.isPresent()) { Review existingReview = optionalReview.get(); return reviewRepository.save(existingReview); } else { throw new IllegalArgumentException("유효하지 않은 리뷰 ID입니다."); } } // 삭제 @Transactional public void deleteReview(Long id) { reviewRepository.deleteById(id); } }이렇게 해서 실행을 했는데 다음과 같이 에러가 발생하면서 수정을 할 수 없었습니다. 구글에 검색을 해보니 카멜케이스로 작성하지 않아서 그렇다고 하는데 현재 repository에 적은 메서드 명 말고도 다양한 카멜케이스로 바꾸어봤는데 해결되지 않아 여기에 올리게 되었습니다. 이외에도 spring구조상으로 잘못 코드가 작성된 부분들 등 코드를 잘못 작성한 곳들이 있다면 피드백 반영하겠습니다!

감독님테스트가하고싶어요 · Answer

@Repository public interface ReviewRepository extends JpaRepository { List findByProductId(Long id); }find / By / Product / Id위에 근거해서 jpa는 review 엔티티에서 에서 product를 찾았고,그 이후 product 엔티티에서 에서 id를 찾을텐데 id가 없네요?@Id @Column(name = "productId") @GeneratedValue(strategy = GenerationType.IDENTITY) private long productId;이렇게 선언해두셨으니 findByProductProductId(Long id) 로 하면 될 것 같네요.

spring error Error creating bean with name 'XXX' define in file (다른 entity의 id를 repository를 통해 가져올 수 없음)

1개의 답변

Q&A 목록