Spring transaction setting

[Srinivas Ramgopal]

Hi all,

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?

Below is the spring config file:

 <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="mappingResources">
   <list>
        <value>x/y/A.hbm.xml</value>
        <value>x/y/B.hbm.xml</value>
               </list>
</property>
<property name="hibernateProperties">
   <props>
       <prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect
                    </prop>
      <prop key="hibernate.show_sql">false</prop>
   </props>
</property>
</bean>
 
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
<property name="url" value="jdbc :-o	 racle:thin:@xxxxxx" />
<property name="username" value="xxxx" />
<property name="password" value="xxxx" />
</bean>
 
<bean id="customClassA" class="z.zz.ClassA">
     <property name="sessionFactory" ref="sessionFactory"/>
</bean>


<aop:config>
    <aop :-P	 ointcut id="xMethods" expression="execution(* z.zz.ClassA.*(..))"/>
     <aop:advisor advice-ref="txAdvice1" pointcut-ref="xMethods"/>
</aop:config>
 

<bean id="hbManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory"/>
</bean>


<tx:advice id="txAdvice1" transaction-manager="hbManager">
    <tx:attributes>
   <tx:method name="insert" propagation="NOT_SUPPORTED"/>
</tx:attributes>
</tx:advice>

Any input is highly appreciated.

Thanks in advance for your time and interest.

[Srinivas Ramgopal]

Hi all,

I found the fix for this problem.

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.

Thanks.

[Halcon Guatemala]

sorry Srinivas, I'm a Spring+Hibernate, :roll: what do you mean with:

I had to set the autocommit to false at the database level in the config file.

?

Thanks in advance