| 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: | Whole Thread | Raw Message | 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 |