I am using Spring v2.x's HibernateTransactionManager to declare transactions using Hibernate v3.x.
I have the transaction setting as NOT_SUPPORTED on insert() on a DAO class. A row is being inserted into the database inspite of the above transaction setting.
Why is this so? Do I need to explictly set the autocommit false? Can some one explain the internal mechanism of spring's hibernateTransactionManager?
I had to set the autocommit to false at the database level in the config file.
But I assumed that Spring's HibernateTransactionManager that manages the Hibernate session will take care of setting the autocommit to false but it seem not to be the case.