如何避免从JPA实体保存截断的数据

huangapple
go评论112阅读模式
英文:

How to avoid saving truncated data from JPA entity

问题

I am trying to save a bunch of data from two different entities named auditor_stamp_duty_report and deed_of_assignment. These 2 entities share a one to one and join table relationship. When I try to persist data from postman using the post method, only data from one entity gets saved into the database. The data for the other entity gets truncated.

Here is my entity classes;

  1. import com.fasterxml.jackson.annotation.JsonIgnore;
  2. import lombok.Data;
  4. import javax.persistence.*;
  5. import java.io.Serializable;
  6. import java.time.LocalDate;
  8. @Data
  9. @Entity
  10. @Table(name="auditor_stamp_duty_report")
  11. public class AuditorStampDutyReport implements Serializable {
  13.     @Id
  14.     @GeneratedValue(strategy = GenerationType.IDENTITY)
  15.     @Column(name = "id")
  16.     private Long id;
  18.     @JsonIgnore
  19.     @ManyToOne
  20.     @JoinColumn(name = "id_of_tax_payer_organization", referencedColumnName = "id")
  21.     private Organization organization;
  23.     @Column(name = "tin_of_tax_payer_organization")
  24.     private Long tin_of_tax_payer_organization;
  26.     @Column(name = "period_covered")
  27.     private String period_covered;
  29.     @Column(name = "date_of_transaction")
  30.     private LocalDate date_of_transaction;
  32.     @JoinColumn(name = "duty_payer")
  33.     private String duty_payer;
  35.     @Column(name = "tin_of_duty_payer")
  36.     private Long tin_of_duty_payer;
  38.     @Column(name = "address_of_duty_payer")
  39.     private String address_of_duty_payer;
  41.     @JsonIgnore
  42.     @ManyToOne
  43.     @JoinColumn(name = "instrument_id", referencedColumnName = "id")
  44.     private Instruments instruments;
  46.     @Column(name = "assessment_number")
  47.     private Long assessment_number;
  49.     @Column(name = "receipt_number")
  50.     private String receipt_number;
  52.     @Column(name = "consideration")
  53.     private Double consideration;
  55.     @Column(name = "rate")
  56.     private Double rate;
  58.     @Column(name = "amount_payable")
  59.     private Double amount_payable;
  61.     @Column(name = "amount_paid")
  62.     private Double amount_paid;
  64.     @Column(name = "balance")
  65.     private Double balance;
  67.     @Column(name = "penalty")
  68.     private Double penalty;
  70.     @Column(name = "outstanding")
  71.     private Double outstanding;
  73.     @Column(name = "remarks")
  74.     private String remarks;
  76.     @Column(name="amount_recoverable")
  77.     private Double amount_recoverable;
  79.     @Column(name="date_of_payment")
  80.     private LocalDate date_of_payment;
  82.     @JsonIgnore
  83.     @ManyToOne
  84.     @JoinColumn(name = "user_profile_id", referencedColumnName = "id")
  85.     private UserProfile userProfile;
  87.         @OneToOne
  88.         @JoinTable(
  89.                 name="auditor_stamp_duty_report_deed_of_assignment",
  90.                 joinColumns = @JoinColumn(name="auditor_stamp_duty_report_id", referencedColumnName = "id"),
  91.                 inverseJoinColumns = @JoinColumn(name="deed_of_assignment_id", referencedColumnName = "id")
  92.         )
  93.         private DeedOfAssignment deed_of_assignment_id;
  95. }
  97. //second entity
  99. package com.oasis.firsbacklogbackend.entity;
  101. import lombok.Data;
  102. import javax.persistence.*;
  103. import java.io.Serializable;
  104. import java.util.List;
  106. @Data
  107. @Entity
  108. @Table(name = "deed_of_assignment")
  109. public class DeedOfAssignment implements Serializable {
  111.     @Id
  112.     @GeneratedValue(strategy = GenerationType.IDENTITY)
  113.     @Column(name="id")
  114.     private Long id;
  116.     @ManyToOne
  117.     @JoinColumn(name="state_id", referencedColumnName="id")
  118.     private State state;
  120.     @ManyToOne
  121.     @JoinColumn(name="lga_id", referencedColumnName = "id")
  122.     private Lga lga;
  124.     @Column(name="ward")
  125.     private Long ward;
  127.     @Column(name="description_of_location")
  128.     private String description_of_location;
  129. }

also look at my dto layer which I am using to transfer data for both entities below:

  1. import lombok.Data;
  2. import java.time.LocalDate;
  4. @Data
  5. public class AuditorStampDutyReportDto {
  7.     private Long id;
  9.     private Long id_of_tax_payer_organization;
  11.     private String duty_payer;
  13.     private Long tin_of_tax_payer_organization;
  15.     private String period_covered;
  17.     private LocalDate date_of_transaction;
  19.     private Long tin_of_duty_payer;
  21.     private String address_of_duty_payer;
  23.     private Long instrument_id;
  25.     private Long assessment_number;
  27.     private String receipt_number;
  29.     private Double consideration;
  31.     private Double rate;
  33.     private Double amount_payable;
  35.     private Double amount_paid;
  37.     private Double balance;
  39.     private Double penalty;
  41.     private LocalDate date_of_payment;
  43.     private Double amount_recoverable;
  45.     private Double outstanding;
  47.     private String remarks;
  49.     private Long user_profile_id;
  51.     private Long deed_of_assignment_id;
  53.     private Long state_id;
  55.     private Long lga_id;
  57.     private Long ward;
  59.     private String description_of_location;
  60. }

here is the service

  1. @Data
  2. @Service
  3. public class AuditorStampDutyReportService {
  5.     private Logger logger = Logger.getLogger(AuditorStampDutyReportService.class.getName());
  7.     @Autowired
  8.     private BanksRepository banksRepository;
  10.     @Autowired
  11.     private AuditorStampDutyReportRepository auditorStampDutyReportRepository;
  13.     @Autowired
  14.     private OrganizationRepository organizationRepository;
  16.     @Autowired
  17.     private LgaRepository lgaRepository;
  19.     @Autowired
  20.     private StateRepository stateRepository;
  22.     @Autowired
  23.     private InstrumentsRepository instrumentsRepository;
  25.     @Autowired
  26.     private DeedOfAssignmentRepository deedOfAssignmentRepository;
  28.     @Autowired
  29.     private UserProfileRepository userProfileRepository;
  31.     public AuditorStampDutyReport dtoToEntity (AuditorStampDutyReportDto dto){
  32.         AuditorStampDutyReport report = new AuditorStampDutyReport();
  34.         report.setId(dto.getId());
  35.         Organization organization = organizationRepository.findById(dto.getId_of_tax_payer_organization()).orElse(null);
  36.         report.setOrganization(organization);
  38.         report.setTin_of_tax_payer_organization(dto.getTin_of_tax_payer_organization());
  39.         report.setDate_of_transaction(dto.getDate_of_transaction());
  40.         report.setPeriod_covered(dto.getPeriod_covered());
  42.         report.setDuty_payer(dto.getDuty_payer());
  43.         report.setTin_of_duty_payer(dto.getTin_of_duty_payer());
  44.         report.setAddress_of_duty_payer(dto.getAddress_of_duty_payer());
  46.         Instruments instruments = instrumentsRepository.findById(dto.getInstrument_id()).orElse(null);
  47.         report.setInstruments(instruments);
  49.         report.setAssessment_number(dto.getAssessment_number());
  50.         report.setReceipt_number(dto.getReceipt_number());
  51.         report.setConsideration(dto.getConsideration());
  52.         report.setRate(dto.getRate());
  53.         report.setAmount_payable(dto.getAmount_payable());
  54.         report.setAmount_paid(dto.getAmount_paid());
  55.         report.setBalance(dto.getBalance());
  56.         report.setPenalty(dto.getPenalty());
  57.         report.setDate_of_payment(dto.getDate_of_payment());
  58.         report.setAmount_recoverable(dto.getAmount_recoverable());
  59.         report.setOutstanding(dto.getOutstanding());
  60.         report.setRemarks(dto.getRemarks());
  62.         UserProfile userProfile = userProfileRepository.findById(dto.getUser_profile_id()).orElse(null);
  63.         report.setUserProfile(userProfile);
  65.         if(dto.getDeed_of_assignment_id()!=null && dto.getDeed_of_assignment_id() > 0) {
  66.             DeedOfAssignment deedOfAssignment = deedOfAssignmentRepository.findById(dto.getDeed_of_assignment_id()).orElse(null);
  67.             if (deedOfAssignment != null) {
  68.                 report.setDeed_of_assignment_id(deedOf
  70. <details>
  71. <summary>英文:</summary>
  73. I am trying to save a bunch of data from two different entities named auditor_stamp_duty_report and deed_of assignment. These 2 entities share a one to one and join table relationship. When I try to persist data from postman using the post method, only data from one entity gets saved into the database. The data for the other entity gets truncated.
  76. Here is my entity classes;

import com.fasterxml.jackson.annotation.JsonIgnore;
import lombok.Data;

import javax.persistence.*;
import java.io.Serializable;
import java.time.LocalDate;

@Data
@Entity
@Table(name="auditor_stamp_duty_report")
public class AuditorStampDutyReport implements Serializable {

  1. @Id
  2. @GeneratedValue(strategy = GenerationType.IDENTITY)
  3. @Column(name = &quot;id&quot;)
  4. private Long id;
  5. @JsonIgnore
  6. @ManyToOne
  7. @JoinColumn(name = &quot;id_of_tax_payer_organization&quot;, referencedColumnName = &quot;id&quot;)
  8. private Organization organization;
  9. @Column(name = &quot;tin_of_tax_payer_organization&quot;)
  10. private Long tin_of_tax_payer_organization;
  11. @Column(name = &quot;period_covered&quot;)
  12. private String period_covered;
  13. @Column(name = &quot;date_of_transaction&quot;)
  14. private LocalDate date_of_transaction;
  15. @JoinColumn(name = &quot;duty_payer&quot;)
  16. private String duty_payer;
  17. @Column(name = &quot;tin_of_duty_payer&quot;)
  18. private Long tin_of_duty_payer;
  19. @Column(name = &quot;address_of_duty_payer&quot;)
  20. private String address_of_duty_payer;
  21. @JsonIgnore
  22. @ManyToOne
  23. @JoinColumn(name = &quot;instrument_id&quot;, referencedColumnName = &quot;id&quot;)
  24. private Instruments instruments;
  25. @Column(name = &quot;assessment_number&quot;)
  26. private Long assessment_number;
  27. @Column(name = &quot;receipt_number&quot;)
  28. private String receipt_number;
  29. @Column(name = &quot;consideration&quot;)
  30. private Double consideration;
  31. @Column(name = &quot;rate&quot;)
  32. private Double rate;
  33. @Column(name = &quot;amount_payable&quot;)
  34. private Double amount_payable;
  35. @Column(name = &quot;amount_paid&quot;)
  36. private Double amount_paid;
  37. @Column(name = &quot;balance&quot;)
  38. private Double balance;
  39. @Column(name = &quot;penalty&quot;)
  40. private Double penalty;
  41. @Column(name = &quot;outstanding&quot;)
  42. private Double outstanding;
  43. @Column(name = &quot;remarks&quot;)
  44. private String remarks;
  45. @Column(name=&quot;amount_recoverable&quot;)
  46. private Double amount_recoverable;
  47. @Column(name=&quot;date_of_payment&quot;)
  48. private LocalDate date_of_payment;
  49. @JsonIgnore
  50. @ManyToOne
  51. @JoinColumn(name = &quot;user_profile_id&quot;, referencedColumnName = &quot;id&quot;)
  52. private UserProfile userProfile;
  53. @OneToOne
  54. @JoinTable(
  55. name=&quot;auditor_stamp_duty_report_deed_of_assignment&quot;,
  56. joinColumns = @JoinColumn(name=&quot;auditor_stamp_duty_report_id&quot;, referencedColumnName = &quot;id&quot;),
  57. inverseJoinColumns = @JoinColumn(name=&quot;deed_of_assignment_id&quot;, referencedColumnName = &quot;id&quot;)
  58. )
  59. private DeedOfAssignment deed_of_assignment_id;

}

//second entity

package com.oasis.firsbacklogbackend.entity;

import lombok.Data;
import javax.persistence.*;
import java.io.Serializable;
import java.util.List;

@Data
@Entity
@Table(name = "deed_of_assignment")
public class DeedOfAssignment implements Serializable {

  1. @Id
  2. @GeneratedValue(strategy = GenerationType.IDENTITY)
  3. @Column(name=&quot;id&quot;)
  4. private Long id;
  5. @ManyToOne
  6. @JoinColumn(name=&quot;state_id&quot;, referencedColumnName=&quot;id&quot;)
  7. private State state;
  8. @ManyToOne
  9. @JoinColumn(name=&quot;lga_id&quot;, referencedColumnName = &quot;id&quot;)
  10. private Lga lga;
  11. @Column(name=&quot;ward&quot;)
  12. private Long ward;
  13. @Column(name=&quot;description_of_location&quot;)
  14. private String description_of_location;

}

  2. also look at my dto layer which I am using to transfer data for bith entities below:

import lombok.Data;
import java.time.LocalDate;

@Data
public class AuditorStampDutyReportDto {

  1. private  Long id;
  2. private Long id_of_tax_payer_organization;
  3. private String duty_payer;
  4. private Long tin_of_tax_payer_organization;
  5. private String period_covered;
  6. private LocalDate date_of_transaction;
  7. private Long tin_of_duty_payer;
  8. private String address_of_duty_payer;
  9. private Long instrument_id;
  10. private Long assessment_number;
  11. private String receipt_number;
  12. private Double consideration;
  13. private Double rate;
  14. private Double amount_payable;
  15. private Double amount_paid;
  16. private Double balance;
  17. private Double penalty;
  18. private LocalDate date_of_payment;
  19. private Double amount_recoverable;
  20. private Double outstanding;
  21. private String remarks;
  22. private Long user_profile_id;
  23. private Long deed_of_assignment_id;
  24. private Long state_id;
  25. private Long lga_id;
  26. private Long ward;
  27. private String description_of_location;

}

  2. here is the service

@Data
@Service
public class AuditorStampDutyReportService {

  1. private Logger logger = Logger.getLogger(AuditorStampDutyReportService.class.getName());
  2. @Autowired
  3. private BanksRepository banksRepository;
  4. @Autowired
  5. private AuditorStampDutyReportRepository auditorStampDutyReportRepository;
  6. @Autowired
  7. private OrganizationRepository organizationRepository;
  8. @Autowired
  9. private LgaRepository lgaRepository;
  10. @Autowired
  11. private StateRepository stateRepository;
  12. @Autowired
  13. private InstrumentsRepository instrumentsRepository;
  14. @Autowired
  15. private DeedOfAssignmentRepository deedOfAssignmentRepository;
  16. @Autowired
  17. private UserProfileRepository userProfileRepository;
  18. public AuditorStampDutyReport dtoToEntity (AuditorStampDutyReportDto dto){
  19. AuditorStampDutyReport report = new AuditorStampDutyReport();
  20. report.setId(dto.getId());
  21. Organization organization = organizationRepository.findById(dto.getId_of_tax_payer_organization()).orElse(null);
  22. report.setOrganization(organization);
  23. report.setTin_of_tax_payer_organization(dto.getTin_of_tax_payer_organization());
  24. report.setDate_of_transaction(dto.getDate_of_transaction());
  25. report.setPeriod_covered(dto.getPeriod_covered());
  26. report.setDuty_payer(dto.getDuty_payer());
  27. report.setTin_of_duty_payer(dto.getTin_of_duty_payer());
  28. report.setAddress_of_duty_payer(dto.getAddress_of_duty_payer());
  29. Instruments instruments = instrumentsRepository.findById(dto.getInstrument_id()).orElse(null);
  30. report.setInstruments(instruments);
  31. report.setAssessment_number(dto.getAssessment_number());
  32. report.setReceipt_number(dto.getReceipt_number());
  33. report.setConsideration(dto.getConsideration());
  34. report.setRate(dto.getRate());
  35. report.setAmount_payable(dto.getAmount_payable());
  36. report.setAmount_paid(dto.getAmount_paid());
  37. report.setBalance(dto.getBalance());
  38. report.setPenalty(dto.getPenalty());
  39. report.setDate_of_payment(dto.getDate_of_payment());
  40. report.setAmount_recoverable(dto.getAmount_recoverable());
  41. report.setOutstanding(dto.getOutstanding());
  42. report.setRemarks(dto.getRemarks());
  43. UserProfile userProfile = userProfileRepository.findById(dto.getUser_profile_id()).orElse(null);
  44. report.setUserProfile(userProfile);
  45. //why is deed of assignment is not getting saved into database?

// DeedOfAssignment deedOfAssignment= null;
if(dto.getDeed_of_assignment_id()!=null && dto.getDeed_of_assignment_id() > 0) {
DeedOfAssignment deedOfAssignment = deedOfAssignmentRepository.findById(dto.getDeed_of_assignment_id()).orElse(null);
if (deedOfAssignment != null) {
report.setDeed_of_assignment_id(deedOfAssignment);
State state = stateRepository.findById(dto.getState_id()).orElse(null);
deedOfAssignment.setState(state);
Lga lga = lgaRepository.findById(dto.getLga_id()).orElse(null);
deedOfAssignment.setLga(lga);
deedOfAssignment.setWard(dto.getWard());
deedOfAssignment.setDescription_of_location(dto.getDescription_of_location());
}
}
report= auditorStampDutyReportRepository.save(report);
return report;
}

  2. data truncation

{
//gets into the auditor_stamp_duty-report table successfully
"id_of_tax_payer_organization": 1,
"id_of_duty_payer_or_bank": 29,
"tin_of_tax_payer_organization": 3329644,
"period_covered": "July 2017 to May 2010",
"date_of_transaction": "2020-11-29",
"tin_of_duty_payer_or_bank": 382890,
"address_of_duty_payer_or_bank": "15, IBB close, Aso Drive, Fct, Abuja",
"instrument_id": 13,
"assessment_number": 219,
"receipt_number": "cc92384",
"consideration": 19470.0,
"rate": 16.0,
"amount_payable": 22000,
"amount_paid": 280000,
"balance": 2999000.0,
"penalty": 398290.0,
"outstanding": 7800.0,
"remarks": "Are no longer in operation.",
"user_profile_id": 1,

//does not get into the deed_of_assignment table successfully

  1.     &quot;deed_of_assignment_id&quot;: 6,
  2. &quot;state_id&quot;: 20,
  3. &quot;lga_id&quot;: 230,
  4. &quot;ward&quot;: 12,
  5. &quot;description_of_location&quot;: &quot;A brown bungalow&quot;
  6. }
  2. I would appreciate your help
  3. </details>
  4. # 答案1
  5. **得分**: 1
  6. 我通过按照项目要求修改了我的服务层逻辑，成功解决了问题。以下是我的服务部分的代码片段：
  7. ```java
  8. if (instruments != null && instruments.getName().equalsIgnoreCase("Deed of Assignment")) {
  9. DeedOfAssignment deedOfAssignment = new DeedOfAssignment();
  10. report.setDeedOfAssignmentId(deedOfAssignment);
  11. State state = stateRepository.findById(dto.getStateId()).orElse(null);
  12. deedOfAssignment.setState(state);
  13. if (state != null) {
  14. Lga lga = lgaRepository.findById(dto.getLgaId()).orElse(null);
  15. deedOfAssignment.setLga(lga);
  16. }
  17. deedOfAssignment.setWard(dto.getWard());
  18. deedOfAssignment.setDescriptionOfLocation(dto.getDescriptionOfLocation());
  19. }

我还在我的一对一实体映射中添加了(cascade=CascadeType.ALL)，就像这样：

  1. @OneToOne(cascade = CascadeType.ALL)
  2.     @JoinTable(
  3.             name="auditor_stamp_duty_report_deed_of_assignment",
  4.             joinColumns = @JoinColumn(name="auditor_stamp_duty_report_id", referencedColumnName = "id"),
  5.             inverseJoinColumns = @JoinColumn(name="deed_of_assignment_id", referencedColumnName = "id")
  6.     )
  7.     private DeedOfAssignment deedOfAssignmentId;

这样做后，成功地将持久化数据保存到两个表/实体中，并且得到了所需的结果，而且不会截断数据。

英文:

I was able to fix it by modifying the logic of my service layer in line with the requirements of my project. Here is the code snippet for my service below:

  1.         if (instruments != null &amp;&amp; instruments.getName().equalsIgnoreCase(&quot;Deed of Assignment&quot;)) {
  2. DeedOfAssignment deedOfAssignment = new DeedOfAssignment();
  3. report.setDeedOfAssignmentId(deedOfAssignment);
  4. State state = stateRepository.findById(dto.getStateId()).orElse(null);
  5. deedOfAssignment.setState(state);
  6. if (state != null) {
  7. Lga lga = lgaRepository.findById(dto.getLgaId()).orElse(null);
  8. deedOfAssignment.setLga(lga);
  9. }
  10. deedOfAssignment.setWard(dto.getWard());
  11. deedOfAssignment.setDescriptionOfLocation(dto.getDescriptionOfLocation());
  12. }

I also added (cascade=CascadeType.ALL) to my oneToOne entity mapping like this:

  1. @OneToOne(cascade = CascadeType.ALL)
  2. @JoinTable(
  3. name=&quot;auditor_stamp_duty_report_deed_of_assignment&quot;,
  4. joinColumns = @JoinColumn(name=&quot;auditor_stamp_duty_report_id&quot;, referencedColumnName = &quot;id&quot;),
  5. inverseJoinColumns = @JoinColumn(name=&quot;deed_of_assignment_id&quot;, referencedColumnName = &quot;id&quot;)
  6. )
  7. private DeedOfAssignment deedOfAssignmentId;

and it worked, saving the persisted data into the two tables/entities and producing the desired result without truncating the data.

huangapple
  • 本文由 发表于 2020年8月25日 07:21:56
  • 转载请务必保留本文链接：https://go.coder-hub.com/63569932.html
  • hibernate
  • java
  • json
  • spring-data-jpa
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定