Exploring Spring Boot 3.2 🚀 New JDBC Client | Latest Features Explained !

#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.ongraphy.com/
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.com/store/apps/de...
IOS 🌐 : apps.apple.com/in/app/javatec...
GitHub:
github.com/Java-Techie-jt/jdb...
Blogs:
/ javatechie4u
Facebook:
/ javatechie
Join this channel to get access to perks:
ruclips.net/user/javatechiejoin
🔔 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.

[@javaandothers6460]

Finally not so different from "mybatis framework"

[@radiyziyat7747]

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.

[@vndprasadgrandhi4344]

Thank you very much for sharing wonderful content

[@michalechowicz6903]

Thanks for a video! Nice an example!

[@gopisambasivarao5282]

Thanks, Basant, for your efforts. God bless you. 🙏🙂

[@sayantanghosh8245]

Can you please cover course on Filter, interceptor ,requestbodyAdvise ,responsebodyAdvide. Thanks .😊

[@munnukiranchowdhary]

Superb bro... new thing i have learnt... thank you...

[@bimerinoel4913]

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

[@varaddeshmukh1137]

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?

[@JavaLovers]

Also please advise in context to NO SQL flavors like mongo it can be used

[@vidhanchandra3997]

Waiting for next video of microservices design pattern

[@karthikeyanrm3446]

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 🙏

[@atopazio]

Thanks for vídeo, how to do when it's can populate object inside object? for example, client.address.street

[@jaripatidevendra6172]

Could you please explain debugging concepts pls

[@ricardotrejoruiz5776]

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

[@pankajsarda7010]

This is not sql injection safe.
Facing issue, any ide how to do it?

[@pardeepsaini3844]

I need your help regarding configuration of multiple database in spring boot please

[@Javatechie]

Already I have uploaded how to configure multiple datasource please check that video

[@nagendrad9263]

Second comment ❤

[@hemanth1687]

it is taking almost 18 seconds to fetch 1000 records is there any alternate for that.

[@Javatechie]

This is just a demo buddy implement some executor service and validate

[@hemanth1687]

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

[@Javatechie]

Sure i will share some references but before that what database are you using?

[@hemanth1687]

@@Javatechie oracle database,and queried using springboot application using jdbc client

[@vishalpattnaik1996]

does this mean jdbcTemplate is now deprecated ?

[@Javatechie]

No absolutely not . This api is built on top of it

[@ankitanalawade2528]

It’s a unnecessary repeated feature though

[@JavaLovers]

First comment

[@RishiRajxtrim]

Second comment

[@sijovinsamalraj3893]

tenth comment@@RishiRajxtrim

[@jithendra1282]

Eleventh comment​@@sijovinsamalraj3893

[@PeterSarazin]

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();
}
}

[@hanumanthram6754]

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();

[@Javatechie]

List of will work please check import statement also copy paste my piece of code and check

[@girishanker3796]

You have used .param() instead of .params()
it should be .params(List.of(book.getId(), book.getName(), book.getTitle()))
Hope this helps