When I use XATransaction in Oracle for multiple databases DB1 and DB2, I encountered the problem that WildFly inserts incorrect data.
I can reproduce the problem as follows.
First, you get a connection from the DB1 data source. Second, you get a connection from the DB2 data source. And, if you insert with the DB2 connection, then an incorrect data is inserted. When the incorrect data is inserted, you cannot search the data by using Oracle Locator. It seems that the spatial index is not updated when the data is inserted. So Oracle Locator cannot search the inserted data.
The problem occurs on WildFly + Oracle under the condition of using XATransaction, and Oracle Locator. The problem does not occur when I use only one DB, or when I use only one connection. And, the problem does not occur when I use other APP servers such as WebSphere. I think that there may be a problem around the Wildfly-Transaction-Client module.
Does anyone know how to solve this problem?
