java - 如何在Hibernate中模拟 "ON UPDATE NO ACTION"

Question

我有以下要做

@Entity
@Table(schema = "USERCVT", name = "Table1")
public class DeviceMasterDO implements Serializable{

@OneToMany(cascade = CascadeType.ALL, mappedBy = "deviceMasterDO", orphanRemoval = true)
private List<InOutTransactionDO> inOutTransactionDOs;

@OneToMany(cascade = CascadeType.ALL, mappedBy = "deviceMasterDO", orphanRemoval = true)
private List<AdminTransactionDO> adminTransactionDOs;
/*************MORE CODE**************/
}

当我尝试更新 DeviceMasterDO 时，它也会在 InOutTransactionDO 和 AdminTransactionDO 中执行更新。我只想更新 DeviceMasterDO。我怎样才能实现这一目标？

问题:如果 DeviceMasterDO 的 InOutTransactionDO 和 AdminTransactionDO 均不为空，则更新工作正常并执行 -

Hibernate: update schema.Table1 set .....
Hibernate: update schema.Table2 set ....
Hibernate: update schema.Table3 set ...

如果 DeviceMasterDO 的 InOutTransactionDO 和 AdminTransactionDO 为空，则更新失败 -

Hibernate: insert into usercvt.Table2 (a,b,c) values (?, ?, ?)
2016-06-14 17:51:44 ERROR SqlExceptionHelper:146 - [SQL0407] Null values not allowed in column or variable b. 

Answer 1

请您考虑删除以下内容:

级联 = CascadeType.ALL

请按如下方式声明inOutTransactionDOs:

@OneToMany(mappedBy = "deviceMasterDO", orphanRemoval = true)
private List<InOutTransactionDO> inOutTransactionDOs;

和adminTransactionDOs如下:

@OneToMany(mappedBy = "deviceMasterDO", orphanRemoval = true)
private List<AdminTransactionDO> adminTransactionDOs;