We have the following architecture.

a persistence.xml files per business module.

We would like to have a revsion table for each module and not global. (ORDER_DWH_REVISION,CUSTOMER_DWH_REVISION)

All modules/ejbs are packed into one ear file. So the ear file contains multiple jar files that contain

a persistence,xml file per jar file.

What happens if a composite service calls an update on cusomer ejb and

an update on the order ejb. Are the revisions written to each table correctly for the appropriate module.

If the revision listener is a singleton this could be a problem as then only one Listener would be instanciated.

and all revisions for all modules get written to the same table. Remember we have one big ear file for all

services.

Thanls for the help