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.
You are correct ....and good catch... For making simple, I have used on the class level... As my concerns was how to write custom or native query using JpaRepository.... But for performance wise better to use method level for update, delete and also save ( not for get or retrieve ).. really appreciate your observations... Thank you
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
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
Hi .... use @Query annotation top of the method .. syntax like this ... @Query("Select empid from table where xyz condition", native="true") Then method and logic inside the method
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
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.
Great and welcome
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...
Thank you so much ... You are most welcome
Great Explained Man..! I stuck in my project very badly... your video helped me a lot. nicely explained custom query
Thank you so much for your valuable feedback
Nice example.. I am looking more example for multiple join table custom query for update/save scenario.. Left/ right/innerjoin example.. Thanks
Thank you.... I have shown here for select statement... Anyways I will look into this tropic...
Perfect and simple explaination...Thank You.
Thank you
This is wonderful video and great explaination. May your channel gro, and I encourage you post more content. great job
Thank you 💖 for your support and feedback 😊
Very useful information with example. Thank you.
Thank you so much for your valuable feedback
Very good Explanation sir
Thank you… you are most welcome
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.
You are correct ....and good catch... For making simple, I have used on the class level... As my concerns was how to write custom or native query using JpaRepository.... But for performance wise better to use method level for update, delete and also save ( not for get or retrieve ).. really appreciate your observations... Thank you
Such an awesome explanation I wish u get million likes and subscribers
Thank you so much for your valuable input
need tutorial on mapping Decode function or CASE statement in which new column are there
Ok.. Thank you for being out this topic.
Thank you sir this video has solved my very important issue
You are most welcome
Simple and easy to understand
Thank you
U saved my life man....
Lot of love
You are most welcome
Simple and easy example can you create videos on SqlMapper
Ok.. thank you ...sure I will do
very nice explaination
Thank you so much for your valuable feedback
How can we perform join operation using native query or JPQL?
Yes you can
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
Yes... You can do that.... How I can help you ???
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
Sure... you can drop me an email @ techtalk.debu@gmail.com
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.
Sure, I will do that
Sir how can i fetch data of particular column present in database.
Please help me with this.
Hi .... use @Query annotation top of the method .. syntax like this ...
@Query("Select empid from table where xyz condition", native="true")
Then method and logic inside the method
@@TechTalkDebu Sir can u please make a video on this topic which will be very helpful to all.
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
Okay.... I will create a seperate video for this.. thanks for bring out this
Debu da THANKS
You are most welcome
Doesn't work, I get ApplicationContext error, when I tried to register a query to return recently created record.
Might be there is some other issue in your code..plz check it once
content of video is very good,Can u please make the video on one to many bidirectional relationship.
Thank you... And sure I will make it
I can't find the link to the next tutorial with JOIN query
Oops .. sorry about that... But json query, or something else ??
Please sir make a video how to get data from multiple tables using queries
Sure, Thanks for the suggestion
How do I list the last 10 items from the same customer
is this your github url another project on description?
Oops sry … thanks for pointing … but that project repo there in my GitHub account as public repo
GB is Germany, its UK only, btw nice video..!
Is it possible to write query in property or yaml file and fetch value from it like @Query(${query})? Please reply
I didn’t check , better create Common constants class and make each variable final static string and write query and then use there
Great explanation sir, but code is not present please provide me a link.
Okay.. have you checked GitHub my account,m
@@TechTalkDebu Yes, checked but different code is present not this one.
Nice one bro
Thank your for the feedback
Great job , thank you
Thank you so much
Thank you
Welcome
Thanks sir
You are most welcome
Saludos desde Colombia, Por favor @Query con Inner join
Sorry, I didn't get get that... Could you please let me know...
Play on 1.25x Speed, thank me later
Welcome
HI Sir i am done same way i am getting getData(java.lang.String)! No property 'getData' found for type 'User'
Could you the queries or db details?