JPA soft delete with @SqlDelete causes SQL error: Parameter index out of range (2 > number of parameters, which is 1)

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.

Leave a Comment

Your email address will not be published.

Scroll to Top