Exploring Spring Boot 3.2 🚀 New JDBC Client | Latest Features Explained !
Vložit
- čas přidán 8. 09. 2024
- #JavaTechie #SpringBoot #NewFeature
👉 In this video, you'll learn:
✅ What's new in Spring boot 3.2 JDBC Client
✅ How to harness the full potential of JDBC Client
✅ Best practices and real-world with CRUD examples
✅ Tips and tricks for efficient Database operation
Spring boot microservice Premium course lunched with 70% off 🚀 🚀
Hurry-up & Register today itself!
COURSE LINK : javatechie5246...
PROMO CODE : JAVATECHIE50
OR use Javatechie APP
Download the JavaTechie app on your iOS or Android device from the App Store or Google Play Store.
Find the links below :
Android 🌐 : play.google.co...
IOS 🌐 : apps.apple.com...
GitHub:
github.com/Jav...
Blogs:
/ javatechie4u
Facebook:
/ javatechie
Join this channel to get access to perks:
www.youtube.co...
🔔 Stay Updated - Subscribe Now and Hit the Bell Icon to receive the latest updates from Java Techie.
Disclaimer/Policy:
--------------------------------
Please note that all content uploaded on this channel is original and not copied from any other source or community. You are welcome to use the source code provided in the GitHub repository mentioned above.
Finally not so different from "mybatis framework"
Great job. Thanks
I liked making complex sql.
Take dto.class for Entity
And without using RowMapping you can immediately get the result complex sql query.
A very effective thing for developing reporting forms and developing microservices.
Thanks, Basant, for your efforts. God bless you. 🙏🙂
Thank you very much for sharing wonderful content
Thanks for a video! Nice an example!
Can you please cover course on Filter, interceptor ,requestbodyAdvise ,responsebodyAdvide. Thanks .😊
Superb bro... new thing i have learnt... thank you...
In spring data JPA we have @Query annotation. In this we can set native true if we want.
Then what is difference between @Query and this new feature?
Basant - any good references to learn DSA and system design for 10 years experience. Most of the companies shortlist candidates based on that. Please suggest 🙏
Waiting for next video of microservices design pattern
Thanks for your great tutorial, But why these sql query, what if you want to do a complex query, can't it be mapped to data JPA queries
Could you please explain debugging concepts pls
Thanks for vídeo, how to do when it's can populate object inside object? for example, client.address.street
How to mock or do junit for JdbcClient
Also please advise in context to NO SQL flavors like mongo it can be used
I need your help regarding configuration of multiple database in spring boot please
Already I have uploaded how to configure multiple datasource please check that video
Do you know if this is sql injection safe? Thank you in advance!!!!
In another hand. How can be implemented a filter via query param? I have always problems with this :( thank you a lot
This is not sql injection safe.
Facing issue, any ide how to do it?
it is taking almost 18 seconds to fetch 1000 records is there any alternate for that.
This is just a demo buddy implement some executor service and validate
can you please share any reference as once i called query with limit 1000 it is taking more than 15 sec but need it below 10 seconds from spring boot application @@Javatechie
Sure i will share some references but before that what database are you using?
@@Javatechie oracle database,and queried using springboot application using jdbc client
does this mean jdbcTemplate is now deprecated ?
No absolutely not . This api is built on top of it
Second comment ❤
It’s a unnecessary repeated feature though
First comment
Second comment
tenth comment@@RishiRajxtrim
Eleventh comment@@sijovinsamalraj3893
Could you show an example of a search on a partial name or title using the LIKE operator with JdbcClient? I have been having some trouble getting that to work. I have done this many times successfully with myBatis or JPA.
Here is a similar code snippet that I was trying but not sure what I have wrong. I was testing it by just passing lowercase a or e, but not getting any results trying to use .params() method. It does work if I append partialLastNameLike to the query instead of using parameters, but that is not ideal.
@Override
public List findByPartialLastName(String partialLastName) {
String partialLastNameLike = "'%" + partialLastName.toLowerCase() + "%'";
return jdbcClient.sql("select * from author where lower(last_name) like :partialLastNameLike")
.param("partialLastNameLike",partialLastNameLike, Types.VARCHAR)
.query(Author.class)
.list();
}
}
throw new IllegalArgumentException("Invalid positional parameter value of type Iterable (" + value.getClass().getSimpleName() + "): Parameter expansion is only supported with named parameters.");
getting this exception if use
jdbcClient.sql("INSERT INTO book(id, name, title) VALUES (?,?,?)")
.param(List.of(book.getId(), book.getName(), book.getTitle()))
.update();
working with:
jdbcClient.sql("INSERT INTO book(id, name, title) VALUES (:id,:name,:title)")
.param("id", book.getId())
.param("name", book.getName())
.param("title", book.getTitle())
.update();
List of will work please check import statement also copy paste my piece of code and check
You have used .param() instead of .params()
it should be .params(List.of(book.getId(), book.getName(), book.getTitle()))
Hope this helps