Patrick,
I thought, that if I turned off autocommit I would enter a transaction.
Then, by using the select...for update, that I would take and hole a
lock on the table.
With a transaction-capable table, eg InnoDB, otherwise neither setting
autocommit off nor adding FOR UPDATE has any
Hi,
I am running MySQL 4.0.1 with j/connector 3.1 and I am having problems
trying to figure out why I am not getting the results I am expecting.
I have a table that is used for generating primary keys. It only has one
item, an int that is incremented each time a key is needed. This is not
Hello.
The logic of your application is clear and should work (though I haven't
been digging deeply inside the code). Check that the table type is
InnoDB. 4.0.1 version is rather old and could have lots of bugs, I
recommend you to upgrade to the latest release. Another reason, is that
your
-
From: Patrick Duda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 08, 2006 10:20 AM
To: mysql@lists.mysql.com
Subject: question about locking
Hi,
I am running MySQL 4.0.1 with j/connector 3.1 and I am having problems
trying to figure out why I am not getting the results I am expecting.
I
Hi Guys
According to documentation from MYSQL the query
Select * from test where test=5 FOR UPDATE
Should lock the row which satisfies the above condition. But this is not
working for me. I tried this query with InnoDB table. Does anybody knows
what could be a possible cause for this.
Rajneesh