Re: MySQL trouble on rollback with update

[iam iam]

If you don't specify to use the InnoDB or BDB table types, you won't be able to use transactions. Create your table as follows:

CREATE TABLE process_lock (
type INT NOT NULL,
count INT NOT NULL,
PRIMARY KEY (type)
) TYPE=InnoDB;

You must assure, too, that your MySQL server has InnoDB suport activated. See http://dev.mysql.com/books/mysqlpress/mysql-tutorial/ch10.html for that.