v3 protocol question

From: "Chris Smith" <cdsmith(at)twu(dot)net>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: v3 protocol question
Date: 2004-02-19 17:32:35
Message-ID: 054e01c3f70e$5d35b6f0$6f00000a@KYA
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-02-19 22:16:20 Re: ResultSetMetaData.isNullable(i) not working?
Previous Message Guido Fiala 2004-02-19 16:25:32 ResultSetMetaData.isNullable(i) not working?