Hi All,
I am currently developing a Spring MVC application.I have configured a
JDBC TransactionManager and I am doing declarative transaction management using AOP XML.However, even if I configure the method to run on a read-only=true, it still commits the transaction.
Database : Oracle 10g
My database-config.xml
My controller
How do I prevent the auto commit? I have also noticed that even if I don't put any transaction management code, the code still commits. Please help. Note, the transaction advice is however,invoked as when I put a no-rollback-for for RuntimeException and then do a 1/0, it correctly commits the data and rolls back if I put the same as rollback-for.
I have also tried out the query timeout by putting the
thread on sleep, even that doesn't work, but I figure that timeout might be for an actual query, so thats fine.
Please help!!