Hi,

I am using Custom SQL as explained in section 16.3 of hibernate reference. In particular I have set up an <sql-delete>:
<sql-delete>DELETE FROM PERSON WHERE status='EXPIRED'</sql-delete>

I have a number of issues:

1. when I hit delete the custom sql is not being invoked (the normal delete is being called instead). I expected the cutom delete to be called when dlete an object.

2. I would like to disable (overwrite) this cutom SQL in some cases. The reference doesn't explain how this can be done.

I would be very grateful for any clues.

Thanks.

Regards,

Mugoma