I update @SQLDelete
and add and version=?
AT the end of annotation:
@SQLDelete(sql = "UPDATE basket SET deleted=true WHERE id=? and version=?")
@SQLDelete(sql = "UPDATE basket_item SET deleted=true WHERE id=? and version=?")
Note: Also I’ve changed database tables names!
CLICK HERE to find out more related problems solutions.