Nov 19th, 2009, 07:22 AM
PROPAGATION_NOT_SUPPORTED & MySQL
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:
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?