What is the difference between JDBC Client and Spring Data JDBC?

I was asked by a subscriber on my KZbin channel "What is the difference between the new JDBC Client in Spring Boot 3.2 and Spring Data JDBC"? I thought that was a great question and decided to make a video addressing that question. In this tutorial we explore the various ways we can communicate with a database in Java & Spring.
🔗Resources & Links mentioned in this video:
GitHub Repo: github.com/danvega/jdbc-blog
👋🏻Connect with me:
Website: www.danvega.dev
Twitter: / therealdanvega
Github: github.com/danvega
LinkedIn: / danvega
Newsletter: www.danvega.dev/newsletter
SUBSCRIBE TO MY CHANNEL: bit.ly/2re4GH0 ❤️

[@lifeisbetterwhenyourelax]

Wow, that's badass! I'm maintaining a very large and old Java 8/Spring Framework 3.x application, so I'm still using Spring JDBC Templates. These new ways of handling CRUD feel like the holy grail. The best part is that there's no JPA and Hibernate (I hate the way Hibernate constructs the most sub-optimal queries). I can't wait to port our current app over to Java 21 and Spring Boot 3, so I can focus much more single-mindedly on business logic. Thanks very much, Dan. You have a new subscriber as of 2 days ago.

[@Isranaks]

Started watching ur videos. Its more informative. From Chennai, Tamil Nadu, India

[@3rguy1]

This video is awesome, Dan! Short, concise and clear! I have been using Spring on and off over the last 5 years. It's the first time I have understood the different levels of abstraction that Spring provides over native Java. Keep up the great work. I will definitely be watching more of these videos 😁

[@DanVega]

Wow, thank you so much for the kind words! I'm really glad I am able to help out.

[@FrankGinzo]

Great job, Dan! Miss seeing you teach!

[@DanVega]

I didn't go anywhere, I'm still here :)

[@sarahkelly2481]

Hi, Dan, thanks so much for this video. I happened upon it on FB and the timing couldn't be better. I have a general comment. You are using lots of keyboard shortcuts that I would love to learn (as I use IJ too). It would really be helpful if you used a key stroke display tool. KeyCastr is one example. I don't think it would detract from the main point of your videos, and some of us could learn a lot of additional steps. Thanks for considering this idea.

[@loyyeeko1231]

Hey Dan what a great video, as a person who doesn't like ORM, I would stop at JDBCClient, I found the Repository has lots of magic to it, but you have shown me the ways to do handle SQL between spring and db that's wonderful! thank you!

[@user-br4gt7xu2j]

So what is the difference between Spring Data JDBC and Spring Data JPA in this example?) In what cases the second would be preferable?

[@ilkou]

jpa has more annotations and magic than jdbc, gotta be careful with side effects of every annotation so u don't end up with data lost and unexpected behavior

[@crillin570]

Excellent video Dan, really appreciate it. I was wondering which one of them is volume friendly when dealing with lots of records.

[@FredrikRambris]

All of them. You go about it a little different. You can page the data. Or you can have a cursor that you may have for a long while. Instructing the driver how many rows per fetch and then stream it in. In some situations paginated data is the preferred as it doesn't lock or have open transactions that long, other times you are fine with that. Other times you must be able to abort and continue. When possible I line to just stream the whole resultset but that often requires some configuration to work and not buffer alot in memory.

[@lifeisbetterwhenyourelax]

@@FredrikRambris I think he meant: Which, between of JDBC Template, JDBC Client, and CrudRepository, handles large result sets most efficiently and without issuing sub-optimal queries?

[@marcosgarcia179]

Jdbc client is incredible, is very easy to work

[@kyriakosmandalas2121]

Hello Dan! What about a tutorial with one-to-many relatioship(s) with spring-data-jdbc?

[@saganawski]

Cool breakdown, I've used all of them professionally before

[@DanVega]

Thank you!

[@user-sf8cs3sz2i]

Dan your videos are the best.

[@DanVega]

Thank you so much for the kind words 🤩

[@marcinjozwiak8825]

Hello Dan. Great content as always. I will be appreciate if you could create video about spring boot with kafka. Thank you in advance 😉

[@DanVega]

That would be a lot of fun, thanks for the suggestion.

[@iam_kundan]

Excellent Video !!

[@DanVega]

Thank you very much!

[@JaimeReyCasadoMonokepos]

wonderful video!!! Hwhat font do you use in intellij to recreate the arrow symbol in lambda functions, btw? Thanks a lot!!!

[@DanVega]

I'm using JetBrains Mono which supports Ligatures (that special arrow)

[@petroniobonavides3530]

Yep.. I cleared java professional developer certification, I am clearing Spring Developers certification, after I will specialize myself in Vaadin with Vaadin developer certification

[@RhZ-xd6ts]

Hi Dan! Thank you for the video to introduce the Spring new JDBC Client~ It is really convenient to write some complex SQL to bind with some data object. Do you think we can just use the JDBC Client to replace the Spring Data JPA's "@Query" with SQL? Or further more, do you have some suggestions if we want to use JDBC Client and Spring Data JPA together? I love both of them~

[@lifeisbetterwhenyourelax]

He answered your first question in the video. The answer is 'yes.' You're certainly free to write your own queries by hand, using either JDBC Client or JDBC Template. I'll bet there's a way with CrudRepository, too.

[@Harsh-fd4ml]

Which database you're using for production grade application MySQL or postgresql

[@sagarbhat3884]

Great video as always Dan! I was wondering why would someone want to use JDBC client instead of Spring Data JDBC or Spring Data JPA? When it comes to integration with a database, then aren't the Spring Data projects much more useful than JDBC client?

[@DanVega]

I think If I were just getting started with Spring the JDBC Client would be the easiest way for me to talk to a database. Spring Data is awesome but there is an overhead to learning it. Spring Data JPA is even more of a learning curve if someone doesn't have experience with JPA.

[@drakenra]

What´s the Spring Data JDBC alternative for Spring Data JPA @EntityListeners? I need to encrypt password when persist data to db and decrypt password when fetch data from database.

[@hemanth1687]

Hi, to fetch 1000 records from oracle db it is taking more than 15 seconds. is there any way to fetch data fater from srpingboot application

[@VLADICA94KG]

I am just wondering @6:31 how does the insert works when the ID is defined as varchar but you enter it as integer value = 1?

[@DanVega]

Good question, not sure. I would use the varchar in your code or change the id to an int

[@IbrahimOzis]

Hi Dan, First of all thank you for very helpful sharing. I wonder what would be the solution for jdbcClient if we had multiple databases and schema. Cheers, Ibrahim.

[@FredrikRambris]

That is something I see many struggle with as Spring Boot does not really help much with that. You will have to provide two beans of type DataSource. Each with its own @PropertySource (not sure of that name, writing from memory), then provide two Beans of type JdbcClient, each depending on the respective DataSource. Then you can autowire the two JdbcClients (same for JdbcTemplate and similar for the reactive side).

[@DanVega]

Thanks for the great question. I am going to record a tutorial on this but here is the repository for now. github.com/danvega/multiple-ds

[@IbrahimOzis]

@@FredrikRambris thank you for the answer. I saw these solutions but it requires coding. Maybe it's possible to get that beans by qualifier name.

[@Muescha]

@@DanVega is it the same with spring-boot-data-jdbc?

[@ericwangi6541]

how to use Spring boot 3.2.0 with Spring DATA JPA and MySQL without docker. I tried but there is still a problem.

[@user-ne2gs3th6d]

what is the difference between Spring Data JDBC and Spring Data JPA?

[@This.Object]

Dan, YOU'RE THE BEST

[@DanVega]

Thank you ☺️

[@georgetsiklauri]

Hi, Dan. I think, when you're creating a video tutorial/overview on a topic X, it's better to concentrate on that X. I'm watching this now and thinking, that if a docker-compose, docker, or generally any other unrelated thing isn't really a clear concept for someone, he/she will need to divert from here to some other paths and all this makes it harder and a bit scattered to learn something. Concentration is already a big problem for a modern person, and if it's possible to keep a tutorial focused, it will greatly improve the experience. Respect.

[@kayhan87]

He mentions at the beginning of the video that if someone doesn't want to use a database via Docker, they can also use an H2 database. And by the way, as a "modern" software developer, some experience with Docker can't hurt. It is not particularly difficult to learn, but at the same time offers many advantages.

[@DanVega]

Normally I try and keep things simple but I also try and mention features folks might not know about. I mentioned it early on, if you don't want to use Docker I get it and H2 would be a simple change.

[@georgetsiklauri]

@DanVega mentioning features folks might not know may include a lot of other things, as well, then. Touching upon how Spring Boot works.. how DI is implemented and etc. Anyways, takeaway is that tutorials should better be on a one specific topic and include as minimum of other things as possible. E.g. if H2 is possible, why overload this with mentioning Docker and then referring the audience to go and watch another tutorial(s) on Docker..? :) I'm just trying to help you in having a better content.

[@zoladkow]

imagine that there's a parallel world, where Dan made this video exactly per your suggestion - only mentioning that theres a database, then presenting those different access options. A variant of you from that world would comment "Dan, but how can anyone follow your tutorial if you don't show how to spin up a database. It will greatly improve the experience". Or some yet another variant would comment "This H2 stuff is hard...".🙂 No, it's simply not possible to cater to everyones tastes man. It was actually well executed and concise. I would only argue that DataSource managed by Spring was not pure JDK, but hey-close enough 😁

[@JaBoss397]

why you left VMware

[@static-m-s9835]

VMWare was acuired by Broadcom recently

[@JaBoss397]

Oh okay good to know 😅 glad to see videos from Dan

[@vipinkoul595]

Hi Dan, would you please help in clearing the doubt, why there are so many "spring data" module and when to use which one? Here is the list, and it's getting confusing / ambigous: --> spring-boot-starter-data-jpa --> spring-boot-starter-data-jdbc --> spring-boot-starter-jdbc --> spring-data-jpa --> spring-data-jdbc --> spring-jdbc Could you please help demystify why so many modules are there ?