Uploaded image for project: 'Application Server 3  4  5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-397

Can't set SERIALIZABLE transaction isolation with Oracle XA

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Obsolete
    • Optional
    • JBossAS-4.0.5.GA
    • None
    • JCA service
    • 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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            sourceforge-user SourceForge legacy user (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: