Hello,


I'm investigating a recurring problem of dead locks. I *think* the origin is that a process is frequently locking tables instead of individual rows.

show open tables where in_use > 0

While the process runs I'm almost always getting something for this query.


I'm going to debug manually line-by-line and check for locks at the same time. But it would mightily help is somebody here knows whether there are circumstances Hibernate would cause a table lock instead of locks for individual rows ?

* MySQL 5.x
* Hibernate distribution 3.5.3
* C3P0
* Spring 3.x

TIA !

Jan