my name is Francois and I am new to developing in webmethods.
Today I was trying to use the startTransaction, commitTransaction , rollbackTransaction ( from WmART).
I tried to insert a series of rows , input to the flow service was a document with a list of key, description pairs that simply should be inserted in a table in an Oracle database.
The connection used was configured with LOCAL_TRANSACTION.
I deliberately entered in the inputdocument ,for the third row, a string that was too large to be inserted into the Key-column of my table.
At the start of the flow I invoked StartTransaction
After the insert-error the rollbackTransaction service was executed but the rows inserted before the error-row still appeared in the table.
Is there anyone who knows what might be the problem.