If any of you are familiar with Spring and iBATIS transactions, please look at this. I am really stuck right now.
I have a typical multi tiered project. Logic layers are in Spring. DAO is handled by iBATIS. Transaction management is handled by Spring's DataSourceTransactionManager.
The problem is I am getting the following error when I use the transaction manager.
Spring's application config looks like this:
Note: If I remove the transaction manager, the code works fine. With the transaction manager this one insert does not work. Other inserts, updates, deletes, and selects all work fine either way.
It looks like a simple configuration issue. The transaction is blocking access to the database because the class has read-only access according to the transaction manager.
I have tried specifying the access privileges manually in the Spring application config. No go. I am using the transaction annotation. I have tried setting the privilege there with @Transactional(readOnly=false). No go.
What totally obvious thing am I doing wrong?
The squeaky wheel gets the grease. Well, that or replaced...