I want to implement a soft delete for my entities. So I create this annoations:
Repository:
When I use the method delete. Hibernate create this SQL:
DELETE
FROM external_reference_our_object
WHERE external_reference_our_object.external_reference_id in
(SELECT e1_0.id
FROM external_reference e1_0
WHERE e1_0.external_system=?
AND e1_0.external_class=?
AND e1_0.external_id=?
AND (external_reference.deleted = 0))];
And I get this Error Message:
SQL Error: 1054, SQLState: 42S22 (conn=43) Unknown column 'external_reference.deleted' in 'where clause'
Because external_reference.deleted should be e1_0.deleted |