| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: JDBC gripe list (the autocommit subthread) |
| Date: | 2011-03-31 23:29:52 |
| Message-ID: | AANLkTi=DC-1-krHzod9DVsO6veb1a1NDJ59HRbyhMD-q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On 1 April 2011 12:21, A.M. <agentm(at)themactionfaction(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2011-04-01 09:49:58 | Re: JDBC gripe list (the autocommit subthread) |
| Previous Message | A.M. | 2011-03-31 23:21:10 | Re: JDBC gripe list (the autocommit subthread) |