Second caches default to non-transactional, so the operator based cache or a cache created on the fly will by non-transactional. For things to work both the remote and local sides need to be setup for transactional support.

Infinispan configuration should support a transactional cache ------------------------------------------------------------- Key: TEIIDSB-155 URL: https://issues.redhat.com/browse/TEIIDSB-155 Project: Teiid Spring Boot Issue Type: Enhancement Components: datasource Reporter: Steven Hawkins Priority: Major Fix For: 1.3.1 The configuration should allow for single phase commit and non-recoverable xa. This will need to change the transaction support on the translator, set the transaction config, and register a transactionManager lookup that can find the configured transaction manager. The infinispan operator does not provide a way to configure the transaction support of the cache, so this may not fully work yet - I'll test to see what happens both with the default cache and with trying to create one on demand.