I’m using an adapter service (jdbc in autocommit mode) and I would have a question :
I’m calling a first stored proc adapter which calls an “Insert returning” clause coded in Oracle PL/SQL.
When I test my service my new ID is well returned.
This adapter is called from a main service flow SF1.
Now I have to make an update of the last inserted row in my table (clause “where” using the later Id returned).
So I’ve created a 2nd service adapter based on UpdateSql.
Does this update adapter need to be executed from another service flow, or it can be called from SF1?
I suspect the 2 adapters can’t be called from the same service flow because of the implicit transaction.
So my question is :
When an auto commit transaction is applied ? at the end of a main service flow or just after the calling of the adapter ?
Testing it in a same main service flow, I can observe the update does not work but does not throw any exception : I suspect the new ID is not found in the table as if the transaction had never been applied after the insert treatment.