java错误映射@OneToMany与JPA和Hibernate的关系
我的数据库中的OneToMany/ManyToOne映射当前有问题。我希望我的销售项目表具有到销售表的@ManyToOne映射
@Entity
@Table(name = "sale")
public class Sale implements Serializable {
private static final long serialVersionUID = -3857608619547245492L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "id")
private Long id;
@Column(name = "company", nullable = false)
private Long company;
@OneToMany(mappedBy = "sale", cascade = CascadeType.ALL, orphanRemoval = true)
private List<SaleItem> saleItems = new ArrayList<>();
public Sale() {
}
public void addSaleItem(SaleItem saleItem) {
saleItems.add(saleItem);
saleItem.setSale(this);
}
//****************************Getters and Setters****************************
}
@Entity
@Table(name = "sale_item")
public class SaleItem implements Serializable {
private static final long serialVersionUID = 1016354254590870341L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "id")
private Long id;
@Column(name = "company", nullable = false)
private Long company;
@Column(name = "description", nullable = false)
private String description;
@Column(name = "amount", nullable = false)
private Double amount;
@Column(name = "price", nullable = false)
private Double price;
@ManyToOne(fetch = FetchType.LAZY)
private Sale sale;
public SaleItem() {
}
//****************************Getters and Setters****************************
public void setSale(Sale sale) {
this.sale = sale;
}
@Override
public boolean equals(Object o) {
if (this == o)
return true;
if (!(o instanceof SaleItem))
return false;
return id != null && id.equals(((SaleItem) o).getId());
}
@Override
public int hashCode() {
return 31;
}
@Override
public String toString() {
return "SaleItem [id=" + id + ", company=" + company + ", product=" + product + ", created=" + created
+ ", updated=" + updated + ", description=" + description + ", amount=" + amount + ", price=" + price
+ ", discount=" + discount + ", user=" + user + ", unit=" + unit + ", sale=" + sale + "]";
}
}
//*********************** My Controller ***********************
/**
* Create Sale
*
* @param sale
* @param result
* @return ResponseEntity<Response<SaleDto>>
* @throws ParseException
*/
@PostMapping
public ResponseEntity<Response<SaleDto>> create(@Valid @RequestBody SaleDto saleDto, BindingResult result)
throws ParseException {
log.info("Creating sale: {}", saleDto.toString());
Response<SaleDto> response = new Response<SaleDto>();
validateSale(saleDto, result);
if (result.hasErrors()) {
log.error("Error - invalid information for Sale: {}", result.getAllErrors());
result.getAllErrors().forEach(error -> response.getErrors().add(error.getDefaultMessage()));
return ResponseEntity.badRequest().body(response);
}
response.setData(this.convertSaleDto(this.nova(saleDto, result)));
return ResponseEntity.ok(response);
}
private Sale nova(SaleDto saleDto, BindingResult result) throws ParseException {
SaleItem saleItem = new SaleItem();
saleItem.setCompany(saleDto.getCompany());
saleItem.setPrice(saleDto.getItems().get(0).getPrice());
saleItem.setDescription(saleDto.getItems().get(0).getDescription());
saleItem.setUnit(saleDto.getItems().get(0).getUnit());
Sale sale = new Sale();
sale.setCompany(saleDto.getCompany());
sale.setUser(saleDto.getUser());
sale.addSaleItem(saleItem);
return this.saleService.persist(sale);
}
//**************************My Service**************
/**
* Persist a sale
*
* @param Sale
* @return Sale
*/
Sale persist(Sale sale);
//******************My impl***********************
@Transactional
public Sale persist(Sale sale) {
log.info("Persisting sale {}", sale);
return this.saleRepository.save(sale);
}
但我认为我做错了什么,因为我收到了关于id null的错误:
SLF4J: Failed toString() invocation on an object of type [com.pissolato.api.entitys.Sale] Reported exception: java.lang.StackOverflowError at java.lang.AbstractStringBuilder.append(Unknown Source) at java.lang.StringBuilder.append(Unknown Source) at java.lang.StringBuilder.<init>(Unknown Source) at com.pissolato.api.entitys.SaleItem.toString(SaleItem.java:189) at java.lang.String.valueOf(Unknown Source) at java.lang.StringBuilder.append(Unknown Source) at java.util.AbstractCollection.toString(Unknown Source) at java.lang.String.valueOf(Unknown Source) 2019-12-27 02:46:40.041 INFO 2684 --- [nio-8080-exec-2] c.p.a.services.implementation.SaleImpl : Persisting sale [FAILED
toString()] Hibernate: /* insert com.pissolato.api.entitys.Sale */ insert into sale (company, created, description, discount, sub_value, type, updated, user, value) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
# 1 楼答案
您在反向端使用mappedby,因此不需要在实体(saleItem)的拥有端连接列。您的“saleItem”实体应该如下所示
下面是我为测试编写的示例服务类
跟踪日志输出
# 2 楼答案
尝试将targetEntity添加到@manytone注释属性
# 3 楼答案
remove nullable=false在执行sql查询时,将不允许具有null值的字段进行更新