There are lots of DBs and only one db is changed by operator. The Data in the main DB changed by the operation must be synchronized to other DBs. the changes to the DB is through hibernate2 session. and i want to copy the changes to other DBs like this way.
1. begin to notify hibernate to record SQL
2. operator do the job on the main DB, keep track all the SQL in the job.
3. notify hibernate not to record SQL and save to a SQL file.
4. copy theSQL file to other DBs server.
5. Exec the SQL on the other DBs.
and i wonder if SQL generated by hibernate can be recorded or not. and how.
Thanks in advanced

Maybe http://www.p6spy.org/ is for you.

HTH
Ernst