>I don't know if the changes in the other application are necessary. The main question is - from your application are you able to send all your commands at once as one batch or you need to use separate commands?
>
>If that's the case, how can we guarantee that the transaction would persist and apply to only our commands and not the commands send by other applications? I'm not sure about it.
>
>Using one batch will guarantee that all the commands will execute together.
My application insert one record that have type and value
When I insert this record a report to the other application that I make it.
Then, acording the type and value, the other application have to determine the destination of this data. Can send to the company A, B or C.
The company A, B or C have to stay with equivalent type and value.
If my application have:
- 3 records of type "1" and value R$ 100,00 then
- the company A have 1 record of type "1" and value R$ 100,00
- the company B have 1 record of type "1" and value R$ 100,00
- the company C have 1 record of type "1" and value R$ 100,00
the tree company have equivalent type and value
To determine what company have to receive the data, the other application execute many instructions to consult the last situation and save the new situation - this instructions my application don't know, than I do not can use a batch command.
I just say to the other application: "I inserted one record of the type '1' and value R$ 100,00"
something like
objDefiner.define("1", 100.00)
Then I need
myApplication.beginTransaction()
otherApplication.beginTransaction()
insert into my table...
objDefiner.define("1", 100.00)
if error
myApplication.rollbackTransaction()
otherApplication.rollbackTransaction()
else
myApplication.commitTransaction()
otherApplication.commitTransaction()
endif