Hey,
I am using Spring with HibernateTransactionManager and working on MySQL.
I have setup all methods start with list* to run in non-transacional way and as readyOnly:

<prop key="list*">PROPAGATION_NOT_SUPPORTED,readOnly,-Exception</prop>

When i execute my application i can see a new connection open on MySQL but the query is never executed and connection just hang.

When i change the configuration to PROPAGATION_REQUIRED it works fine.

Any idea what may be the reason? what is the best practice on using non-transacional with MySQL?

Thanks.