Message-ID: <gh-pgjdbc-pgjdbc-3897-c3714282860@github.com>
From: "CTH57 (@CTH57)" <noreply+CTH57@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Tue, 06 Jan 2026 11:04:49 +0000
Subject: Re: [pgjdbc/pgjdbc] PR #3897: fix: issue #3892, PGXAConnection.prepare(Xid) should return XA_RDONLY if the connection is read only
In-Reply-To: <gh-pgjdbc-pgjdbc-3897@github.com>
References: <gh-pgjdbc-pgjdbc-3897@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: CTH57
X-GitHub-Comment-Id: 3714282860
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3897
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/pull/3897#issuecomment-3714282860
Content-Type: text/plain; charset=utf-8

"XA_RDONLY is returned by prepare when no data has changed, ie the transaction only reads data"

Yes and it's obviously the case if the connection is read only.

In my case, the read only connection is used only to read data, so no need to commit this connection.