I have system datasource (to oracle database, non-xa driver), and I'm developing custom security providers (authentication and role mapping) that need to access database and do some work in transaction.
How should I work with transactions in security providers?
1. Use setAutoCommit(false) on Connection instance and manually call commit and rollback methods?
or 2. Can I obtain UserTransaction object from JNDI and handle transaction with it?
or 3. There is some other way to do that (maybe some custom Weblogic API for this case)?