You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "Martijn Visser (Jira)" <ji...@apache.org> on 2026/09/23 06:45:00 UTC

[jira] [Created] (FLINK-40777) Run the XA connection tests against PostgreSQL

Martijn Visser created FLINK-40777:
--------------------------------------

             Summary: Run the XA connection tests against PostgreSQL
                 Key: FLINK-40777
                 URL: https://issues.apache.org/jira/browse/FLINK-40777
             Project: Flink
          Issue Type: Technical Debt
          Components: Connectors / JDBC
            Reporter: Martijn Visser
            Assignee: Martijn Visser


SimpleXaConnectionProviderTest and TransactionIdConnectionTest are the only tests that commit a prepared XA transaction from a new connection, which is what the exactly-once committer and recovery rely on. Both run only on embedded Derby. FLINK-40730 replaces Derby with H2, and H2 discards a prepared transaction as soon as the connection that prepared it closes, so these tests cannot move there.

This ticket makes them database-agnostic, runs them on PostgreSQL (the test container already sets max_prepared_transactions), adds a recover() test, and moves the XA_RDONLY case to a unit test because neither PostgreSQL nor H2 returns it.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)