Hibernate updates and MySQL 5.0 InnoDB Max

Something else came up today with all this transaction and MySQL stuff. Looks like Hibernate updates do not work unless the session is participating in a transaction when using MySQL InnoDB Max with the default isolation level set to READ-COMMITTED or READ-UNCOMITTED. The tricky part is that inserts work fine but updates never get executed. If you tweak the code and add a transaction or use a Spring annotation or proxy to manage the transaction everything starts working quite nicely.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s