Hibernate SaveOrUpdate - multiple workthreads

Question

While I have been able to find information on how Hibernate's transaction work, so the database doesn't corrupted, it has been harder to understand how Hibernate treats an object which is shared between threads, and each thread tries to save it to the database.

This is my theoretical question:

1) I have a Person object with attributes (ssn, name, address). 2) Three threads have a reference to this person object and each thread calls the method savePersonToHibernate(...)

public void savePersonToHibernate(Person person)
{
...
session.saveOrUpdate(person)
...
}

How does Hibernate cope with 3 threads writing the same object to the storage? Does it put all the transactions in a queue so when the first thread creates the row and identifier (set the id) the remaining two thread will only update it with (in this case) no changes? Or will I actually have the chance of having 2 or 3 rows in the database with a current object only referring to the last identifier created?

I hope it makes some kinda sense... I'm making a queue system, and the data needs to be referred to categories which needs to be created on the fly... and if two or more thread get some data which both needs to have the same category created, I'd hate to have duplicated.

I hope this makes sense... what would you do?

Community · Accepted Answer · 2017-05-23 11:50:05Z

4

I'm assuming that all mentioned threads use different sessions otherwise you are in trouble as hibernate session is not thread-safe.

Just to make things clear, if all three threads are using the same instance of person and this is a new object you are in trouble as hibernate doesn't do any synchronization when accessing or modifying object. Basically each thread works as though other threads do not exist, so each will first check if person has non null id and try to generate it if id is null and then will assign it to appropriate entity field. Depending on the timing of check-generate-assign in different threads and visibility effects of changes result of concurrent creation is unpredictable.

Let's see what will happen if all threads are using different instances of person but with the same attributes values. In this case each thread will try to create three different rows in database and if there are no unique constraints on the underlying table (like unique name) it will succeed.

Your particular scenario with category creation is not very straightforward to implement. The idea is to try to create category but catch exception if it is already exists. In the latter case read existing category from database and use it. But keep in mind that implementation of conditional insert is not trivial and may be RDBMS dependent. You may fine slightly more complex but related examples for upsert operation for PostgreSQL and SQL Server.

edited May 23, 2017 at 11:50

CommunityBot

11 silver badge

answered Oct 23, 2013 at 22:33

Roman-Stop RU aggression in UA

16k3 gold badges52 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Peter Goodheart Over a year ago

Thanks for your answer. Since this step is critical, I decided to create a "pre-category-queue" which use one thread to create a category and throw it into a map, reference a category object to the main object and THEN throw it into a real queue, to be picked up by multiple threads. It works great, however it's not completely after the book, but you avoid hits to the database in general.

Collectives™ on Stack Overflow

Hibernate SaveOrUpdate - multiple workthreads

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related