I'm switching to Hibernate 2.0.2 / MySQL 4.0.12 from manual transactions. My old transaction needed to lock 2 tables, sum(field) in the first table, check the 2nd table against it, insert my record into the first table, then unlock everything. I am unable to figure out the right locking mode for doing something like this in Hibernate (MySQL dialect) or in the docs/faq's/forum/Internet.

Can someone point me in the right direction to either do with directly within Hibernate (MySQL dialect) or how to tell the session to lock/unlock certain tables for me at my command?

Thanks any help pointing me in the right direction.
David