Hi,
I've trawled through the forums and can't find a solution to what must be a common problem.
I have 2 clients that each access their own SFSBs. They pass a list of Order objects to the SFSB. For each order, the SFSB makes a call to another SFSB which allocates a transaction id, which it reads, increments and updates in a legacy database table.
I can't seem to find the correct approach.
If I don't have a @Version column, then the same transaction id is allocated more than once, which isn't acceptable.
If I do have a @Version column, then I get various exceptions thrown (OptimisticLockException, StaleObjectStateException, GenericJDBC Exception) none of which seem to allow recovery.
Basically, I want one process to wait for the other to complete. Which I would do outside EJB with a synchronized block, or with pessimistic locking.
Is there an example of how to do this?
Thanks In Advance,
James