@Query，Repository出错 [英] Error in @Query , Repository

问题描述

由于我的实体有关系，可能在 @Query 中出错？
存储库包含错误。

创建名为'clickRepository'的bean时出错：init
方法的调用失败;嵌套异常是java.lang.IllegalArgumentException：
查询方法public abstract
java.lang.String
com.qoobico.remindme.server.repository.ClickRepository.sent（java。 lang.String，long）！

控制器

  @Autowired 
私人ClickService服务; 
 
 / * 
即有关fullname_client，id_banner从客户端发送到服务器的信息
 * / 
 @RequestMapping（value =/ sentemail，method = RequestMethod.POST ）
 @ResponseBody 
 public String sentClick（@RequestParam（fullnameClient）String fullnameClient，@ RequestParam（idbanners）long idbanners）{
 
 return service.sent（fullnameClient） ，idbanners）; 
} 
  

存储库

  @Query（SELECT c.fullnameClient FROM Click AS c join c.idBanner Banners b WHERE b.idBanner =：idbanners AND c.fullnameClient =：fullnameClient）
 String sent（ @Param（fullnameClient）String fullnameClient，@ Param（idbanners）long idbanners）; 
  

实体点击

  @Id 
 @Column（name =id_click，unique = true，nullable = false）
 @GeneratedValue（generator =increment）
 @GenericGenerator（name = 增量，策略=增量）
 private long idClick; 
 
 @ManyToOne（fetch = FetchType.EAGER，cascade = {CascadeType.MERGE，CascadeType.PERSIST}）
 @JoinColumn（name =id_banners，nullable = false）
私人横幅idbanners; 
 
 @Column（name =fullname_client，nullable = false，length = 50）
 private String fullnameClient; 
  

实体横幅

  @Id 
 @Column（name =id_banner，unique = true，nullable = false）
 @GeneratedValue（generator =increment）
 @GenericGenerator（name = increment，strategy =increment）
 private long idBanner; 
 
 @OneToMany（fetch = FetchType.EAGER，mappedBy =banners）
 private Set< Businessbanner> businessbanners; 
 
 @OneToMany（fetch = FetchType.EAGER，mappedBy =idbanners）
 private Set< Click>点击; 
  

错误

org.springframework.beans.factory.BeanCreationException：错误
创建名为'clickController'的bean：注入自动装配的
依赖项失败;嵌套异常是
org.springframework.beans.factory.BeanCreationException：无法
autowire字段：private
com.qoobico.remindme.server.service.ClickService
com.qoobico。 remindme.server.controller.ClickController.service;嵌套
异常是org.springframework.beans.factory.BeanCreationException：
创建名为'clickServiceImpl'的bean时出错：
自动连接依赖项的注入失败;嵌套异常是
org.springframework.beans.factory.BeanCreationException：无法
autowire字段：private
com.qoobico.remindme.server.repository.ClickRepository
com.qoobico。 remindme.server.service.ClickServiceImpl.clickRepository;
嵌套异常是
org.springframework.beans.factory.BeanCreationException：错误
创建名为'clickRepository'的bean：调用init方法
失败;嵌套异常是java.lang.IllegalArgumentException：
查询方法public abstract
java.lang.String
com.qoobico.remindme.server.repository.ClickRepository.sent（java。 lang.String，long）！

解决方案

您的参数名称不同。试试这个：

  @Query（SELECT c.fullnameClient FROM Click AS c join c.idbanners b WHERE b.idBanner =： idbanners AND c.fullnameClient =：fullnameClient）
 
发送的字符串（@Param（fullnameClient）字符串fullnameClient，@ Param（idbanners）long idbanners）; 
  

更新

<好吧你的加入是错的..而不是c加入c.IdBanner ..它应该是c.idbanners。

Maybe error in @Query due to the fact that my entity have relation ? Which the Repository contain error.

Error creating bean with name 'clickRepository': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract java.lang.String com.qoobico.remindme.server.repository.ClickRepository.sent(java.lang.String,long)!

Controller

 @Autowired
private ClickService service;

/*
    i.e. information about fullname_client, id_banner sent to server from client
*/
@RequestMapping(value = "/sentemail", method = RequestMethod.POST)
@ResponseBody
public String sentClick(@RequestParam ("fullnameClient") String fullnameClient,@RequestParam ("idbanners") long idbanners) {

    return service.sent(fullnameClient, idbanners);
}

Repository

@Query("SELECT c.fullnameClient FROM Click AS c join c.idBanner Banners b WHERE b.idBanner = :idbanners AND c.fullnameClient = :fullnameClient")
String sent(@Param("fullnameClient") String fullnameClient, @Param("idbanners") long idbanners);

Entity Click

@Id
@Column(name = "id_click", unique = true, nullable = false)
@GeneratedValue(generator = "increment")
@GenericGenerator(name = "increment", strategy = "increment")
private long idClick;

@ManyToOne(fetch = FetchType.EAGER, cascade = {CascadeType.MERGE, CascadeType.PERSIST})
@JoinColumn(name = "id_banners", nullable = false)
private Banners idbanners;

@Column(name = "fullname_client", nullable = false, length = 50)
private String fullnameClient;

Entity Banners

@Id
@Column(name = "id_banner", unique = true, nullable = false)
@GeneratedValue(generator = "increment")
@GenericGenerator(name = "increment", strategy = "increment")
private long idBanner;

@OneToMany(fetch = FetchType.EAGER, mappedBy = "banners")
private Set<Businessbanner> businessbanners;

@OneToMany(fetch = FetchType.EAGER, mappedBy = "idbanners")
private Set<Click> clicks;

Error

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'clickController': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.qoobico.remindme.server.service.ClickService com.qoobico.remindme.server.controller.ClickController.service; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'clickServiceImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.qoobico.remindme.server.repository.ClickRepository com.qoobico.remindme.server.service.ClickServiceImpl.clickRepository; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'clickRepository': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract java.lang.String com.qoobico.remindme.server.repository.ClickRepository.sent(java.lang.String,long)!

解决方案

Your param names differ. Try this:

 @Query("SELECT c.fullnameClient FROM Click AS c join c.idbanners b WHERE b.idBanner = :idbanners AND c.fullnameClient = :fullnameClient")

    String sent(@Param("fullnameClient") String fullnameClient, @Param("idbanners ") long idbanners);

Update

Ok your join was wrong.. instead of c join c.IdBanner.. it should be c.idbanners.

这篇关于@Query，Repository出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！