Am using built in Update and Insert adapter service, both uses the connection1 [which configured with LOCAL_TRANSACTION].
- Update service
- Insert service
When Insert service gets failed, Update operation was not getting rolled back automatically.
Note*: If I use explicit transaction its working fine.
But when verified the JDBC adapters guide documents found the below points:
- The Integration Server can automatically manage both kinds of transactions[LOCAL_TRANSACTION & XA_TRANSACTION], without requiring the adapter user to do anything.
- If your flow contains adapter services that use more then one LOCAL_TRANSACTION connection, you must use explicit transactions. [Here more than one connection means, different type of connection right? example connection1 and connection2 both have the transaction type ‘LOCAL_TRANSACTION’]
Whereas in my service am using only one connection (i.e. connection1 only for both Update and Insert service) why the transaction not getting rolled back automatically?
Please correct my understanding…