Hi
in my proxy service (service type= WSDL Web Service), I do for each loop to insert records to SQL SERVER database.
Since I have a demand for response ("Success" or details about the exception), I can't use PUBLISH action, and I must use SERVICE CALLOUT action, to route to another proxy (service type = Any XML Service), and there - I route to the business service, and do the inserting to the DB.
This works fine !!!
But I have another demand - if one of the record is defective I need to do Rollback to all the records that already insert to the DB.
I notice that the second proxy has auto commit after every record, and i think I have to cancel it.
Then, I need to do rollback in the main proxy.
And finally, I need to do commit only when all records are inserted successfully.
How can I do this?
I saw solutions that appropriate to JMS queue (service type = messaging service), but I have a proxy with service type = Any XML Service.
Thanks in advanced,
Elad