How to copy the record in hibernate with new primary key?

Question

I want to copy the record of a table into that same table (nothing but saving the new record with previous record values and here the primary key will auto increment) so how to do it in hibernate(is there any direct method like session.save(Obj)) and I am using Hibernate 4.1.12.

Clone and save. Or rather use a custom clone method and save the new object. — Thihara, Sep 18 '14 at 05:11

score 0 · Answer 1 · answered Sep 18 '14 at 04:36

0

You can try making all the primary key columns null and then Session.Save(obj).

answered Sep 18 '14 at 04:36

sacse

3,634
2
15
24

at that time it is giving exception like Hibernate: “identifier of an instance altered from A to B” – Jagadeesh Sep 18 '14 at 05:04
If you have this error, it means the object has not been detached from session and you update the id to null. Try detaching the object first using `evict` method – Joshua H Feb 03 '16 at 10:11

score 0 · Answer 2 · answered Sep 18 '14 at 05:10

0

Let us Consider:

Your table name as 'TestTable' with primary key 'id' (key which needs to be auto incremented).
Your Model Class is 'Test' which has a field 'id' mapped to 'id' column of table 'TestTable'.

You can achieve what you are looking for, using the following approach:

Test  test  = (Test) sessionFactory.getCurrentSession().createCriteria(Test.class).add(Restrictions.eq("id", id)).uniqueResult();
test.setId(null);
sessionFactory.getCurrentSession().saveOrUpdate(test);

answered Sep 18 '14 at 05:10

Janakiraman TK

56
1

here also it will give exception like identifier of an instance of (class name) was altered from actual PrimaryKey to null and i think it will not work using saveOrUpdate(obj). – Jagadeesh Sep 18 '14 at 05:27

Selva · Answer 3 · 2014-09-18T06:06:48.350

0

Try this

Test  test  = (Test) sessionFactory.getCurrentSession().createCriteria(Test.class).add(Restrictions.eq("id", id)).uniqueResult();
Test t=new Test();
t.setName(test.getName());
t.setAge(test.getAge());
sessionFactory.getCurrentSession().save(t);

Or if your table has createddate or modified date fields change that two values and save.

Test  test  = (Test) sessionFactory.getCurrentSession().createCriteria(Test.class).add(Restrictions.eq("id", id)).uniqueResult();
test.setCreatedDate(new Date());
sessionFactory.getCurrentSession().save(test);

edited Sep 18 '14 at 06:06

answered Sep 18 '14 at 05:41

Selva

1,620
3
33
63

It works but,i thought this will be long procedure if our POJO has more properties. – Jagadeesh Sep 18 '14 at 05:53
Can you please give me a example on clone.I am unable to find the example. – Jagadeesh Sep 18 '14 at 07:25
Test t1=test.Clone(); sessionFactory.getCurrentSession.save(t1); – Selva Sep 18 '14 at 08:29
From where this Clone() method will come? – Jagadeesh Sep 23 '14 at 03:22
Test test = (Test) sessionFactory.getCurrentSession().createCriteria(Test.class).add(Restrictions.eq("id", id)).uniqueResult(); Test t=test.clone(); t.setName(test.getName()); t.setAge(test.getAge()); sessionFactory.getCurrentSession().save(t); – Selva Sep 23 '14 at 04:05

score 0 · Answer 4 · answered Feb 28 '18 at 12:41

You can try evicting the previous object before saving the new object.

Test  test  = (Test) sessionFactory.getCurrentSession().createCriteria(Test.class).add(Restrictions.eq("id", id)).uniqueResult();
sessionFactory.getCurrentSession().evict(test);
test.setId(1);
sessionFactory.getCurrentSession().save(test);

How to copy the record in hibernate with new primary key?

4 Answers4