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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-jdbc pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Namrata | 2001-07-09 12:11:46 | problem in compilation. |
Previous Message | Ola Sundell | 2001-07-08 22:19:21 | UpdateableResultSets and concurrency. |
From | Date | Subject | |
---|---|---|---|
Next Message | jason | 2001-07-09 09:02:31 | Re: DatabaseMetaData.getCatalogs() |
Previous Message | Tom Lane | 2001-07-09 01:34:26 | Re: DatabaseMetaData.getCatalogs() |
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Shraibman | 2001-07-09 18:14:31 | Re: Patch to remove connection hook and JDK 1.3 dependencies |
Previous Message | Justin Clift | 2001-07-09 02:44:52 | Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword |