I've decided to change all the SPs to explcitly Rollback or Commit.
Clearly this has implications on multi-SP transactions (i.e. we can't have them!)
If anybody knows if we [i]should [/i]be able to configurably set defaultAutoCommit on glassfish for an Oracle db pool, I'd love to know!
Thank you
[Message sent by forum member 'm_jenkins']
http://forums.java.net/jive/thread.jspa?messageID=399035