我有实体驱动和枚举DriverLanguage. 我想要得到的驱动程序的列表谁可以说选定的语言,通过参数储存库的方法。
...
@Entity
public class Driver{
private Long id;
private firstName;
@ElementCollection(targetClass = DriverLanguage.class)
@Enumerated(EnumType.STRING)
@CollectionTable(name = "driver_language",
joinColumns = @JoinColumn(name = "driver_language_id"))
@Column(name = "driver_language")
private Set<DriverLanguage> languages = new HashSet<>();
}
public enum DriverLanguage {
ENGLISH,
GERMAN
}
现在我用@查询方法。
我第一次的方法:
@Repository
public interface DriverRepository extends JpaRepository<Driver, Long> {
@Query("SELECT d "
+ "FROM Driver d "
+ "JOIN DriverLanguage dl on d.id = dl.driver_language_id "
+ "WHERE dl.driver_language = ?1")
List<Driver> findByLanguage(String language);
}
ERROR: Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: Path expected for join!
然后我读了也许我不应该使用的加入使我试图这样的:
@Repository
public interface DriverRepository extends JpaRepository<Driver, Long> {
@Query("SELECT d "
+ "FROM Driver d, DriverLanguage dl "
+ "WHERE d.id = dl.driver_language_id AND dl.driver_language = ?1")
List<Driver> findByLanguage(String language);
}
ERROR: Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: DriverLanguage is not mapped
什么我丢在这里?