AI 助理
备案控制台
开发者社区> 问答> 正文

UnsatisfiedDependencyException-创建名称为bean的错误

我在Spring项目中遇到了一个bean创建问题，我不知道该怎么办。感谢您的关注！

这是我的控制台输出：

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'cartServiceImpl' defined in file [C:\Users\Ramil\eclipse-workspace\market-master\target\classes\market\service\impl\CartServiceImpl.class]: Unsatisfied dependency expressed through constructor parameter 2; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'productServiceImpl' defined in file [C:\Users\Ramil\eclipse-workspace\market-master\target\classes\market\service\impl\ProductServiceImpl.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'productDAO': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Either use @Param on all parameters except Pageable and Sort typed once, or none at all!
    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:798) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:228) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1358) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1204) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:879) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:878) ~[spring-context-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) ~[spring-context-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) ~[spring-boot-2.2.3.RELEASE.jar:2.2.3.RELEASE]
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747) [spring-boot-2.2.3.RELEASE.jar:2.2.3.RELEASE]
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) [spring-boot-2.2.3.RELEASE.jar:2.2.3.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.2.3.RELEASE.jar:2.2.3.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.2.3.RELEASE.jar:2.2.3.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215) [spring-boot-2.2.3.RELEASE.jar:2.2.3.RELEASE]
    at market.Application.main(Application.java:20) [classes/:na]
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'productServiceImpl' defined in file [C:\Users\Ramil\eclipse-workspace\market-master\target\classes\market\service\impl\ProductServiceImpl.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'productDAO': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Either use @Param on all parameters except Pageable and Sort typed once, or none at all!
    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:798) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:228) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1358) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1204) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1287) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1207) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:885) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:789) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    ... 19 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'productDAO': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Either use @Param on all parameters except Pageable and Sort typed once, or none at all!
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1287) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1207) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:885) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:789) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    ... 33 common frames omitted
Caused by: java.lang.IllegalArgumentException: Either use @Param on all parameters except Pageable and Sort typed once, or none at all!
    at org.springframework.util.Assert.isTrue(Assert.java:118) ~[spring-core-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.data.repository.query.Parameters.assertEitherAllParamAnnotatedOrNone(Parameters.java:317) ~[spring-data-commons-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.repository.query.Parameters.<init>(Parameters.java:106) ~[spring-data-commons-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.jpa.repository.query.JpaParameters.<init>(JpaParameters.java:45) ~[spring-data-jpa-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.jpa.repository.query.JpaQueryMethod.createParameters(JpaQueryMethod.java:385) ~[spring-data-jpa-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.jpa.repository.query.JpaQueryMethod.createParameters(JpaQueryMethod.java:58) ~[spring-data-jpa-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.repository.query.QueryMethod.<init>(QueryMethod.java:81) ~[spring-data-commons-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.jpa.repository.query.JpaQueryMethod.<init>(JpaQueryMethod.java:103) ~[spring-data-jpa-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$AbstractQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:78) ~[spring-data-jpa-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.lookupQuery(RepositoryFactorySupport.java:574) ~[spring-data-commons-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.lambda$mapMethodsToQuery$1(RepositoryFactorySupport.java:567) ~[spring-data-commons-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193) ~[na:1.8.0_232]
    at java.util.Iterator.forEachRemaining(Iterator.java:116) ~[na:1.8.0_232]
    at java.util.Collections$UnmodifiableCollection$1.forEachRemaining(Collections.java:1051) ~[na:1.8.0_232]
    at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801) ~[na:1.8.0_232]
    at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482) ~[na:1.8.0_232]
    at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:472) ~[na:1.8.0_232]
    at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708) ~[na:1.8.0_232]
    at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[na:1.8.0_232]
    at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:566) ~[na:1.8.0_232]
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.mapMethodsToQuery(RepositoryFactorySupport.java:569) ~[spring-data-commons-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.lambda$new$0(RepositoryFactorySupport.java:559) ~[spring-data-commons-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at java.util.Optional.map(Optional.java:215) ~[na:1.8.0_232]
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.<init>(RepositoryFactorySupport.java:559) ~[spring-data-commons-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.repository.core.support.RepositoryFactorySupport.getRepository(RepositoryFactorySupport.java:332) ~[spring-data-commons-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport.lambda$afterPropertiesSet$5(RepositoryFactoryBeanSupport.java:297) ~[spring-data-commons-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.util.Lazy.getNullable(Lazy.java:212) ~[spring-data-commons-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.util.Lazy.get(Lazy.java:94) ~[spring-data-commons-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport.afterPropertiesSet(RepositoryFactoryBeanSupport.java:300) ~[spring-data-commons-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.data.jpa.repository.support.JpaRepositoryFactoryBean.afterPropertiesSet(JpaRepositoryFactoryBean.java:121) ~[spring-data-jpa-2.2.4.RELEASE.jar:2.2.4.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1855) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1792) ~[spring-beans-5.2.3.RELEASE.jar:5.2.3.RELEASE]
    ... 44 common frames omitted

这是我的“ CartServiceImpl.java”类

 package market.service.impl;

 import market.dao.CartDAO;
 import market.domain.Cart;
 import market.domain.CartItem;
 import market.domain.Product;
 import market.domain.UserAccount;
 import market.exception.UnknownEntityException;
 import market.service.CartService;
 import market.service.ProductService;
 import market.service.UserAccountService;
 import org.slf4j.Logger;
 import org.slf4j.LoggerFactory;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Propagation;
 import org.springframework.transaction.annotation.Transactional;

 import java.util.List;
 import java.util.Optional;

 @Service
 public class CartServiceImpl implements CartService {
 private static final Logger log = LoggerFactory.getLogger(CartServiceImpl.class);

 private final CartDAO cartDAO;
 private final UserAccountService userAccountService;
 private final ProductService productService;

   public CartServiceImpl(CartDAO cartDAO, UserAccountService userAccountService, 
   ProductService productService) {
    this.cartDAO = cartDAO;
    this.userAccountService = userAccountService;
    this.productService = productService;
}

@Transactional(propagation = Propagation.SUPPORTS)
@Override
public Cart getCartOrCreate(String userEmail) {
    UserAccount account = userAccountService.findByEmail(userEmail);
    Optional<Cart> cartOptional = cartDAO.findById(account.getId());
    return cartOptional.orElseGet(() -> createCart(account));
}

private Cart createCart(UserAccount account) {
    if (log.isDebugEnabled())
        log.debug("Creating new cart for account #" + account.getId());
    return cartDAO.save(new Cart(account));
}

@Transactional
@Override
public Cart addToCart(String userEmail, long productId, int quantity) throws 
UnknownEntityException {
    Cart cart = getCartOrCreate(userEmail);
    Product product = productService.getProduct(productId);
    if (product.isAvailable()) {
        cart.update(product, quantity);
        return cartDAO.save(cart);
    } else {
        return cart;
    }
}

@Transactional
@Override
public Cart addAllToCart(String userEmail, List<CartItem> itemsToAdd) {
    Cart cart = getCartOrCreate(userEmail);
    boolean updated = false;
    for (CartItem item : itemsToAdd) {
        Optional<Product> product = productService.findOne(item.getProduct().getId());
        if (product.isPresent() && product.get().isAvailable()) {
            cart.update(product.get(), item.getQuantity());
            updated = true;
        }
    }
    return updated ? cartDAO.save(cart) : cart;
}

@Transactional
@Override
public Cart setDelivery(String userEmail, boolean deliveryIncluded) {
    Cart cart = getCartOrCreate(userEmail);
    cart.setDeliveryIncluded(deliveryIncluded);
    return cartDAO.save(cart);
}

@Transactional
@Override
public Cart clearCart(String userEmail) {
    Cart cart = getCartOrCreate(userEmail);
    cart.clear();
    return cartDAO.save(cart);
   }
}

这是“ ProductServiceImpl”类

 package market.service.impl;
import market.dao.ProductDAO;
import market.domain.Distillery;
import market.domain.Product;
import market.domain.Region;
import market.exception.UnknownEntityException;
import market.service.DistilleryService;
import market.service.ProductService;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

  import java.util.Comparator;
  import java.util.List;
  import java.util.Map;
  import java.util.Optional;
  import java.util.stream.Collectors;

 @Service
 public class ProductServiceImpl implements ProductService {

 private final ProductDAO productDAO;
 private final DistilleryService distilleryService;

public ProductServiceImpl(ProductDAO productDAO, DistilleryService distilleryService) {
    this.productDAO = productDAO;
    this.distilleryService = distilleryService;
}

@Transactional(readOnly = true)
@Override
public List<Product> findAll() {
    return productDAO.findAll().stream()
        .sorted(Comparator.comparing(Product::getName))
        .collect(Collectors.toList());
}

@Transactional(readOnly = true)
@Override
public Page<Product> findAll(PageRequest request) {
    return productDAO.findAll(request);
}

@Transactional(readOnly = true)
@Override
public Page<Product> findByDistillery(Distillery distillery, PageRequest request) {
    return productDAO.findByDistilleryOrderByName(distillery, request);
}

@Transactional(readOnly = true)
@Override
public Page<Product> findByRegion(Region region, PageRequest request) {
    return productDAO.findByRegionOrderByName(region, request);
}

@Transactional(readOnly = true)
@Override
public Page<Product> findByAvailability(String available, PageRequest request) {
    Page<Product> pagedList;
    if ("all".equals(available)) {
        pagedList = productDAO.findAll(request);
    } else {
        boolean availability = Boolean.parseBoolean(available);
        pagedList = productDAO.findByAvailableOrderByName(availability, request);
    }
    return pagedList;
}

@Transactional(readOnly = true)
@Override
public Product getProduct(long productId) throws UnknownEntityException {
    return productDAO.findById(productId)
        .orElseThrow(() -> new UnknownEntityException(Product.class, productId));
}

@Transactional(readOnly = true)
@Override
public Optional<Product> findOne(long productId) {
    return productDAO.findById(productId);
}

@Transactional
@Override
public void create(Product product, String distilleryTitle) {
    saveInternal(product, distilleryTitle, true);
}

@Transactional
@Override
public void update(Product product, String distilleryTitle) throws UnknownEntityException {
    Product original = getProduct(product.getId());
    product.setId(original.getId());
    saveInternal(product, distilleryTitle, original.isAvailable()); // keep original availability
}

private void saveInternal(Product changed, String distilleryTitle, boolean available) {
    Distillery distillery = distilleryService.findByTitle(distilleryTitle);
    if (distillery != null) {
        changed.setDistillery(distillery);
        changed.setAvailable(available);
        productDAO.save(changed);
    }
}
@Override
public void updateAvailability(Map<Boolean, List<Long>> productIdsByAvailability) {
    for (Map.Entry<Boolean, List<Long>> e : productIdsByAvailability.entrySet()) {
        Boolean targetAvailability = e.getKey();
        List<Product> productsToUpdate = e.getValue().stream()
            .map(this::findOne)
            .filter(Optional::isPresent)
            .map(Optional::get)
            .filter(product -> product.isAvailable() != targetAvailability)
            .collect(Collectors.toList());
        for (Product product : productsToUpdate) {
            product.setAvailable(targetAvailability);
            productDAO.save(product);
        }
    }
}

@Transactional
@Override
public void delete(long product) {
    productDAO.deleteById(product);
     }
  }

和“ ProductDAO”类。我尝试将第二个@Param添加到'findByRegionOrderByName'，但这没有帮助

package market.dao;

import market.domain.Distillery;
import market.domain.Product;
import market.domain.Region;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;

 public interface ProductDAO extends CrudRepository<Product, Long>, JpaRepository<Product, Long> {

Page<Product> findByDistilleryOrderByName(Distillery distillery, PageRequest request);

@Query(value = "SELECT p FROM Product p WHERE p.distillery IN (SELECT d FROM Distillery d WHERE d.region = :region) order by p.name")
Page<Product> findByRegionOrderByName(@Param("region") Region region, PageRequest request);

Page<Product> findByAvailableOrderByName(boolean available, PageRequest request);
}

问题来源：Stack Overflow

展开
收起
montos 2020-03-28 09:22:19 1179 0
1 条回答
写回答
取消 提交回答
  • montos

    问题是

    IllegalArgumentException: Either use @Param on all parameters except Pageable and Sort typed once, or none at all!

    要解决此问题，只需删除@Param注释：

    Page<Product> findByRegionOrderByName(Region region, PageRequest request);

    回答来源：Stack Overflow

    2020-03-28 09:22:45
    赞同 展开评论 打赏
问答分类：
Java Spring
问答地址：
开发者社区 > 开发与运维 > 问答

版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

相关问答
为什么参数 systemName（系统名称）没有被注入值？
329
1
0
下列代码中配置信息在哪?哪个方法是默认的？
391
1
0
为什么在校验类内部函数的名字规则是固定的validate_属性名呀？
325
1
0
实例属性如何进行修改？
295
1
0
SpringBoot 文件实体Bean报错：无效的bean属性
876
2
0
怎么修改名称啊
759
0
0
错误: 对象不支持“getParentNode”属性或方法?报错
664
1
0
如何自定义Grails2.3.0的Bean属性验证：报错
425
1
0
对函数方法注入一个实例报错了...?报错
569
1
0
通用Mapper自定接口注入失败?报错
774
1
0
问答排行榜
最热
最新
1 【大咖问答】对话PostgreSQL 中国社区发起人之一，阿里云数据库高级专家 德哥 1819069
2 据说在家办公的程序员是这样写代码的？ 1793233
3 阿里云开放端口权限 690323
4 如何升级配置 536314
5 【藏经阁一起读（27）】本周推荐《Apache Flink案例集（2022版）》，你有哪些心得？ 522880
6 【精品问答】python技术1000问(1) 514143
7 Flink Forward Asia 2021 有奖问答 512924
8 OceanBase 使用动画（持续更新） 359389
9 阿里云LNAMP(Linux + Nginx + Apache + MySQL + PHP)环境一键安装脚本 329809
10 为体验实验室取一个新名字。 307501
11 企业邮箱发送邮件时，若出现投递失败产生退信，内容提示包含如下： the mta server of * reply:550 failed to meet SPF requirements 或者 the mta server of 163.com — 163mx01.mxmail.netease.com(220.181.14.141) reply:550 MI:SPF mx14,QMCowECpA0qTiftVaeB3Cg—.872S2 1442548128 http://mail.163.com/help 304112
12 Win Server 2003-2016 加密勒索事件必打补丁合集 295343
13 FLASH播放器，在IE浏览器下显示请确定您的域名已完成备案和CNAME绑定 284231
14 安全组详解，新手必看教程 277354
15 写code还是做管理，开发者如何进行职业规划？ 269208
16 惊喜翻倍：免费ECS+免费环境配置~！(ECS免费体验6个月活动3月31日结束) 255889
17 阿里云手机和阿云浏览器连接问题专帖 235700
18 支付宝H5 下载的时候，提示 【请确保该下载文件来源安全,如需浏览,请长按网址复制后使用浏览器访问】 229717
19 请问阿里云邮箱如何开启SMTP服务啊！ 225891
20 一个备案号，如何备案多个域名？ 223696
1 AI视频技术的发展是否会影响原创内容的价值？ 312
2 日常工作中，开发者应该如何避免“效率陷阱”？ 210
3 AI 编码助手能否引领编程革命？一起探索 AI 对研发流程的变革 740
4 宜搭数据管理页面如何把一个字段设置为链接跳转 130
5 AI新茶饮，是噱头还是未来？ 1051
6 开发者们需要如何打造属于自己的Plan B? 447
7 动机VS自律，对开发者们来说哪个比较重要？ 552
8 AI音色克隆挑战播客，它能模拟人的特质吗？ 1098
9 阿里云RDS mysql数据库show slave status信息疑问 410
10 求助：宜搭如何在请求数据源时传入参数 149
11 宜搭报表对日期字段赋值 299
12 求助：如何在宜搭自定义表单中获取普通表单子表单中的数据 227
13 AI生成海报or人工手绘，哪个更戳你？ 2277
14 “AI +脱口秀”，笑点能靠算法去创造吗？ 1226
15 宜搭配置更新花名册信息的连接器 299
16 请教：通过按钮打开另外一个表单，并把其中一个值传递给另一个表单的其中一个字段。 478
17 AI宠物更适合当代年轻人的陪伴需求吗？ 1474
18 AI客服未来会完全代替人工吗？ 1902
19 modelscope下载 的模型 如何转ollama 532
20 关于宜搭自定义页面循环数据渲染的问题。 155
推荐问答
乘风问答官招募中！机械键盘免费拿

相关文章

  • 🌱 深入Spring的心脏：Bean配置的艺术与实践 🌟
  • 关于Redisson分布式锁的用法
  • ArrayList 和 LinkedList 谁更适合你的项目？这篇文章告诉你！
  • 分布式系统架构3：服务容错
  • OpenAI API深度解析：参数、Token、计费与多种调用方式

    • 相关电子书

    更多
    • 低代码开发师（初级）实战教程 立即下载
    冬季实战营第三期：MySQL数据库进阶实战 立即下载
    阿里巴巴DevOps 最佳实践手册 立即下载

    相关实验场景

    更多
  • 对象和接口-2：常见用法
    19
    1.0小时
    去实验