I am trying to understand how implicit transactions work in web methods.
Environment IS 6.1 JDBC adapter 188.8.131.52 , using oracle thin client and LOCAL_TRANSACTION.
I have a simple test flow that
insert row A using a dynamic sql adapter— which will always succeed
insert row B using the same dynamic sql adapter— which will fail
I had assumed the implicit transaction would roll back, but row A is committed, it appears that row A is being auto committed.
Everything works as expected when explicit transaction control is used.
Thanks in advance for any help