Spring Data JPA: Ultimate Guide to Custom Queries with @Query Annotation

[@DreamingWithEyesWide]

Best videos about JPA- thanks for making them!!

[@kthun-v7c]

0:00 Intro 1:42 JPQL Queries 4:18 Sorting 5:52 Paginating Query Results 6:49 SpEL Expressions for Entity Names & Advabced Like Expressions 8:24 Native Queries 9:53 Parameter Handling 12:13 Modifying Queries 13:00 Conclusion 14:25 Thoughts on Java Library

[@4jilson]

Your videos are good, this deserves more likes and views.

[@ricardo.fontanelli]

The best videos about spring and jpa, really well organized and explained, pure gold thank you

[@manuelkyle6591]

You prolly dont care but does anyone know of a method to get back into an Instagram account..? I was stupid lost the password. I would appreciate any assistance you can give me!

[@jaggerowen4148]

@Manuel Kyle instablaster :)

[@manuelkyle6591]

@Jagger Owen I really appreciate your reply. I found the site through google and I'm in the hacking process now. Takes a while so I will get back to you later with my results.

[@manuelkyle6591]

@Jagger Owen it did the trick and I actually got access to my account again. Im so happy! Thank you so much you saved my account!

[@jaggerowen4148]

@Manuel Kyle You are welcome :)

[@MsPrettyg00d]

Your instructions are clear and short👍. Thank you!

[@luisdavidherreragarcia281]

thank you for sharing your knowledge !

[@sunilcd2008]

Thank you Thorben! Very well explained and pretty clear about each concept!

[@Thorben-Janssen]

Thanks

[@isurangaediriweera7073]

Your videos are really helpful. Thank you very much.

[@surbhigangrade9251]

Very well explanation, could you please provide the link for Guide to JPQL Query?

[@varunraj1862]

Great video. May i know how to reference the fields declared indide the entity using SPeL. It will be really helpful.

[@gamatossian]

I think there's a small error there @ 12:00? @Param("lastName") String firstName, @Param("firstName") String lastName Assuming it should be: @Param("firstName") String firstName, @Param("lastName") String lastName

[@nishantbahri]

That was precise.

[@memillin]

12:06 It seems that named bind parameters are flipped.

[@Francis_dev]

thank you, grettings from chile

[@NitrosS]

if you wanna insert use this: @Modifying @Query(value = "insert into author(first_name, last_name, version) values(?#{#author.firstName}, ?#{#author.lastName}, ?#{#author.version})",nativeQuery = true) void insert(@Param("author") Author author); //SpEL Expressions You have to use @Modifying and maybe @Transactional. There is another method to insert and it's the EntityManager.

[@tiituma]

Thank you so much, this video helped a lot

[@ianwanjala8621]

hey, this is very good content, but the link provided for accessing the free java thoughts materials is not working, could I get those materials? Thanks again!

[@paolofrancescosciammarella1420]

thank u so much!

[@sonofgod00]

Thanks

[@UTUBDZ]

Guten Tag Janssen ! Can you give a hint on how to write a JPQL queries when the WHERE close contains objects (Ex: SELECT * FROM USERS WHERE userBooks.count(*) > 10)

[@Thorben-Janssen]

Is userBooks a managed association? If it is, you could use the size function to count the elements in it, e.g.: SELECT u FROM Users WHERE SIZE(u.userBooks) > 10

[@UTUBDZ]

​@@Thorben-Janssen Thank you very much for your reply.

[@MsPaulisa]

How do you use a list parameter with columns that you want to select? I tried something like "select ?3 from products where category = ?1 and status = ?2" . And ?3 is a List with the columns that I want to select... but it does not work...

[@abhinavrayakwar6676]

While updating or altering the table with paramerter , spring jpa add extra quotes in query " ' " this single quote help

[@NitrosS]

insert is possible here? I'm looking for insertion

[@maheshlokavarapu9696]

Could you please provide oracle r2dbc video series

[@vtdx4]

when we bind parameters in case of my parameter is an object how can I bind one property of the object inside query. can I access it with dot notation

[@MrProton2]

How Spring Data JPA Native Querry worked with SELECT FOR UPDATE SKIP LOCKED ?

[@esperanzacutillasrastoll6722]

how do you do a left join with that? Thank you. With to related entities with a one to one relationship

[@Thorben-Janssen]

You can use all features of JPQL in your custom query. LEFT JOIN is one of them. Find out more here: thorben-janssen.com/jpql/

[@rajuTravelMemories]

Could u please help me on thi Caused by: java.lang.IllegalArgumentException: Can't compare test expression of type [CommodityEntity] with element of type [BasicSqmPathSource(materialId : Long)]

[@amitdhakal1974]

But no customized delete option in the query

[@senthilmurugangsm]

How can we select few columns in @Query annotations and return the list of entities with only those specific columns as JSON. (Not all values of entity)

[@Thorben-Janssen]

Hi Senthil, you can only select an entity with all its attributes. If you want to select a subset, you need to use a DTO projection. I explain that in this video: kzbin.info/www/bejne/f4G1l61vbJKBp6M In the video, I only use Hibernate without Spring Data JPA. But you can apply the same approach using Spring. Regards, Thorben

[@senthilmurugangsm]

@@Thorben-Janssen thanks for the response. Is any other way available by without creating another pojo class ?

[@lokeshmurukesh3386]

can we do "select into" query in @Query ?

[@ursfren]

How to index pdf content by using spring-data? We will really appreciate if some one can answer this question.

[@chetanbhandari3033]

Hi Video is too good pls provide github link for source code

[@davincibaker]

WHAT ABOUT INSERTS ?

[@TylerBrewster-o5w]

559 Meta Circle

[@yadigarcaliskan6453]

Why does spring try to overtake the industry? I don’t like

[@AllisonDominguez-t9o]

Cedrick Island

[@HuxleyQuinn-t6o]

Mathew Dam

[@HearstAnastasia-j6w]

Frederique Walk

[@WalkerOConnor]

20885 Audra Station

[@GregoryWright-r9n]

Brock Fields

[@ThodoreWilbur]

0435 Lea Glen

[@treeteqs]

what about @restresource

[@sidof8065]

Thanks for the content ! how write jUnit test of class with enum properties. Like public interface HouseRepository extends PagingAndSortingRepository { Page findByHouseTypeContaining(HouseType houseType, Pageable pageable); } @Entity(name = "house") public class House { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "house_sequence") @SequenceGenerator(name = "house_sequence",sequenceName = "house_sequence",allocationSize = 1) private Long id; @Enumerated(STRING) private HouseType houseType;

[@NicholasBarry-u7g]

16020 Hudson Bridge

[@LouiseDonald-rw9ox]

40296 Moen Turnpike

[@JenellePregeant]

7888 Alysa Mountain

[@BeminHania]

32429 Dietrich Trafficway