Hibernate exception while inserting

Question

I have two tables Application, MR. I am using JPA, Hibernate for ORM mapping. I have a problem while inserting the records. Please help me.

* Mr_id in application table is a foreign key

* code in mr table is unique key

* mr_id in MR table is primary key

Application Table:

(id, mr_id)

(1, null)

(2, null)

MR TABLE:

(mr_id, code, name)

(1, code1, mr1)

(2, code2, mr2)

I have a jpa repository :   ApplicationRepository

application = Application(1)

application.mr = MR(1,code1,mr1)

when I run  : applicationRepository.save(applications[0])
it causes a problem

Reason: Mr record with (1,code1,mr1) alredy present in mr table. 

How to solve this problem with JPA, Hibernate annotation

---------------------------------
    Application {
       @Id
       var id: Int;

       @ManyToOne(cascade = [(CascadeType.PERSIST)])
       @JoinColumn(name = "mr_id")
       var mr: MR? = null
    }

Can you please check your Database if it is available or not already? — codeLover
– codeLover, Commented Jun 28, 2018 at 6:24

Anatoly Samoylenko · Accepted Answer · 2018-06-28 06:44:54Z

1

I think this happens because JPA is trying to persist MR (because they detached) after persist Application, but MR with mr_id = 1 already exists. Try to find mr with mr_id = 1 (not create) and set this mr to application.mr

answered Jun 28, 2018 at 6:44

Anatoly Samoylenko

7014 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

Hibernate exception while inserting

Application Table:

MR TABLE:

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Application Table:

MR TABLE:

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related