This content has been marked as final. Show 2 replies
I would either create a stored procedure on the database and then call it from DBAdapter, or do the logic in BPEL and call different DBAdapters according to the case.
Your logic looks complicated and I don't think you can manage in only one SQL command, that is the idea of DBAdapter.
Why do you want 1 transaction for 3 different tables?
If all 3 tables has no primary/foreign key between them, so actually they can be in separates transactions. Stored procedure is possible depending on your business logic.
If one table has an error do you want to continue with other 2 or cancel all the three?
If it's possible, try to add field in each table so they will be connected by foreign key - that way you will be able to connect between them.