Hi,

I am fairly new to Hibernate and currently running into the following issue. When executing a simple query using criteria the program hangs when trying to commit. I.e.

tx = session.beginTransaction();

List x = session.createCriteria (Books.class)
.setFetchMode("authors",FetchMode.JOIN)
.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();

tx.commit();

So, in fact the query gets executed (what I have seen from the log file, thanks to show_sql), but then Hibernate runs an update on that table. For what reason ever .... and this is where I (and the code) gets stuck.

What bother me most is that it has been working before .....

Any help, hint or just a direction where to look is greatly appreciated.

Thanks, Carsten

Hm,

it would be very helpful to know more details about this 'phantom'-update.
Please try to enable P6spy logging (P6spy is free) and report which
update hibernate is executing.

Guenther