假設(shè)我有一個(gè)實(shí)體@Entity@Table(name = "foos")class Foo{ @Id @Generatedvalue(strategy = IDENTITY) private Long id; @ManyToOne @JoinColumn(name = "bar_id") private Bar bar; ...}和一個(gè)投影應(yīng)該給我一個(gè)id和 一個(gè)boolean告訴我該實(shí)例是否有一個(gè)Bar:interface FooProjection{ String getId(); Boolean hasBar();}如何編寫 JPQL 查詢?我確實(shí)嘗試過(guò)@Query( "SELECT" " f.id," " (f.bar IS NOT NULL) AS bar" " FROM Foo f")List<FooProjection> findProjections();這給了我一個(gè)org.eclipse.persistence.exceptions.JPQLException非常有用的錯(cuò)誤消息該表達(dá)式無(wú)效,這意味著它不遵循 JPQL 語(yǔ)法。你如何編寫這個(gè)查詢?
JPQL——空值到布爾值?
夢(mèng)里花落0921
2023-10-19 21:00:56