Hibernate: Exception when 10 or more users insert a record concurrently

Question

I have an application which works on Spring MVC and Hibernate . It works fine if a single user insert a record, but if multiple user insert records concurrently at same time . It shows this error "Hibernate: org.hibernate.AssertionFailure: null id in".I can observe this is happening because the automatic primary id genaration by hibernate for all record can be similar because of same time. not sure about this.Please help. Need a crucial fix.

The code I use as follow

@Transactional
public Account addAccount(Account acct) {

      session = sessionFactory.getCurrentSession();
      session.save(acct);
      session.flush();
      session.clear();
      return acct;

}

Possible duplicate of [org.hibernate.AssertionFailure: null id in entry (don't flush the Session after an exception occurs)](http://stackoverflow.com/questions/10855542/org-hibernate-assertionfailure-null-id-in-entry-dont-flush-the-session-after) — Dez, Oct 18 '16 at 15:27
That question is completely different, I have read it. Before raising my question — Rajasekar Ramalingam, Oct 18 '16 at 15:38
Why are you calling session.clear(); There is also no need to call session.flush(); — Alan Hay, Oct 18 '16 at 19:35

Daniel Hernández · Accepted Answer · 2016-10-18T15:38:06.283

If you are having concurrency problems consider create this class:

public AccountConcurrencyUtils {

    public static synchronized Account addAccount(Account acct, SessionType session) {
        session = sessionFactory.getCurrentSession();
        session.save(acct);
        session.flush();
        session.clear();
        return acct;
    }

}

Finally in your code:

@Transactional
public Account addAccount(Account acct) {
    return AccountConcurrencyUtils.addAccount(acct, session);
}

This should provent concurrency problems, there should be betters workarounds if you are using Java 7 but this should fix your problem if it is about concurrency, if not, the problem may be other.

I updated the code, put the Session type you are using, this should work even for older Java versions like java 5

Thanks a lot you are genius. will this work on java 8 – Rajasekar Ramalingam Oct 19 '16 at 08:57 — Rajasekar Ramalingam, Oct 19 '16 at 08:57

Hibernate: Exception when 10 or more users insert a record concurrently

1 Answers1