Question

hibernate删除子表失败update t_order_consumption set order_code=null where order_code=?关键是这句话

Hibernate: update t_order_consumption set order_code=null where order_code=?
2015-1-4 9:52:43 org.hibernate.util.JDBCExceptionReporter logExceptions
警告: SQL Error: 1407, SQLState: 72000
2015-1-4 9:52:43 org.hibernate.util.JDBCExceptionReporter logExceptions
严重: ORA-01407: 无法更新 ("HAIYUN"."T_ORDER_CONSUMPTION"."ORDER_CODE") 为 NULL
2015-1-4 9:52:43 org.hibernate.util.JDBCExceptionReporter logExceptions
警告: SQL Error: 1407, SQLState: 72000
2015-1-4 9:52:43 org.hibernate.util.JDBCExceptionReporter logExceptions
严重: ORA-01407: 无法更新 ("HAIYUN"."T_ORDER_CONSUMPTION"."ORDER_CODE") 为 NULL
2015-1-4 9:52:43 org.hibernate.event.def.AbstractFlushingEventListener performExecutions
严重: Could not synchronize database state with session
org.hibernate.QueryTimeoutException: Could not execute JDBC batch update
下面是我的实体类配置
主表：
Order
private String code;
private List<OrderConsumption> orderConsumptions;
@OneToMany(cascade={CascadeType.ALL},fetch=FetchType.LAZY)
@JoinColumns(value={@JoinColumn(name="orderCode",referencedColumnName="code")})
@OrderBy("id")
public List<OrderConsumption> getOrderConsumptions() {
return orderConsumptions;
}
public void setOrderConsumptions(List<OrderConsumption> orderConsumptions) {
this.orderConsumptions = orderConsumptions;
}
子表：
OrderConsumption
private String orderCode;

Answer 1

传了一个 空值进去，orderCode 不允许为空

追问

我知道他传空进去了！关键是这个不是我写的啊！是系统自动编写的！要怎么解决啊！

追答

在对象里面set值进去不就好了

追问

已经解决了！主要是子表的order_code设置了非空！Hibernate: update t_order_consumption set order_code=null
这句话就会报错！