Skip site navigation (1) Skip section navigation (2)

Re: UpdateableResultSets and concurrency.

From: Ola Sundell <ola(at)miranda(dot)org>
To: "'PostgreSQL jdbc list'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: UpdateableResultSets and concurrency.
Date: 2001-07-09 07:48:43
Message-ID: Pine.LNX.4.21.0107090347230.15085-100000@miranda.org (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-jdbcpgsql-patches
On Sun, 8 Jul 2001, Ola Sundell wrote:

> On Tue, 26 Jun 2001, Dave Cramer wrote:
> 
> > Ola,
> > 
> > How are you planning on determining if the underlying data has been
> > changed by some other process? There is a system column called xmin
> > which can be used, however you will have to add it to the select.
> > 
> > Dave
> 
> At first, I will let the backend handle any and all problems that might
> occur. I will simply forward any exceptions I get, and let the overlying
> code handle the problems. I checked the MySQL driver, and that is how they
> are doing it.
> 
> I wonder how it works with non-free databases. Does anyone here know?

Silly me.

When I woke up this morning, I realised that MySQL doesn't support
transactions. I re-read the JDBC spec, and I will do a simple optimistic
concurrency control by starting a transaction, re-reading the row and
checking the values.

mvh Ola

-- 
Ola Sundell
ola(at)miranda(dot)org - olas(at)wiw(dot)org - ola(dot)sundell(at)upright(dot)se
http://miranda.org/~ola


In response to

pgsql-admin by date

Next:From: NamrataDate: 2001-07-09 12:11:46
Subject: problem in compilation.
Previous:From: Ola SundellDate: 2001-07-08 22:19:21
Subject: UpdateableResultSets and concurrency.

pgsql-patches by date

Next:From: Joseph ShraibmanDate: 2001-07-09 18:14:31
Subject: Re: Patch to remove connection hook and JDK 1.3 dependencies
Previous:From: Justin CliftDate: 2001-07-09 02:44:52
Subject: Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword

pgsql-jdbc by date

Next:From: jasonDate: 2001-07-09 09:02:31
Subject: Re: DatabaseMetaData.getCatalogs()
Previous:From: Tom LaneDate: 2001-07-09 01:34:26
Subject: Re: DatabaseMetaData.getCatalogs()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group