Transactional on AspectJ Interceptors

[jan247]

Hi, I wish to define an interceptor which logs requests to a certain table in the database. Currently, my interceptor looks something like:

@Around("execution(public * com.xyz.abc.SomeClass.someMethod*(..))")
@Transactional(propagation=Propagation.REQUIRED)
public Object handleRequest(ProceedingJoinPoint pjp) throws Throwable {
...
  try {
    basicErrorChecking();
    pjp.proceed();
  } catch (SomeException ex) {
    logExceptionInDatabase(ex);
  }
...
}

And on the target:

@Transactional(propagation=Propagation.NESTED, rollbackFor=CustomException.class)
public String someMethod(String a, String b) throws CustomException {
  ...
}

I am not sure how to configure this. Simply using the following code:

<aop:aspectj-autoproxy />
<tx:annotation-driven transaction-manager="transactionManager" order="20"/>

disregards Transactional attributes in the interceptor.

[Andrei Stefan]

Take a look at this thread for an example of logging database access:
http://forum.springframework.org/showthread.php?t=9945