Re: Atomic operations?

Dave Cramer wrote:
>
> On 18-Mar-08, at 9:40 AM, Paul Tomblin wrote:

>>   PreparedStatement ps = conn.prepareStatement(
>>      "DELETE FROM venue WHERE venueid = ? ; INSERT INTO VENUE
>> (venueid, .... ) VALUES(?, ?, ?, ?)");

>> Does that work?  Will that be atomic so that nobody else can insert
>> one with that venueid in between the delete and the insert?
>>
> I don't think so,

Actually it's fine the implicit transaction created by the server to
support autocommit wraps both queries in a single transaction and does
not commit/rollback until the end of the second query.

-O