Does anyone know how to do a full table lock in Hibernate?

I have to do some business validations on the existing data before I insert my object, but I want to prevent any inserts while I'm in the process of validation.

Or is there a better way to do this?

Thanks!

José

I have the same question. I see how I can apply a lock to a single object (row), but how do I lock a table against reads while I update it?

If I'm about to add a row with data that's derived from the existing data, I don't want another process doing the same thing.

Mojo

Since a Hibernate session allows you to execute SQL directly, why not use that to execute something like “LOCK TABLE <tablename>…” ?

While locking the table will work - the process of locking an entire table just doesn't seem right. There must be other ways to accomplish what you're trying to do, like unique constraints for example.