Spring Tips: Spring Data JDBC

Hi, Spring fans! In this installment, Josh Long looks at the fantastic Spring Data JDBC project, which is one of the easiest and most powerful ways to leverage JDBC in a Spring Boot application. #postgresql #java #springboot #jdbc #architecture #code #java21

[arnaudpoutieu]

Thanks, Josh. Software solutions design/architecture should always be guided by "Make it Simple" attitude in priority! You rock man

[joachimdietl]

Please Josh do some tutorial about composed primary keys and this embededable thing. I think many devs are looking for it

[zakb.]

Care to see as well how strategies can be implemented with spring batch. For one thing using lazy loading and batch size for the entities in the first level cache seems pretty handy to me..

[vijaydeenanth]

I use hibernate to persists data and use it to read data back where i need to fetch by id to update. Other than that all views are Sql Coded in mybatis. I like the approach that gives me full control on sql when I have multiple joins. I dont get compile time type safety in mybatis, but my tests help to remove any errors that might arise in runtime

[levenchen]

Thanks，Josh. What's is uao command?

[zakb.]

What about Mybatis? We are using it in my current position but I don't know to which extent can we mix both for repositories

[drewenia]

What keyboard are you using? And keyboard switches?

[v.deepak]

I tried to explain this to everyone, nobody paying attention, they are happy with hibernate complexity 😢

[garethbaker]

How would you import this project into a spring-boot project such that spring-boot doesnt demand that the classes in your JdbcApplication have to be defined as Beans?

[antonsiniaiev]

Does data jdbc support composite primary keys and json fields?

[johng.weller]

The Profile field is not embedded inside the Customer object; how is it possible to save both of them with one repository using spring data jdbc?

[mrabbas]

That was good, but why do you always write all the code in one file?

[shashankbajpai]

Can you provide your schema somewhere so that we can easily follow your tutorial?

[essamal-mansouri]

Do you recommend that people use this and not use reactive drivers and all that anymore now that we have loom

[suikast]

21:00 if using chances in java, then do not use the default serilizer of java.

[essamal-mansouri]

You should consider jooq instead of jdbc. You wouldn't be getting "bad sql" errors at runtime like you got and it is also not using reflection, etc. and you are no longer limited to the crud operations that you are limited to here

[javasoccernut]

I'd love to share this Josh but the comments about Hibernate are not accurate.
I've done RDBMS without and with Hibernate for 30 years. I don't want to go back.
That being said, where there are issues is when you have an existing db that is poorly designed.
Recently I had to switch to Spring Data JDBC because of this. But only because Hibernate made some change that seems to cache data types and our db deployments are not consistent and so it would occasionally blow up queries.This is not Hibernate's fault.

[andreiz]

Data JPA should still be the default for most medium to big apps. Using Data JDBC may be premature optimization.

[remek]

All those things that you explained will be in future automatically handled by AI