Using XA has costs:
- slower in general, as coordination is required between resources,
- much slower on Oracle RAC,
- not available on SQL Server (simulated using jTDS),
- not available at all on Azure.
Change Nuxeo to be able to work in a mode where, in a given thread, only one database connection is used for all resources (VCS, directories, hibernate). This allows for a secure rollback.
Symptoms of the Oracle RAC problems may be errors like:
ORA-02049: timeout: distributed transaction waiting for lock
- depends on
-
NXP-10349 Remove use of Derby in embedded mode
- Resolved
- is duplicated by
-
NXP-10789 connection should not be in autocommit mode
- Resolved
- is required by
-
NXP-11706 Error trying to deploy more than one repository
- Resolved
-
NXP-12181 Tests for sql directories should init correctly
- Resolved
-
NXP-20280 CMIS bench does not work with single datasource
- Resolved
-
NXP-4406 Preliminary DB2 support
- Resolved
-
NXP-10234 Support Azure's flavor of SQL Server
- Resolved
-
NXP-11830 SQL directories should warn about unclosed sessions
- Resolved