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

In this video, I will show you how to define and use custom queries with Spring Data JPA. You will learn how to execute JPQL and native queries, use an expression language in your queries and execute queries that INSERT, UPDATE, or REMOVE records.
But before we start, if this is your first time here, and you want to learn how to create your entity mappings with ease, build incredible efficient persistence layers with Hibernate and all types of other Java persistence related stuff, start now by subscribing and clicking the bell, so you don't miss anything.
Derived queries are very comfortable to use as long as the queries are not too complicated. But as soon as you use more than 2-3 query parameters or need to define multiple joins to other entities, you need a more flexible approach. In these situations, you better use Spring Data JPA’s @Query annotation to specify a custom JPQL or native SQL query.
If you like this video, please give me your thumbs up and share it with your friends and co-workers.
Like my channel? Subscribe!
➜ bit.ly/2cUsid8
Join the free Member Library:
goo.gl/dtyIIC
Read the accompanying post: thoughts-on-java.org/spring-d...
Want to connect with me?
Blog: www.thoughts-on-java.org/
Twitter: / thjanssen123
Facebook: / thoughtsonjava
#JPA #Spring

[@MsPrettyg00d]

Your instructions are clear and short👍. Thank you!

[@DreamingWithEyesWide]

Best videos about JPA- thanks for making them!!

[@4jilson]

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

[@isurangaediriweera7073]

Your videos are really helpful. Thank you very much.

[@luisdavidherreragarcia281]

thank you for sharing your knowledge !

[@sunilcd2008]

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

[@ThoughtsOnJava]

Thanks

[@pisteuo_creciendo_juntos]

thank you, grettings from chile

[@tiituma]

Thank you so much, this video helped a lot

[@nishantbahri]

That was precise.

[@paolofrancescosciammarella1420]

thank u so much!

[@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 :)

[@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

[@sonofgod00]

Thanks

[@varunraj1862]

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

[@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

[@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

[@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.

[@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

[@NitrosS]

insert is possible here? I'm looking for insertion

[@esperanzacutillasrastoll6722]

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

[@ThoughtsOnJava]

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/

[@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!

[@lokeshmurukesh3386]

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

[@chetanbhandari3033]

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

[@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)

[@ThoughtsOnJava]

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]

​@@ThoughtsOnJava Thank you very much for your reply.

[@maheshlokavarapu9696]

Could you please provide oracle r2dbc video series

[@memillin]

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

[@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)

[@ThoughtsOnJava]

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]

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

[@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)]

[@ursfren]

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

[@MrProton2]

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

[@amitdhakal1974]

But no customized delete option in the query

[@davincibaker]

WHAT ABOUT INSERTS ?

[@treeteqs]

what about @restresource

[@yadigarcaliskan6453]

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

[@chessmaster856]

There is no complex query

[@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;