Spring Data JPA : How to write custom query by JpaRespository | Native Query

#JpaRespository #CustomQuery
► Java: Write custom query with @Query & @NamedQuery annotation by Spring Data JPA
► SUBSCRIBE & LIKE!!
► Download the sample java microservice application :

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
► Here is our amazing playlist for Core Java, Spring MVC/Boot, Git and Micro service
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Watch my "Most Watched Videos"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

In order to define SQL to execute for a Spring Data repository method, we can annotate the method with the @Query annotation — its value attribute contains the JPQL or SQL to execute.

It's a good approach to place a query definition just above the method inside the repository rather than inside our domain model as named queries. The repository is responsible for persistence, so it's a better place to store these definitions.

2.1. JPQL
By default the query definition uses JPQL.

Let's look at a simple repository method that returns active User entities from the database:

Collection(User) findAllActiveUsers();

Please note: if you are using JPQL then you have to provide the exact Entity name in the entity class. else you will get below exception :

Native
We can use also native SQL to define our query. All we have to do is to set the value of the nativeQuery attribute to true and define the native SQL query in the value attribute of the annotation:

@Query(
nativeQuery = true)
Collection(UserDetails) findAllActiveUsersNative();

Regards,
Debu Paul

[pranavrustogi]

Thank you so much bro. I was stuck in my project and didn't got any result but your video resolved it in just 5 minutes. Thank you so much again.

[abhijeetsingh]

Bro you have no idea how much happy i am right now after watching your video and running my code successfully...God bless you man...

[ujjvalsharma]

This is wonderful video and great explaination. May your channel gro, and I encourage you post more content. great job

[vaibhavbhoite]

Great Explained Man..! I stuck in my project very badly... your video helped me a lot. nicely explained custom query

[chandrasekharreddy]

Very useful information with example. Thank you.

[shubhamkadbe]

Perfect and simple explaination...Thank You.

[rushikeshbetkar]

Thank you sir this video has solved my very important issue

[tejabtitare]

Nice example.. I am looking more example for multiple join table custom query for update/save scenario.. Left/ right/innerjoin example.. Thanks

[ecleticodostemposatuais]

How do I list the last 10 items from the same customer

[indiankaran_c]

need tutorial on mapping Decode function or CASE statement in which new column are there

[kappaj]

You have @Transactional at the class level of the service. This will add a lot of extra overhead for a mere get, search. Much more efficient to add to update and insert methods only.

[daamisanda]

i need 2 methods get in my controller findAll one to get liste of prospect and the second for execute my query with findAll also so i hope you can help me thanks

[sunilchandranu]

can you help me on basic understanding of how to map user defined data types in oracle db, such as arrays in JPA . I heard i need to write custom dialect for that. Please point me to the correct video. It would be a great help. Thank you

[SlBoss]

Is it possible to write query in property or yaml file and fetch value from it like @Query(${query})? Please reply

[wkzfswg]

Hi thanks for the video
I tried the same what you shared in the video i am getting IllegalArgument Exception mentioning parameter has been pased but it is not mentioned in the query.But if i am using another approach using @param it is working fine i will be glad if u could help me with this. thanks in advance for your time .hoping to hear from you soon

[nullpointer]

Such an awesome explanation I wish u get million likes and subscribers

[manutyagi]

How can we perform join operation using native query or JPQL?

[bumblebity]

Doesn't work, I get ApplicationContext error, when I tried to register a query to return recently created record.

[rohitprajapati]

Sir how can i fetch data of particular column present in database.
Please help me with this.

[jashobantagiri]

Sir could you please upload how to mapped table in spring data jpa and how to write custom query for them in spring data jpa.