RE: JDBC Drop/Create problem? - Mailing list pgsql-interfaces

From Joachim Achtzehnter
Subject RE: JDBC Drop/Create problem?
Date
Msg-id Pine.LNX.4.21.0012110922080.18977-100000@penguin.kraut.ca
Whole thread Raw
In response to RE: JDBC Drop/Create problem?  (Peter Mount <petermount@maidstone.gov.uk>)
List pgsql-interfaces
Today, in a message to pgsql-interfaces, Peter Mount wrote:
>
> The problem JDBC has is that it's DatabaseMetaData methods can make
> several queries. While AutoCommit is off, if one of those fails, the
> users transaction will also fail.

If the JDBC driver under the hood performs several queries in response to
a single 'user command' and one of these fails it can still report that
command's failure without aborting the whole transaction (assuming the
backend supports statement-level aborts, of course). 

Joachim

-- 
work:     joachima@realtimeint.com  (http://www.realtimeint.com)
private:  joachim@kraut.ca          (http://www.kraut.ca)




pgsql-interfaces by date:

Previous
From: Ken Kachnowich
Date:
Subject: RE: JDBC Timestamp Problem
Next
From: Peter Mount
Date:
Subject: RE: RE: JDBC Timestamp Problem