How to avoid duplicate records when update in DB using hibernate

Question

I am updating the record with multiple entries in the db at a time.when i try to create another multiple records, duplicate entries are saved in DB.how to prevent records from duplicates entry using hibernate.i want to restrict 2 or more column value should not equal as before

@sureshatta for one market id, i m creating 4 entries per month like 1/08/2013 to 31/08/2013.when i select same market id with other dates like 15/08/2013 to 18/09/2013 duplicates entries are allowed from the previous entry — Haseena
– Haseena, Commented Aug 14, 2013 at 9:58
before inserting entries you can check their uniqueness by using Map with the existing entries in dataBase — aizaz
– aizaz, Commented Aug 14, 2013 at 10:05

Adeel Ansari · Accepted Answer · 2013-08-14 09:58:08Z

1

Defining a primary key, or at least a unique constraint, on the table, is the surest way to avoid duplicates. Then your code will throw some useful errors for you to handle transactions properly.

answered Aug 14, 2013 at 9:58

Adeel Ansari

39.9k12 gold badges98 silver badges135 bronze badges

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

Comments

Dmitry Ginzburg · Accepted Answer · 2017-12-07 10:44:19Z

1

Define your entity object with Unique Constraints

    @Entity
    @Table(name="user_group", 
              uniqueConstraints = {@UniqueConstraint(columnNames = {"user_id", "group_id"})})
    public class UserGroup implements Serializable
    {

         User user //This is user model
         Group group // This is Group model 
             // Other fields
             // setter and getter methods.

    }

Save the objects within a transaction

 Session session = sessionFactory().openSession();
 session.beginTransaction();
 session.saveOrUpdate(listOfuserGroup);
 session.getTransaction().commit();

edited Dec 7, 2017 at 10:44

Dmitry Ginzburg

7,4612 gold badges41 silver badges48 bronze badges

answered Aug 14, 2013 at 10:24

Prabhakaran Ramaswamy

26.1k10 gold badges61 silver badges65 bronze badges

1 Comment

Haseena Over a year ago

my primary key ids are unique...data what i am inserting in db is same except id, and marketcode.i tried using uniqueconstraint..but no luck

Collectives™ on Stack Overflow

How to avoid duplicate records when update in DB using hibernate

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related