I have a requirement for replicating any insert/update/delete from a source table to a target table with the same schema - basically the target table is a 'shadow' table.

While this can be achieved using triggers, I want to avoid it so that my code does not have to be aware of the database type in order to generate the trigger creation commands - I believe that there is no generic trigger creation command across different database types.

Is there any mechanism in hibernate that I can use to simulate this behavior? How about the interceptor mechanism - can this be used to simulate insert/update/delete triggers on a table?

Thanks for any pointers.