Why doesn't rollback? (doesn't work TransactionProxyFactor)

[wow]

I have a question... I want to use transaction in environment of Mysql & resin. so I was using Spring Framwork at this.

applicationContex.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http&#58;//www.springframework.org/dtd/spring-beans.dtd">

<beans>
	<!-- ========================= GENERAL DEFINITIONS ========================= -->
	<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="viewClass"><value>org.springframework.web.servlet.view.JstlView</value></property>
		<property name="contentType"><value>EUC-KR</value></property>
    </bean>

	<bean id="messageSource" class="org.springframework.context.support.ReloadableResourceBundleMessageSource">
        <property name="basename"><value>/WEB-INF/messages</value></property>
		<property name="defaultEncoding"><value>EUC-KR</value></property>
		<property name="cacheSeconds"><value>0</value></property>
    </bean>

	<bean id="localeResolver" class="org.springframework.web.servlet.i18n.SessionLocaleResolver"/>

	<!-- ========================= BUSINESS OBJECT DEFINITIONS ========================= -->
	<!-- transactionTest primary business object&#58; default implementation -->
	<bean id="userManager" class="net.playforum.transaction.domain.logic.UserManager">
		<property name="userDao"><ref bean="userDao"/></property>
	</bean>
	
	<!-- Transactional proxy for the transactionTest primary business object -->
	<bean id="testTransaction" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
		<property name="transactionManager"><ref bean="transactionManager"/></property>
		<property name="target"><ref local="userManager"/></property>
		<property name="transactionAttributes">
			<props>
				<prop key="*">PROPAGATION_REQUIRED,-Exception</prop>
			</props>
		</property>
	</bean>
</beans>

dataAccessContext-local.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http&#58;//www.springframework.org/dtd/spring-beans.dtd">

<beans>
	
	<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
		<property name="jndiName"><value>java&#58;comp/env/jdbc/test</value></property>
	</bean>

	
	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    	<property name="dataSource"><ref local="dataSource"/></property>
		<property name="rollbackOnCommitFailure"><value>true</value></property>
	</bean>

	<bean id="userDao" class="test.transaction.domain.logic.UserDao">
		<property name="dataSource"> <ref local="dataSource"/> </property>
		<property name="updateDataSource"> <ref local="dataSource"/></property>
	</bean>
		
</beans>

UserManager.java

public class UserManager {
  .
  .
    public boolean  updatePoint( String sender,   String receiver,  int amount) {
        boolean result = false;
       
        if ( checkPoint(sender, amount) ){
                        this.userDao.updatePoint(sender, amount * -1);
                        this.userDao.updatePoint(receiver, amount);
                        result = true;
        }
		return result;
    }
 .
 .
 .
}

but doesn't work transactionaly....;; What is problem?
Who is can help...me??

[wow]

I guess..aop dos not work... so transaction does not work...

[jc]

An obvious question perhaps, but i'll ask anyway. Are you using transactional tables in MySQL?

[wow]

yes... I was create table to innodb..

[chenrici]

Question: how are you testing this?
Be aware that the bean "testTransaction" is a proxy to the bean "userManager", so all method invocations on "userManager" need to go through "testTransaction". So eventually check where "userManager" is refered and possibly change to "testTransaction".
Christoph