From: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
---|---|
To: | pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Select For Update question |
Date: | 2003-03-26 06:20:26 |
Message-ID: | 3E8146AA.60804@mega-bucks.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I would like to use a SELECT ... FOR UPDATE statement in my Java program
in order to lock some rows while I do some work on them. However either
I don't understand how to use the JDBC connection properly of the FOR
UPDATE construct doesn't work with the JDBC driver.
As a test case I built a small GUI with just one button. When I click
the button the following sql is executed:
"select * from test for update";
While the GUI is still open I open a psql console and I am capable of
manually updating the rows in the test table ... they are not locked as
I had hoped.
What is the proper way to use select .. for update with the JDC driver?
Can someone point me to some example or documentation?
Thanks,
Jean-Christian Imbeault
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Lind | 2003-03-26 06:35:50 | Re: jdbc.postgresql.org |
Previous Message | Jean-Christian Imbeault | 2003-03-26 06:11:41 | jdbc.postgresql.org |