iBatis SqlMaps, Websphere and transactions
Just wondering if anyone has had experienced this problem. I'm using Spring, iBatis and Websphere 4 and am trying to utilise the lazy loading capabilities of SqlMaps. When I set it up without any transaction manager, I get the following exception when accessing a member of the lazily-loaded collection:
Error lazy loading result. Cause: com.ibm.ejs.cm.exception.WorkRolledbackException: Outstanding work on this connection which was not comitted or rolledback by the user has been rolledback.
The thread here suggests that setting the 'transactionManager' configuration property in the SqlMaps configuration file to 'JTA' will solve the problem. However, this configuration property also requires a datasource to be set - something which I don't need to do since I'm using Spring. I cannot set the 'transactionManager' property along.
Has anyone come across this before and found a solution?
Geoff
Reply With Quote