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

JBoss/JCA JDBC implementation should allow for Transaction isolation level to be reset on underlying JDBC connection prior to return to pool

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Obsolete
    • Icon: Minor Minor
    • No Release
    • None
    • JCA service
    • None

      By default, when we return a JDBC connection to the pool we execute the following in the ManagedConnection.cleanup() method:

      if (jdbcTransactionIsolation != transactionIsolation)
      {
      try

      { con.setTransactionIsolation(jdbcTransactionIsolation); jdbcTransactionIsolation = transactionIsolation; }

      catch (SQLException e)

      { mcf.log.warn("Error resetting transaction isolation ", e); }

      }

      In this scenario we don't return the original isolation level on the underlying connection. The spec doesn't prohibit this, and I can't see any reason why we shouldn't do this, or provide a configurable option.

              Unassigned Unassigned
              weston.price Weston M. Price (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: