How did you resolve this? Thanks.
Using jta transactions, and local or xa jca-jdbc wrappers, autocommit is in fact off whenever you are in a jta transaction. Most versions of jboss do not report this correctly from "getAutocommit" since I didn't read the spec very carefully.
The jca spec indicates that autocommit behavior is required when you are outside a managed transaction and don't explicitly control a app-managed local transaction. However, I'm starting to think perhaps we should include a configuration flag for this, since the jca spec is really talking only about cci connection factories rather than jdbc DataSources. Any other thoughts?
Actually, I don't think it is off. My proof is not in what gets returned by "getAutocommit," but the fact that *Oracle* complains that it's not off when I'm doing certain LOB operations.