Dear members,

we want to setup a replication database asynchronously, based on the executed sql statements during a sucessful commit.

First we tried to setup the logging of the sql statements with p6spy. This works fine, but we do not have a relation to the transaction and so all statements are logged.

Is there a possibility in hibernate where we can provide a "listener" where the sql statements (not hql) can be gathered.

Best regards,
Gerold

Hi,
I don't if it would work but maybe you can create an interceptor and check the value passed thorough
You can find more information on how to create an interceptor or how to process events in the documentation:
http://docs.jboss.org/hibernate/orm/4.3/manual/en-US/html/ch14.html

Hope this help,
Davide