@Query,存储库中有错误

新浪潮

也许是@Query由于我的实体有关系导致的错误哪个存储库包含错误。

创建名称为'clickRepository'的bean时出错:调用init方法失败;嵌套异常是java.lang.IllegalArgumentException:方法公共抽象java.lang.String com.qoobico.remindme.server.repository.ClickRepository.sent(java.lang.String,long)的查询验证失败!

控制器

 @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);
}

资料库

@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 = "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;

实体横幅

@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;

错误

org.springframework.beans.factory.BeanCreationException:创建名称为'clickController'的bean时出错:自动连接依赖项的注入失败;嵌套的异常是org.springframework.beans.factory.BeanCreationException:无法自动连线字段:私有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:无法自动连线字段:私有com.qoobico.remindme.server.repository.ClickRepository com.qoobico.remindme.server.service.ClickServiceImpl.clickRepository; 嵌套的异常是org.springframework.beans.factory。BeanCreationException:创建名称为'clickRepository'的bean时出错:调用init方法失败;嵌套异常是java.lang.IllegalArgumentException:方法公共抽象java.lang.String com.qoobico.remindme.server.repository.ClickRepository.sent(java.lang.String,long)的查询验证失败!

马克西·科瓦尔斯基(Maciej Kowalski)

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

 @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);

更新

好的,您的连接是错误的..而不是c连接c.IdBanner ..应该是c.idbanners。

本文收集自互联网,转载请注明来源。

如有侵权,请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章