Re: Select For Update question

Barry Lind wrote:
>
> You are running with AutoCommit turned off aren't you?
> Without autocommit being turned off, the locks will be immediately
> released as soon as the statement autocommits and ends the tranaction.

I am really new to using transactions with JDBC so I did not know about
AutoCommit, I'll look into that. Anything else I should know about when
trying to use transaction? I have been naively doing them as I would on
the psql console, i.e:

stmt.executeQuery("BEGIN");
//many update statements
stmt.executeQuery("COMMIT");

From what you have written I'm guessing that is *not* the way to go
about it ...

Any pointers to documentation relation to transactions and JDBC welcomed :)

Thanks,

Jean-Christian Imbeault