Atomikos Forum

I have defined an XA datasource (Oracle), which have 2 set of tables. One for business data and the other for audit logs.

Inside a business action, it will do a lot of updates by steps in the same transaction. If any step failed, it will rollback all business changes.

In the meanwhile, I need another separated transaction in parallel to insert some audit logs into db for each business step, and commit the audit logs once the step is done.

The 2 transaction should not affect each other. To say, errors in business should not affect the audit process, and vice versa.

Anyone know that how can I achieve this?

Thanks.

So the audit log never has rollback? In that case, just configure a second, non-atomikos datasource to use for auditing.

HTH