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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-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

Browse pgsql-general by date

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

Browse pgsql-jdbc by date

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