Re: JDBC gripe list (the autocommit subthread) - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: JDBC gripe list (the autocommit subthread)
Date
Msg-id AANLkTi=DC-1-krHzod9DVsO6veb1a1NDJ59HRbyhMD-q@mail.gmail.com
Whole thread Raw
In response to Re: JDBC gripe list (the autocommit subthread)  ("A.M." <agentm@themactionfaction.com>)
List pgsql-jdbc
On 1 April 2011 12:21, A.M. <agentm@themactionfaction.com> wrote:

> Note that the v2 backend protocol does not support multiple queries per statement.

Actually it is the other way around..

v2 and v3 simple query will parse semicolon-separated statements (so
older drivers did nothing special with semicolon-separated statements,
they just got passed intact to the server).

v3 extended query does not support multiple queries per Parse/Execute,
so the driver parses semicolon-separated statements and submits them
via separate Parse commands (but within the same implicit transaction
block terminated by Sync) - which achieves essentially the same
behavior as v2/v3 simple query while still allowing access to the
extra flexibility of the extended query protocol.

Oliver

pgsql-jdbc by date:

Previous
From: "A.M."
Date:
Subject: Re: JDBC gripe list (the autocommit subthread)
Next
From: Dave Cramer
Date:
Subject: Re: JDBC gripe list (the autocommit subthread)