How do I know if transaction is configured successfully?

[Saurabh Pillai]

I am using spring 2.5.6 and have strictly followed the example given in documentation. but when I run the program and check the console it does not give any indication regarding transaction.

Context.xml

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" destroy-method="close">	 
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://X.X.X.X:3306/dbname" />
		<property name="username" value="username" />
		<property name="password" value="password" />
	</bean>
	
	<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource"></property>
	</bean>
	
	<bean id="fooService" class="com.X.X.admin.service.serviceImpl.FooServiceImpl"/>

	<tx:advice id="txAdvice" transaction-manager="txManager">
		<tx:attributes>
			<tx:method name="get*" read-only="true"/>
			<tx:method name="*"/>
		</tx:attributes>
	</tx:advice>
	
	<aop:config>
		<aop:pointcut id="fooServiceOperation" expression="execution(* com.X.X.admin.service.FooService.*(..))"/>
		<aop:advisor advice-ref="txAdvice" pointcut-ref="fooServiceOperation"/>
	</aop:config>

Boot.java

public class Boot {
	
	public static void main(final String[] args) throws Exception {
		
		BasicConfigurator.configure();
		
		Logger logger = Logger.getLogger(Boot.class);
		logger.setLevel(Level.DEBUG);
		
	    ApplicationContext ctx = new ClassPathXmlApplicationContext("context.xml", Boot.class);
	    FooService fooService = (FooService) ctx.getBean("fooService");
	    fooService.insertFoo (5);
	    

	  }
}

My Console output

- 
Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@1c672d0: display name [org.springframework.context.support.ClassPathXmlApplicationContext@1c672d0]; 
startup date [Thu Feb 03 12:21:39 EST 2011]; root of context hierarchy
0 [main] INFO org.springframework.context.support.ClassPathXmlApplicationContext  - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@1c672d0: 
display name [org.springframework.context.support.ClassPathXmlApplicationContext@1c672d0]; 
startup date [Thu Feb 03 12:21:39 EST 2011]; root of context hierarchy
- Loading XML bean definitions from class path resource [context.xml]
63 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader  - 
Loading XML bean definitions from class path resource [context.xml]
- Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext@1c672d0]: org.springframework.beans.factory.support.DefaultListableBeanFactory@12a0f6c
297 [main] INFO org.springframework.context.support.ClassPathXmlApplicationContext  - 
Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext@1c672d0]: 
org.springframework.beans.factory.support.DefaultListableBeanFactory@12a0f6c
- Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@12a0f6c: 
defining beans [dataSource,txManager,fooService,txAdvice,
org.springframework.aop.config.internalAutoProxyCreator,fooServiceOperation,
org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0]; 
root of factory hierarchy
359 [main] INFO org.springframework.beans.factory.support.DefaultListableBeanFactory  - 
Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@12a0f6c: 
defining beans [dataSource,txManager,fooService,txAdvice,
org.springframework.aop.config.internalAutoProxyCreator,fooServiceOperation,
org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0]; 
root of factory hierarchy
- Loaded JDBC driver: com.mysql.jdbc.Driver
469 [main] INFO org.springframework.jdbc.datasource.DriverManagerDataSource  - 
Loaded JDBC driver: com.mysql.jdbc.Driver
Exception in thread "main" java.lang.UnsupportedOperationException

Console output according to Spring documentation

 <!-- the Spring container is starting up... -->
[AspectJInvocationContextExposingAdvisorAutoProxyCreator] - Creating implicit proxy
    for bean 'fooService' with 0 common interceptors and 1 specific interceptors
  <!-- the DefaultFooService is actually proxied -->
[JdkDynamicAopProxy] - Creating JDK dynamic proxy for [x.y.service.DefaultFooService]

  <!-- ... the insertFoo(..) method is now being invoked on the proxy -->

[TransactionInterceptor] - Getting transaction for x.y.service.FooService.insertFoo
  <!-- the transactional advice kicks in here... -->
[DataSourceTransactionManager] - Creating new transaction with name [x.y.service.FooService.insertFoo]
[DataSourceTransactionManager] - Acquired Connection
    [org.apache.commons.dbcp.PoolableConnection@a53de4] for JDBC transaction

  <!-- the insertFoo(..) method from DefaultFooService throws an exception... -->
[RuleBasedTransactionAttribute] - Applying rules to determine whether transaction should
    rollback on java.lang.UnsupportedOperationException
[TransactionInterceptor] - Invoking rollback for transaction on x.y.service.FooService.insertFoo
    due to throwable [java.lang.UnsupportedOperationException]

   <!-- and the transaction is rolled back (by default, RuntimeException instances cause rollback) -->
[DataSourceTransactionManager] - Rolling back JDBC transaction on Connection
    [org.apache.commons.dbcp.PoolableConnection@a53de4]
[DataSourceTransactionManager] - Releasing JDBC Connection after transaction
[DataSourceUtils] - Returning JDBC Connection to DataSource

Exception in thread "main" java.lang.UnsupportedOperationException
	at x.y.service.DefaultFooService.insertFoo(DefaultFooService.java:14)
   <!-- AOP infrastructure stack trace elements removed for clarity -->
	at $Proxy0.insertFoo(Unknown Source)
	at Boot.main(Boot.java:11)

Spring reference document : http://static.springsource.org/spring/docs/2.5.x/reference/transaction.html#transaction-declarative-first-example

Cross post : http://forum.springsource.org/showthread.php?t=102801

[Tom Reilly]

In your main() method, try catching java.lang.UnsupportedOperationException and print the stack trace as well as its message to see if you can glean any more information about the error.

[Saurabh Pillai]

I am not worried about exception. I am throwing it explicitly from code. My question is , how do I know if transaction is configured properly. as my console output does not give me any indication.

[Tom Reilly]

Try running a test where the transaction succeeds and see that the data is written to the database. Then try a test where the transaction is supposed to roll back and see that the data is not written to the database.