Spring boot application Creating Two Database rows










1















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 :




enter image description here



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










share|improve this question
























  • 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
    Nov 14 '18 at 8:22












  • please show part of MedicationGroup class where entity annotations and id properties are defined

    – Alex Salauyou
    Nov 14 '18 at 8:23











  • Show how you are calling public MedicationGroup save(MedicationGroup medicationGroup) . Which column is your primary key ?

    – Sudhir Ojha
    Nov 14 '18 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
    Nov 14 '18 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
    Nov 14 '18 at 10:21















1















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 :




enter image description here



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










share|improve this question
























  • 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
    Nov 14 '18 at 8:22












  • please show part of MedicationGroup class where entity annotations and id properties are defined

    – Alex Salauyou
    Nov 14 '18 at 8:23











  • Show how you are calling public MedicationGroup save(MedicationGroup medicationGroup) . Which column is your primary key ?

    – Sudhir Ojha
    Nov 14 '18 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
    Nov 14 '18 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
    Nov 14 '18 at 10:21













1












1








1








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 :




enter image description here



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










share|improve this 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 :




enter image description here



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







java hibernate spring-boot spring-data-jpa






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 14 '18 at 10:13







Raheela Aslam

















asked Nov 14 '18 at 8:18









Raheela AslamRaheela Aslam

36211




36211












  • 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
    Nov 14 '18 at 8:22












  • please show part of MedicationGroup class where entity annotations and id properties are defined

    – Alex Salauyou
    Nov 14 '18 at 8:23











  • Show how you are calling public MedicationGroup save(MedicationGroup medicationGroup) . Which column is your primary key ?

    – Sudhir Ojha
    Nov 14 '18 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
    Nov 14 '18 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
    Nov 14 '18 at 10:21

















  • 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
    Nov 14 '18 at 8:22












  • please show part of MedicationGroup class where entity annotations and id properties are defined

    – Alex Salauyou
    Nov 14 '18 at 8:23











  • Show how you are calling public MedicationGroup save(MedicationGroup medicationGroup) . Which column is your primary key ?

    – Sudhir Ojha
    Nov 14 '18 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
    Nov 14 '18 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
    Nov 14 '18 at 10:21
















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
Nov 14 '18 at 8:22






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
Nov 14 '18 at 8:22














please show part of MedicationGroup class where entity annotations and id properties are defined

– Alex Salauyou
Nov 14 '18 at 8:23





please show part of MedicationGroup class where entity annotations and id properties are defined

– Alex Salauyou
Nov 14 '18 at 8:23













Show how you are calling public MedicationGroup save(MedicationGroup medicationGroup) . Which column is your primary key ?

– Sudhir Ojha
Nov 14 '18 at 8:31






Show how you are calling public MedicationGroup save(MedicationGroup medicationGroup) . Which column is your primary key ?

– Sudhir Ojha
Nov 14 '18 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
Nov 14 '18 at 9:21





@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
Nov 14 '18 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
Nov 14 '18 at 10:21





I have added the MedicationGroup class. Actually its uncertain not happening everytime i think there is issue of related to Transaction.

– Raheela Aslam
Nov 14 '18 at 10:21












1 Answer
1






active

oldest

votes


















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.






share|improve this answer






















    Your Answer






    StackExchange.ifUsing("editor", function ()
    StackExchange.using("externalEditor", function ()
    StackExchange.using("snippets", function ()
    StackExchange.snippets.init();
    );
    );
    , "code-snippets");

    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "1"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader:
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    ,
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );













    draft saved

    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53295688%2fspring-boot-application-creating-two-database-rows%23new-answer', 'question_page');

    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    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.






    share|improve this answer



























      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.






      share|improve this answer

























        1












        1








        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.






        share|improve this answer













        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.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 14 '18 at 8:39









        Genius KshitizGenius Kshitiz

        365




        365





























            draft saved

            draft discarded
















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53295688%2fspring-boot-application-creating-two-database-rows%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            How to how show current date and time by default on contact form 7 in WordPress without taking input from user in datetimepicker

            Syphilis

            Darth Vader #20