Cannot call Connection.commit in distributed transaction. Transaction Manager will commit the resource manager when the distributed transaction is committed..
So after created the data source and added some connection pool in dbadapter, I created the services using JDeveloper. I exported the files (XML Scheme, WSDL, and JCA binding) successfully into oracle service bus. I activated the changes.
But when I tested it in OBS test console, it returned that error.
So, I finally remember what’s wrong. In certain DB infrastructure you need to untick the “Supports Global Transactions” in data source configuration (Data Source > “the data source” > transaction tab).
Untick that, and after restart the targeted MS, you’ll see your service works.