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



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);