thanx for all the replies.
i found the solution with a single select and update, it was a simple
update(how did i miss tht???)
but what if i want to do a compelete transaction with row level locking
in consideration, as thr can be time lag between the queries(select and
update) so a row level lock
At 18:57 +0530 4/16/04, Sahil Aggarwal wrote:
hi all,
i have select statements in my java code which are followed by updates
in my Innodb table.
the desired behaviour shud have been
check and then update
but because of tomcat accepting connections the above becomes
check check update update
i dont
Are you running the queries in parallel or serially? Are you using the same
connection? Are you issuing Low Priority Updates?
-Original Message-
From: Sahil Aggarwal
To: [EMAIL PROTECTED]
Sent: 4/16/04 8:27 AM
Subject: row locking
hi all,
i have select statements in my java code which a
use InnoDB which does support row-locking (MySQL-Max)
-Original Message-
From: Sherzod B. Ruzmetov [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 9:23 AM
To: [EMAIL PROTECTED]; MySQL Maling list
Subject: Row Locking issue in 3.23.x
Hi. As far as I know, MySQL doesn't suport ro
