What an amazing explanation bro... Keep it up.. I've searched this topic everywhere in google from last 2 days & now I cleared my all doubts regarding JPQL & native query.. Many any Thanks to you....
Mere pass ek database hai ussme 20 schemas hai...aur ek table hai jo inn saare schemas mein hai,toh ab @Query mein native query likhta hu mein kch aise @Query(value="select * from schemaname.tablename",nativeQuery=true) Ab issue yeh hai ki mujhe har schema k liye yeh seperately likhni pad rahi hai...means 20 @Query use karna padh raha hai.....koi aise tareeka hai ki jisse query mein schemaname dynamically de saku...kisi parameter se ya fir properties file se?? Database Postgres hai
Could you plz explain How to get particularly sepicified columns (or) field without any pass like findbyid or etc ...I just give url in postman when ever I send tha request ..output will be come in json format just specified columns data
I have a doubt If I want to get the data from the database on the basis of foreign key then how can I do so? I mean in where clause I have foreign key, it's not present in my POJO class.
sir native query me..when im writing --- select * from user where name=x after binding x to param ..its not running ...but if i change it to select * from user where name=:x then it ran..... but native query me :x dalke address karna th nhi chahie right ?
How about if I have another entity inside User let’s say department and we want to find User with department name ‘arts’? Consider a one to one mapping between two tables.
thanx for the video . if i want current day data list from database (using date from date-picker) in SpringBoot thyme leaf. please provide me solution.
How to write a hibernate query if we have implemented onetomany or onetoone mapping, suppose on that query we need to transfer some param based on joins tow tables. Thank you so much
After installation mysql workbench , when I am cheking DB show --error 1045 (28000)access denied for user 'root@localhost' (using password :YES) how to resolve this error for windows , can you please help me
I have a table which looks like this Table : id | data 1 | { "name" :"abc","class":"123" } 2 | { "name" :"def","class":"456 } data type of id = varchar data type of data = json i am using native query in jpa like this @Query(value = "select data from Table where id=:id" ,nativeQuery = true) JSONObject findData(@Param("id") String id) My question is the native query going to return me a JSONObject or a jsonObject in stringified form.if it returns me stringified form should i change return type of native query like this String findData(@Param("id") String id)
Hi, I need some help actually I want to write a query like there are more than 50 column and there are status of 1 id as pending , pending authorization and completed . There can be more than one event whose id is 1 and status is pending because when a user approved that event then status will be changed to pending authorization or completed so I want to to retrieve only those events whose status is still only those pending which are not converted into pending authorization or completed . Please give me some idea that how can I do that
Hi, I am writing a query to fetch 2to3 columns from db to jpa but gets error: could not execute query. but it works on inbuilt jpa functions public interface ClientRepo extends JpaRepository{ @Query(value="select Account_Balance, status from client_records", nativeQuery = true) List fetch(); @GetMapping("/prefund") public List fetchPrefundBalance(){ return clientRepo.fetch(); } can u please help
Bhai bahut sahi batha rahe ho...I m very happy aap har 1 video mere liye bahut important hai..thank u so much
very helpful video ,thankyou sir
Thanks for this good and simple explanation
Looking for simple reactive programming in Java
No words to say..thank you is the small word for your efforts. 🙏🙏
Bhai i have a doubt
nice and very well explaination
Thanks sir, appreciate your efforts.
What an amazing explanation bro... Keep it up.. I've searched this topic everywhere in google from last 2 days & now I cleared my all doubts regarding JPQL & native query.. Many any Thanks to you....
Your most welcome bro
Great. Excellent explanation
Nicely explained.
Very very helpful for me
Thanks a lot dear,your exaplanation is amazing .
Best playlist on spring boot till now
Thank you Sirjiii👌🏻👌🏻👌🏻
Clear explanation bhai : Jai Hind : Jai Bharat 🦚
woow very nice thanks
Durgesh Bhai U R Great
Very very thanks sir.
dhanyawad sir ji
bhai bahot acha explain kiya aapnay...
Crisp & Clear
Thanks ☺️👍☺️👍👍
nicely explain
Awesome video
you saved my lots of time. thanks alot bro.
Mere pass ek database hai ussme 20 schemas hai...aur ek table hai jo inn saare schemas mein hai,toh ab @Query mein native query likhta hu mein kch aise @Query(value="select * from schemaname.tablename",nativeQuery=true)
Ab issue yeh hai ki mujhe har schema k liye yeh seperately likhni pad rahi hai...means 20 @Query use karna padh raha hai.....koi aise tareeka hai ki jisse query mein schemaname dynamically de saku...kisi parameter se ya fir properties file se??
Database Postgres hai
Very good content. Really appreciate it.
Please sir make a video how to get data from multiple tables using queries
Awesome Sir ji....Thank thank u so much for making things really very simpler.
Thanks a lot brother
Thanks alot sir!!!
Thank you sir❤
Thank you so much sir.........
11:20
are these operations not case sensitive ??
for a query to work, it should match exact value.
Thanks
Thank you for this series.
Grt vdo sirji
You beauty bro, loved it.
good video
Sir muje doubt h, jo Data pass kar rahe h agar vo table me preset Nhi to usse kese handle karenge plz give some ideas for this.
Use optional
Which is better using prepared statement or jpa ?keeping sql injection in mind
Plez make more video on new projects with angular js
Is it possible to write query in property or yaml file and fetch value from it like @Query(${query})? Please reply
Could you plz explain How to get particularly sepicified columns (or) field without any pass like findbyid or etc ...I just give url in postman when ever I send tha request ..output will be come in json format just specified columns data
Very nice tutorial .. exactly what I want to learn ...cool
@Query ke Bina bhai aisle hi chal rahe the methods; @Query Jodie she kya benefits?!
please sir make a separat playlist for jpql all possible case
sir can you tell me how can we query using multiple tables...using jpql or native
greatttt
I have a doubt
If I want to get the data from the database on the basis of foreign key then how can I do so?
I mean in where clause I have foreign key, it's not present in my POJO class.
sir native query me..when im writing --- select * from user where name=x after binding x to param ..its not running
...but if i change it to select * from user where name=:x then it ran..... but native query me :x dalke address karna th nhi chahie right ?
How about if I have another entity inside User let’s say department and we want to find User with department name ‘arts’? Consider a one to one mapping between two tables.
I want to type the query in angular and send it to Spring so that spring will run the query. Can you please tell me how to do it?
Please explain how to map result of JPQL query to DTO.
**I know how to map native query result to DTO.
Please do provide all these videos in english
Please make one web application using spring boot sir!!
thanx for the video .
if i want current day data list from database (using date from date-picker) in SpringBoot thyme leaf.
please provide me solution.
7:47 D capital
Thumbs up, piya koroh!!!
Good
how do you pass dynamic argument into native query i am trying it but getting value as ? in parameter place holder value
?
Hi , we have a query like below , as we have sql query in database , i need to execute the query using jpa as input , how i need to run .
Those who have learn Spring MVC can relate how easy is this :D
Can you help me i have a doubt
@@harshmanola563 ya sure bro please.
@@shubhamsinghal3326 can you give your mail id
Nice video...One doubt, Suppose my table name is different from the Entity name, then how will i write the @Query?
You can create multiple entities accordingly
Kindly reply coz if one practical not work,we are not able to see next videoes,my save all function is not working.
jpql queries are case sensitive? I have not seen hibernate bt please do help in some cases it dont work it there any standards writing jpql queries
(No property 'city' found for type 'User' )when we use two parameater custom finder method plz give sollution
How to write a hibernate query if we have implemented onetomany or onetoone mapping, suppose on that query we need to transfer some param based on joins tow tables. Thank you so much
Same query we can use join fetch
Can we also fire HQL instead of JPQL, in this case?
Sir I want data of specific column present in database how can i get it.
Please help me.
Where we can learn that querys
can you please explain How to use parenthesis in JPQL for and or conditions
After installation mysql workbench , when I am cheking DB show --error 1045 (28000)access denied for user 'root@localhost' (using password :YES) how to resolve this error for windows , can you please help me
what about parameterized native query
Hayden Shoal
Please sir Spring boot scheduler ka video banadigye
Yr jaldi jaldi video laya kro
I have a table which looks like this
Table :
id | data
1 | { "name" :"abc","class":"123" }
2 | { "name" :"def","class":"456 }
data type of id = varchar data type of data = json
i am using native query in jpa like this
@Query(value =
"select data from Table where id=:id"
,nativeQuery = true)
JSONObject findData(@Param("id") String id)
My question is the native query going to return me a JSONObject or a jsonObject in stringified form.if it returns me stringified form should i change return type of native query like this
String findData(@Param("id") String id)
Sir, format HDD local drive se data recover kiya ja sakta he programing ke dwara
no
Big shoutout Man
Hi Bro, can u make video where if we wanted to have subquery with params , joins then how to do that
Hi,
I need some help actually I want to write a query like there are more than 50 column and there are status of 1 id as pending , pending authorization and completed . There can be more than one event whose id is 1 and status is pending because when a user approved that event then status will be changed to pending authorization or completed so I want to to retrieve only those events whose status is still only those pending which are not converted into pending authorization or completed .
Please give me some idea that how can I do that
How to convert this native query response into json response
i think you can you jasper for that
❤
Hii sir , i got error No qualifying bean of type 'com.jpa.dao.UserRepository' available how to resolve it
brother just re-arrange the file structure for the packages, first com.jpa.test -> com.jpa.test.dao ->com.jpa.test.entities
I am stuck in my spring boot app , json data in not showing up . please help
how can we handle procedures please?
can you make a tutorial on command promt plz?
How to fill all input fields automatically from the database by entering input in one textbox using Spring boot?
6:11 Parameterised Query
title and description in english but talks idian !! very smart
Arey bhai pichle video ki link i button pe dalna kaise vul gaye??
native query not working? giving error while compling
help me out sir i created 2-3 project i got same error
how use ROW_NUMBER() OVER (Order By id DESC) serial
Virgie Summit
Hi,
I am writing a query to fetch 2to3 columns from db to jpa
but gets error: could not execute query. but it works on inbuilt jpa functions
public interface ClientRepo extends JpaRepository{
@Query(value="select Account_Balance, status from client_records", nativeQuery = true)
List fetch();
@GetMapping("/prefund")
public List fetchPrefundBalance(){
return clientRepo.fetch();
}
can u please help
For me also have similar execution requirement. How did u do after that did it work, of yes please share that query
Gideon View
can you please explain operations using UPDATE? BTW the video was excellent Thank you keep it up bhai.
11:07 double quotes
Hql ke liye link dijiye