Implement XA Support for Oracle Database

[rrobetti]

Follow the approach in PR #68 (PostgreSQL XA support) to add XA (distributed transaction) support for Oracle in the integration test suite.

What to do:

• Update the XADataSourceFactory to fully implement createOracleXADataSource (see how it's done for PostgreSQL in the PR)
• Update Oracle integration tests: parameterize with both isXA=false and isXA=true in the relevant CSV files and test classes, as done for PostgreSQL
• Ensure tests use TestDBUtils.createConnection() to properly handle XA
• Validate XA functionality by running the tests in both JDBC and XA modes

References:

• PostgreSQL implementation: PR #68
• XA support guide

Keep the issue focused on Oracle only. Use the links above for detailed instructions and examples.

[ignorant05]

Hey @rrobetti, can i do this task ?

[rrobetti]

Hey @rrobetti, can i do this task ?

Sure 👍

[Aphatheology]

@rrobetti There is a PR successfully merged regarding this issue, but the issue is still open.
This seems to be reoccuring in other issues as well. Is this intentional (issue requiring manual closing) or this is because PRs are not properly linked to their respective issues?
If it is the later, then maybe a CONTRIBUTING.md might be needed (at root level in the repository) to offer guidelines on fixing such.

[rrobetti]

@rrobetti There is a PR successfully merged regarding this issue, but the issue is still open. This seems to be reoccuring in other issues as well. Is this intentional (issue requiring manual closing) or this is because PRs are not properly linked to their respective issues? If it is the later, then maybe a CONTRIBUTING.md might be needed (at root level in the repository) to offer guidelines on fixing such.

Good point, these need to be reviewed as per the initial goal was to make all tests XA and non-XA but that ended up not being implemented. Which PR you believe implemented this issue?
We will work on a CONTRIBUTING.md file =)