HQL Query inside spring @Query annotation

Question

I have been trying to understand the difference between HQL and JPQL. The hibernate documentation at here

suggest that writing select is necessary for JPQL but not in HQL. But when I try writing HQL or JPQL inside Query annotation of spring data JPA , both HQL and JPQL works .

import java.util.List; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.CrudRepository; public interface UserRepository extends CrudRepository<User, Long> { @Query(value = "from com.demo.spring.data.jpa.User u") public List<User> findAllUsersHQL(); @Query(value = "select u from com.demo.spring.data.jpa.User u") public List<User> findAllUsersJPQL(); }

My understanding is since the Query annotation is intended for JPA why is HQL supported ?

Or let me put in other words -

Can we write HQL in the Query annotation - Does spring data JPA supports both ?

I can't answer your question completely but i can atleast tell you why the JPA Query works. Out of the documentation in the first sentence: A JPQL query is always a valid HQL query, the reverse is not true however.. Because it's a valid HQL (with and without select), it's also a valid JPQL. I don't know why the documentation is telling something different. — jdickel
– jdickel, Commented Jul 30, 2020 at 6:36

Anand Vaidya · Accepted Answer · 2020-07-30 07:59:16Z

I think it depends on which JPA impleemntation you use.

Even though Spring data says it supports JPQL, Spring data in itself isnt implememnting any functionality for validating and implementing queries with JPQL.

Spring will rely on underlying JPA impleemntation that will validate and convert given JPQL queries into plain SQL.

If the underlying adapter is a hibernate Adapter, There are fair chances that it will support HQL and will not limit the application to JPQL.

Moreover, as jdicker mentioned above, JPQL is a subset of HQL, or in the other words, hibernate provided mucm more functionalty than that of JPA.. so you shoudl be able to parse HQL in spring data as long as you are using Hibernate sa an underlying JPA engine.

DIY - You can try putting a breakpoint in QueryTranslatorImpl and confirm the behavior yourself.

Collectives™ on Stack Overflow

HQL Query inside spring @Query annotation

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related