Transaction.REQUIRES_NEW

[Csabba Csurja]

Hello Guys,

I have a very simple example for testing the transaction feature in Spring 3.
There is a Requires_new propagation level, and I would expect that this transaction as a whole will be rolled back completely because expiration flag is after second run was changed to false (-> throws UnsupportedOperationException error)
But the john, mike are commited and shaik is not...

@Repository
public class MyDbManager extends SimpleJdbcDaoSupport {
    
    public void saveUser(String userName, String email, Boolean expired){
        if (expired){
            throw new UnsupportedOperationException();
        }
        getJdbcTemplate().update("INSERT INTO usertable (username, email) VALUES (?,?)",new Object[]{userName,email});
    }
    
    @Transactional(propagation= Propagation.REQUIRES_NEW, rollbackFor=UnsupportedOperationException.class)
    public void batchSave(){
        saveUser("john","[e-mail]",false);
        saveUser("mike","[e-mail]",false);
        saveUser("shaik","[e-mail]",true);
    }
 }

snippet from applictationContext.xml
<context:component-scan base-package="springdbdemo"/> <tx:annotation-driven transaction-manager="txManager"/> <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource"/> </bean> <bean id="dataSource" class="org.springframework.jdbc.datasource.SingleConnectionDataSource"> <property name="driverClassName" value="org.hsqldb.jdbcDriver"/> <property name="url" value="jdbc:hsqldb:hsql://localhost/PUBLIC/"/> <property name="username" value="sa"/> <property name="password" value=""/> </bean>

Intentionally, I tried to keep this example as simple as possible, What did I wrong?

Thanks in advance,
Csaba

[Sam Mercs]

How are you trying this example out? Where and what does your main method look like?

[Csabba Csurja]

Hi Sam,

there is nothing special, which looks like this:

    public static void main(String[] args) {
        ApplicationContext ctx = new ClassPathXmlApplicationContext("springdbdemo/applicationContext.xml");
        
        MyDbManager myDbManager = (MyDbManager)ctx.getBean("myDbManager");
        
        myDbManager.batchSave();
}

thanks,
Csaba

[Sam Mercs]

You configuration looks ok to me and nothing strike me as particularly missing. I'll have to pass up on this one, no clue why its not working!