v3 protocol question - Mailing list pgsql-jdbc

From Chris Smith
Subject v3 protocol question
Date
Msg-id 054e01c3f70e$5d35b6f0$6f00000a@KYA
Whole thread Raw
Responses Re: v3 protocol question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
I'm working on batch executes now, and ran into the following interpretation
with the v3 protocol.  Does anyone know off-hand?  Can I issue a series of
multiple Parse/Execute/Bind statements without an intervening Sync?  From
reading the docs, it seems like doing so would be valid, and it would have two
effects:

1. The statements would occur in the same transaction even in autocommit mode.
2. An error somewhere will cause the remainder to be skipped.

Seems like that's exactly what we want to occur if someone submits a string
containing multiple SQL statements as one member of a batch transaction.
However, I'm unclear on whether this is really even possible or not.

--
www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation


pgsql-jdbc by date:

Previous
From: Guido Fiala
Date:
Subject: ResultSetMetaData.isNullable(i) not working?
Next
From: Kris Jurka
Date:
Subject: Re: ResultSetMetaData.isNullable(i) not working?