Using IS 6.1
I do a …
pub.db:connect pub.db:clearTransaction ( just in case... ) pub.db:startTransaction
then my flow service executes numerous steps and meanders through numerous other flows services using pub.db:execSQL, pub.db:update , pub.db:delete ,etc ( all using the same conn object I used to startTransaction )
If at some point an update or insert fails, I trap it and perform a rollback.
Problem is, the transaction doesn’t rollback. The inserts, updates, deletes
I previously issued, all get processed and commited.
I have double checked to ensure that the same conn object I use to
startTransaction is the same one I use to rollback. This happens in both debug mode and when I run the transaction completely through with the Developer.
I am sure I am missing something, but don’t know what. I do just enough webMethods coding to be dangerous.