JPA & Hibernate: Using the Optimal Query Approach & Projection

[@artrahman169]

Its quite an overwhelming hotch potch of choices .. thanks for imposing some order on the chaos!

[@skd181086]

Does JPA support pairwise comparison? If yes and if you have some video link for that kindly share

[@SergioTheDrifter]

Is there a way to query a manytomany relationship ordering on a column in the join table? I have a nutrition database where Food and Nutrient are associated through Food_Nutrient and that has an amount field which I want to order by and then limit the results to 25 food entities. My last resort is native sql, but if I can do it otherwise I will. Thanks for the videos on the channel, they are very instructive.

[@ashtwenty12]

Excellent I was just looking for what best query to use for my project. thankyou. Ps is there a way I can query by eg a book object, when some of the values are not set and other times have all of different fields. criteria dto?

[@christophe_agoero]

thank you for this video. You're not talking about request by specification. When to use them? Personally when my request is dynamic or without projection I use it. The advantage is that the specification is reusable unlike a criterion of the API criteria

[@Thorben-Janssen]

I am glad that you liked it.

[@mariavyxkyloves]

done subscribe