Spring boot application Creating Two Database rows

Question

I have a spring boot application with MySQL database. Below method is creating medication's two rows with same fields.

    @Override
    @Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED)
    public MedicationGroup save(MedicationGroup medicationGroup) {
        return medicationRepository.save(medicationGroup);
    }

Medication Group Entity:

@Getter
@Setter
@Table(name = "medication_group")
@Entity
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class MedicationGroup extends AbstractEntity implements Persistable {

    private static final long serialVersionUID = 2948809916398284974L;

    private Short type;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "patient_id", nullable = false, updatable = false, insertable = false)
    private Patient patient;

    @Column(name = "patient_id")
    private Long patientId;

    @OneToMany(fetch = FetchType.LAZY, mappedBy = "medicationGroup", cascade = CascadeType.ALL)
    private List<Prescription> prescriptions;

}

Below rows are created into database :

Its not happening continually it will happen any time unable to find reason.

Are you sure the method is not called twice? Try logging something or using a debugger to be sure. Or are you trying to update a MedicationGroup object, but your primary key is not set so Hibernate thinks it is a new record? — Wim Deblauwe
– Wim Deblauwe, Commented Nov 14, 2018 at 8:22
please show part of MedicationGroup class where entity annotations and id properties are defined — Alex Salauyou
– Alex Salauyou, Commented Nov 14, 2018 at 8:23
Show how you are calling public MedicationGroup save(MedicationGroup medicationGroup) {}. Which column is your primary key ? — Sudhir Ojha
– Sudhir Ojha, Commented Nov 14, 2018 at 8:31
@Raheela Aslam I do not think this code alone can be a culprit, might be outside of this you are again saving object or playing with non persisted data. — Ankur Singhal
– Ankur Singhal, Commented Nov 14, 2018 at 9:21
I have added the MedicationGroup class. Actually its uncertain not happening everytime i think there is issue of related to Transaction. — Raheela Aslam
– Raheela Aslam, Commented Nov 14, 2018 at 10:21

Genius Kshitiz · Accepted Answer · 2018-11-14 08:39:06Z

1

Are you sure the method is not called twice. Try using primary key in one of the fields, so that duplicate data is not stored in the database.

answered Nov 14, 2018 at 8:39

Genius Kshitiz

666 bronze badges

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

Collectives™ on Stack Overflow

Spring boot application Creating Two Database rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related