我在尝试激发SQl语句时收到以下错误消息。。。。例外:
QuerySyntaxException: unexpected token: a near line 1, column 127 [SELECT DISTINCT e FROM com.taqwaapps.entity.Event e, com.taqwaapps.entity.Appointment a WHERE e.eventId = a.event.eventId AND a.district.city.name = 'Jeddah' ]
以下SQL语句似乎不正确:
@Query("SELECT DISTINCT e "
+ "FROM Event e, Appointment a "
+ "WHERE e.eventId = a.event.eventId "
+ "AND a.district.city.name = 'Jeddah' ")
List<Event> getEventsFiltered();
我的目标是:
@Entity
public class Event {
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
private Long eventId;
}
和
@Entity
public class Appointment {
@JsonIgnore
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "eventId")
private Event event;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "districtId")
private District district;
怎么了?
我发现了问题:
在过去的学校时光里,我从我的信息学老师那里了解到,在SQL中,可能会出现一个隐藏的字符,我们输入了或输入了,但我们没有看到