JPA/Hibernate Fundamentals 2023 - Lesson 9 - JPQL queries

[@WenyuShi-b8g]

The explanation about "select p from Product p" vs. "select * from Product" starting around time point 19:00 was GOLD. Thank you so much.

[@FailMachineInc]

thank you, appreciate the series

[@java_tar]

thanks so much for the series very informative i usually don't write the entity classes manually like i see you do here i just set the value in the persistence unit the exclude-unlisted-classes to false which just maps all my entities directly is that a bad approach ?

[@zaidrj7374]

Thanks

[@alessandromaini6267]

How do you highlight and autocomplete the JPQL queries?

[@mihaiforfota3009]

Unfortunately the JPQL is limited to only a few functions like count, avg, min, max. At some point I had to create query (left join) and to use functions like string_agg / array_agg and the resulted query could only be a native one.

[@laurspilca]

Hi. If you can't avoid using JPQL you may use native queries. I will show you some alternatives to do that in one of the next episodes. But mind that this should be only for corner cases.

[@mitchd.9414]

Laurentiu, would you be kind enough please, to make a series about microservices and how to develop microservices, when there are relationships between entities, so when each microservice represents an entity and is linked with another microservices in relations 1:1 1:m, m:1 or m:n relations. How do we support this llinkage between entities, which are now divided among different mcroservices, if relationship annotations do not work here any longer ?

[@maksadnahibhoolna-wc2ef]

How does JPQL compare to LINQ in dotnet environment

[@laurspilca]

Hello. Sorry. I cannot make such a comparison. I am not a .NET developer.

[@MallikarjunReddy35]

Select Count(1) or Select Count(*) which one is better to use while coding

[@akshaypande7115]

Select count(1)

[@laurspilca]

I would say select count(1) if what you want is just counting the records. But this is a SQL question and remember that even if as any other developer I work and am professional with SQL, I'm not at expert in it. Maybe you want to rise this question (or others related) to Vlad Mihalcea?

[@ellazeoakman4938]

771 Katelin Radial

[@CarmenQuincy-g2h]

Davis Sharon Gonzalez Betty Clark Daniel

[@adanitagalbraith7989]

Miller Anthony Harris Jason Lopez Timothy

[@MariaThomas-j1y]

Rodriguez Donna Robinson Frank Martinez William

[@WhitneyPerry-t5q]

Walker Timothy Martin Anthony Hernandez Steven

[@LyttonDominic-s5l]

Perez Daniel Lewis John Robinson Jessica

[@DebraLittle-pz5um]

Wilson Paul Wilson Steven Gonzalez David

[@AbedaCarlos]

Rodriguez Daniel Miller Sandra Miller Richard

[@AlisonHoward4ye]

Harris Anthony Martin Donna Clark Helen

[@PatrickPerez-o1b]

Miller Sandra Miller Elizabeth Johnson Jennifer

[@GddbHdhd-gb4wl]

Gonzalez George Gonzalez Kimberly Young Eric

[@dimakim-n6c]

Miller Michael Gonzalez Jeffrey Johnson Jessica

[@BlossomSummit-f5s]

Gonzalez Sharon Jackson Michael Miller Brian

[@minakhan-c4m]

Gonzalez Amy Jackson Carol Miller Melissa