Re: locking a row from JDBC

There isn't really anything specific jdbc does with locking.  You need
to understand the locking behavior of the standard SQL commands you can
issue through jdbc.  In addition to INSERT and UPDATE, I think the one
you will find most useful is the SELECT ... FOR UPDATE command.  Check
out the regular postgres docs for information on locking and the
behavior of these sql commands.

--Barry


Joshua Daniel Franklin wrote:
> I am rather new to JDBC and am trying to build a small java
> application that will be used by a few people here. I have it
> working in a single-user mode, but I would like to be able
> to use some sort of locking on rows that are being edited
> to make it multi-user safe. A quick google search did not turn
> up anything interesting. Does anyone have any suggestions?
>
> Thanks.
>
> Joshua Daniel Franklin
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>