Problems with Spring Transactions Support

[Regis Santos]

Hello,

I'll try to explain the problem as clear as possible.

I have a web app with Hibernate on persistence layer.

I have a service class called UserServiceImpl with a dependency to a DAO object. In my service class, there is a method called updatePrefixes() that invokes two methods on DAO object: a method removeAll(Object) and another one to insertAll(Object).

    public void updatePrefixes(User user) {
        List prefixes = getUserDAO().findPrefixesFrom(user);
 
        if(prefixes!=null && !prefixes.isEmpty()){
            // execute remove first
            removeAll(prefixes);
        }
 
        getUserDAO().deletePrefixesFrom(user);
        removeUnwantedPrefixes(user);
 
        if(user.getPrefixes()!=null){
            // execute insert last
            insertAll(user.getPrefixes());
        }
 
    }
 

These methods are called in the followin order:
dao.removeAll();
dao.insertAll();

I've declared the service's methods to be managed by Spring Transaction in the applicationContext.xml:

 
<beans>
...
  <!-- Transaction manager for a single Hibernate SessionFactory (alternative to JTA) -->
  <bean id="transactionManager" class="org.springframework.orm.hibernate.HibernateTransactionManager">
    <property name="sessionFactory">
      <ref bean="sessionFactory"/>
    </property>
  </bean>
 
  <!-- Transaction Interceptor set up to do PROPAGATION_REQUIRED on all methods -->
  <bean id="matchAllWithPropReq" class="org.springframework.transaction.interceptor.MatchAlwaysTransactionAttributeSource">
    <property name="transactionAttribute"><value>PROPAGATION_REQUIRED</value></property>
  </bean>
  <bean id="matchAllTxInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor">
    <property name="transactionManager"><ref bean="transactionManager"/></property>
    <property name="transactionAttributeSource"><ref bean="matchAllWithPropReq"/></property>
  </bean>
 
  <!-- One BeanNameAutoProxyCreator handles all beans where we want all methods to use PROPAGATION_REQUIRED -->
  <bean id="autoProxyCreator" class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
    <property name="interceptorNames">
      <list>
        <idref local="matchAllTxInterceptor"/>
      </list>
    </property>
    <property name="beanNames">
      <list>
        <idref local="callService"/>
        <idref local="logService"/>
        <idref local="userService"/>
        <idref local="accountService"/>
      </list>
    </property>
  </bean>
 
</beans>

The PROPAGATION_REQUIRED transaction definition means that the DAO's methods will execute in the service's method transaction.

The problems is that the DAO's removeAll() method is called after the insertAll() method.

How can I do to execute the DAO's mehtods in the order that they were declared?

Thanks a lot.
[ April 14, 2005: Message edited by: Regis Santos ]