[SPRING] @Query, Repository의 오류

@Query, Repository의 오류

내 엔터티에 관계가 있기 때문에 @Query에서 오류가 발생할 수 있습니까? 저장소에 오류가 있습니다.

제어 장치

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

오류

해결법

1. ==============================

   1.귀하의 이름은 다릅니다. 이 시도:

   귀하의 이름은 다릅니다. 이 시도:

    @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.IdBanner .. c.idbanners에 가입해야합니다.

from https://stackoverflow.com/questions/41874743/error-in-query-repository by cc-by-sa and MIT license