samedi 9 juillet 2016

How to simulate the "ON UPDATE NO ACTION" in Hibernate

I have the following DO

@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**************/
}

When I am trying to update DeviceMasterDO, it performs an update in InOutTransactionDO and AdminTransactionDO as well. I want to update only DeviceMasterDO. How can I achieve that ?

Issue: If DeviceMasterDO has both InOutTransactionDO and AdminTransactionDO as not null then update works fine and executes -

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

If DeviceMasterDO has either InOutTransactionDO and AdminTransactionDO as null then update fails -

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. 

Aucun commentaire:

Enregistrer un commentaire