Hello all


We are developing a system which includes 10 DBs.

The system will work with hibernate on the main DB. and when swiched to

work alone in each site in case of failover, we will use messaging for

DB replication.

Our problem involves the way in which we will replicate the changes made

in each transaction in the main DB with hibernate:

Should we create a hibernate session above each DB and send him the

objects of hibernate?

Or maybe just before commiting the session, we will extract the sql from

it and message it (more efficient?)?

How can I extract the sqls fom the session?

Thank you. [/u][/code]