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

java is locked when select for update

From: Mican Bican <mican58(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: java is locked when select for update
Date: 2005-03-09 15:54:40
Message-ID: 915cd38805030907545882333f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbc
Hello,

I use Postgresql 8.0.1 with java 5 and jdbc3 on windows xp.

When I do a "select for update" a row.. and dont commit the statement
and when in this time an other user do also this. my java gui wait and
locked till the first user commit his statement.. my question is how
can I realize this with java.. for example why they are not a
SQLException or are Error like "an other user is updating this row"...
or can I say to java "dont wait" or "dont lock" when you make a select
for update and an other user before you make this..

thank you..

best regards

Mican Bican

Responses

pgsql-jdbc by date

Next:From: Rover, Mischa deDate: 2005-03-09 16:10:55
Subject: Crystal Reports: Connection rejected: FATAL: no PostgreSQL user name specified in startup packet.
Previous:From: Roland WalterDate: 2005-03-09 13:27:44
Subject: Re: JDBC driver build 215 slow when index contains column

pgsql-general by date

Next:From: Csaba NagyDate: 2005-03-09 16:12:40
Subject: Re: java is locked when select for update
Previous:From: Alessandro VincelliDate: 2005-03-09 15:49:28
Subject: Not use index on setof from Sql Function

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