Re: [GENERAL] [JDBC] java is locked when select for update

2005-03-09 Thread Csaba Nagy
Whoops, posted to the wrong mailing list... but it might fit anyway. ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] [JDBC] java is locked when select for update

2005-03-09 Thread Csaba Nagy
Please post to the list too when replying... On Wed, 2005-03-09 at 17:29, Mican Bican wrote: > Thank you for your answer. The reason of so long transactions is that > I first Insert a row than get the last ID (primary key) and select it > for update from the database and wait for user to commit it