Spring Data JPA Implementing Bulk Updates

When using Spring Data JPA, most developers are used to letting Spring handle almost all database operations. That’s especially the case for all update operations. Thanks to JPA’s entity mappings and the managed lifecycle of all entity objects, you only need to change an attribute of an entity object. Everything else happens automatically.

But having a good, automated solution for the most common use cases doesn’t mean it’s the ideal solution for all use cases. JPA’s and Spring Data JPA’s handling of update operations is a good example of that. The default handling is great if you only need to update a few entities. Your persistence provider automatically detects changes to all managed entity objects. For each changed object, it then executes an SQL UPDATE statement. Unfortunately, this is a very inefficient approach if you need to update a huge number of entities. It often causes the execution of several dozen or even hundreds of SQL UPDATE statements.

This is a general problem when using JPA. Still, especially users of Spring Data JPA are surprised when I tell them about this and show them that even a call of the saveAll method on their repository doesn’t avoid these statements.
But there are 2 easy-to-use options to reduce or avoid the performance impact entirely.

Like my channel? Subscribe!

Want to connect with me?

[Ash-kurz]

Your courses are just so structured, I am enjoying them.

[michaelfagundes]

very good, thank you, hugs from Brazil

[Andjoel]

Great video! one question tho, you mentioned is better to create our own update query than activating jdbc batching, why is that? thank you and keep up the good work!

[hangofox]

Good night. I have an Oracle database with a table with 4 Clob-type fields. The CRUD (Read, Modify and Delete) works correctly except for the create shows me the following error when I use Postman. How is the correct syntax in Spring to insert clob type data without showing me the following error:

023-06-13 19:21:15.353 ERROR 6556 --- [nio-8084-exec-1] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is could not extract ResultSet; SQL [n/a]; nested exception is could not extract ResultSet] with root cause

ORA-00932: tipos de dato inconsistentes: se esperaba - se ha obtenido CLOB

[stefanolazzari]

Why cant just i like it twice?? Thanks a lot

[shiwendrasingh]

How to reduce the timing of a find jpa query for entities having joins ?

[asashish]

So can I implement this batching when a saveAll() is used to insert a large number of entities and it leads to broken pipe error during inserting in postgres DB?

[petroniobonavides]

Wonderful, I was needing this exactly lecture fro my project. But... Why dont you talk about Mongo?