I'm looking at doing pessimistic locking in one situation, and seeing that some people do:

org.hibernate.Query q;
...
q.setLockMode("tablealiastolock", LockMode.UPGRADE);

to make that happen, but I don't see how that would work with MySQL because the MySQL dialects don't override Dialect.forUpdateOfColumns() and it returns false by default. Should I maybe extend MySQL5InnoDBDialect to enable "select for update"? I am on MySQL 5.0, and it seems like it supports the "select for update" syntax in InnoDB: http://dev.mysql.com/doc/refman/5.0/en/ ... reads.html

Thanks,
Jim