From: Assaf Arkin <arkin@exoffice.com>
To: Peter Mount <petermount@it.maidstone.gov.uk>
Cc: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Transaction support in 6.5.3/JDBC
Date: Thu, 09 Dec 1999 10:14:16 -0800
Message-ID: <384FF178.FA37B01F@exoffice.com> (raw)
References: <1B3D5E532D18D311861A00600865478C70BF1A@exchange1.nt.maidstone.gov.uk>
> PM: Hmmm, in theory if a transaction is in a dead state (ie: an SQL
> statement failed, so anything else is ignored until the rollback), there
> should be a message in the notify queue. Our JDBC driver keeps these in
> the warnings queue, so you could read them prior to calling commit()
> yourself.
From what I gather if an SQL statement failed, the CompletedResponse
will show *ABORT STATUS*. That's an easy modification. I'm not sure
about a warning being sent, I need to figure how to test this one.
The BE also returns the name of the cursor. I assume this one should be
returned from ResultSet.getCursorName()?
arkin
>
> arkin
>
> --
> ____________________________________________________________
> Assaf Arkin arkin@exoffice.com
> CTO http://www.exoffice.com
> Exoffice, The ExoLab Company tel: (650) 259-9796
>
> ************
>
> ************
--
____________________________________________________________
Assaf Arkin arkin@exoffice.com
CTO http://www.exoffice.com
Exoffice, The ExoLab Company tel: (650) 259-9796
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: arkin@exoffice.com, petermount@it.maidstone.gov.uk, pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Transaction support in 6.5.3/JDBC
In-Reply-To: <384FF178.FA37B01F@exoffice.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox