Confused over @Query, @Param etc and which library to use

[tangara goh]

I tried to emulate the @Query function in this petclinic spring project :

https://github.com/spring-projects/spring-petclinic/blob/main/src/main/java/org/springframework/samples/petclinic/owner/OwnerRepository.java

Now, I realised that I can also extends JPARepository

And also at the annotation level I can or seems to be able or choose to use a variety of libraries from :

@QueryParam (javax.ws.rs)
@Param(org.springframework.data.repository.query.Param)
@Parameter(org.hibernate.annotation)

If I change all my queries to from javax.ws.rs ,will it cause any problem ?

Or is it safer to use @Param from org.springframework.data.repository.query.Param ?

I am really confused about this part..

Hope someone can advise me

Thanks.

[Rob Spoor]

The three annotations have different purposes.

@QueryParam (javax.ws.rs) only works with JAX-RS. In other words, the web layer. It's meant to map a query parameter to a method argument. It cannot be used with Spring's @Query annotation.

@Param(org.springframework.data.repository.query.Param) is meant to be used in combination with @Query to define that a method argument should be mapped to a parameter inside the query. This is the one you need.

@Parameter(org.hibernate.annotation) is some Hibernate specific thing. No idea how it works, but it cannot be used with Spring's @Query annotation.