Details
-
Feature Request
-
Resolution: Obsolete
-
Optional
-
None
-
None
Description
SourceForge Submitter: igorfie .
This is not a bug report per se, but I could not find any
better place for such information.
Problem as observed by JBoss users: JBoss 3.2 and
4.0 do not allow setting SERIALIZABLE transaction
isolation level for Oracle XA datasources.
Root cause of this is incompatible Oracle JDBC driver
(surprise, surprise).
There seems to be no way to set SERIALIZABLE tx
isolation level with Oracle 8i JDBC drivers.
To start SERIALIZABLE tx using Oracle JDBC driver
v9.2.0.1 one need to:
XADataSource ds = ...;
XAConnection mc = ds.getXAConnection();
XAResource xares = mc.getXAResource();
xares.start(xid, XAResource.TMNOFLAGS |
oracle.jdbc.xa.OracleXAResource.ORATMSERIALIZABL
E);
Note not-standard parameter passed to
XAResource.start and that
Connection.setTransactionIsolation(int) should not be
called with Oracle XA drivers.
I do not have any immediate plans to implement this.