Error updating database. Cause: java.sql.SQLException: ORA-00001: 违反唯一约束条件

最新推荐文章于 2024-07-30 07:31:42 发布

fengoh

最新推荐文章于 2024-07-30 07:31:42 发布

阅读量1.9w

点赞数

本文链接：https://blog.csdn.net/fengoh/article/details/25361735

版权

org.springframework.dao.DuplicateKeyException:
### Error updating database. Cause: java.sql.SQLException: ORA-00001: 违反唯一约束条件 (TANY_DEP.SYS_C00596888)

### The error may involve com.forlink.tany.entity.dao.TabSalMarketOrderMapper.updateByExampleSelective-Inline
### The error occurred while setting parameters
### SQL: update TAB_SAL_MARKET_ORDER SET DETAIL_ID = ?, TOTAL_QUANTITY = ?, CHECK_TOTAL_QUANTITY = ?, SEND_TOTAL_QUANTITY = ?, RESV_TOTAL_QUANTITY = ?, SALE_TOTAL_QUANTITY = ?, TOTAL_AMOUNT = ?, TOTAL_DISCOUNT = ?, DISCOUNT_AMOUT = ?, RETURN_STATUS = ?, NUM1 = ?, NUM2 = ?, DOMAIN_NO = ? WHERE ( DETAIL_ID = ? )
### Cause: java.sql.SQLException: ORA-00001: 违反唯一约束条件 (TANY_DEP.SYS_C00596888)

解决办法：TabSalMarketOrderDetail model = new TabSalMarketOrderDetail();
TabSalMarketOrderDetailExample example = new TabSalMarketOrderDetailExample();
TabSalMarketOrderDetailExample.Criteria criteria = example.createCriteria();

Long returnQuantity = (long) Integer.parseInt(map.get("returnQuantity").toString());
Long discountPrice = (long) Integer.parseInt(map.get("discountPrice").toString());
String remarks = map.get("remarks").toString();

model.setReturnQuantity(returnQuantity);

model.setDiscountPrice(discountPrice);

model.setRemarks(remarks);

model.setDetailId(detailId);****主键设置是必须***

criteria.andDetailIdEqualTo(detailId);
tabSalMarketOrderDetailMapper.updateByPrimaryKeySelective(model);