[ https://issues.redhat.com/browse/TEIIDSB-155?page=com.atlassian.jira.plug... ] Steven Hawkins edited comment on TEIIDSB-155 at 1/7/20 12:33 PM: ----------------------------------------------------------------- Transactional support should allow us to use the loadnumber / upsert, rather than cache swapping. However there are a couple of issues. First is that this logic does not exist in Teiid, so it's untested from our side. 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. Lastly providing the transaction manager to the InfinispanConnectionFactory will require reworking the startup sequence wrt the transactionmanager. Since there's no option for infinispan to use the platform transaction manager, it must use either our adapter or the user supplied transaction manager. The latter is easy to autowire, but the adapter is created later than the datasources are and is not exposed as a bean. was (Author: shawkins): Creating an issue for transactional support - which should allow us to use the loadnumber / upsert, rather than cache swapping. -- This message was sent by Atlassian Jira (v7.13.8#713008)