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

Need to check transaction status on SQL operations

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • JBossAS-4.2.3.GA
    • JBossAS-4.2.2.GA
    • JCA service
    • None

    Description

      In 4.2.x the transaction timeout rollsback the transaction rather than marking it rollback only.

      This means that for the local transaction datasource the connection has effectively moved onto the next
      transaction.

      Actual code:
      Connection c = datasource.getConnection();
      // tx timeout here
      Statement s = createStatement();
      s.executeUpdate(); // should not work

      Actual Code executed in 4.0.x
      Connection c = pool.getConnection();
      // tx timeout here
      transaction.setRollbackOnly();
      Statement s = createStatement();
      s.executeUpdate();
      tx.rollback(); // Rollsback the update

      Actual Code executed in 4.2.x
      Connection c = pool.getConnection();
      // tx timeout here
      transaction.rollback();
      Statement s = createStatement();
      s.executeUpdate(); // happens "in the next local transaction"

      Attachments

        Issue Links

          blocks

          Feature Request - Feature requests from customers and/or users JBAS-7195 On executing readonly query, WrappedConnection.checkTransactionStatus throws exception when transaction is marked for roll back

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          incorporates

          Bug - A problem that impairs or prevents the functions of the product. JBPAPP-662 Need to check transaction status on SQL operations

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Task - Represents a small unit of work that is not end-user facing. JBAS-5278 Need to check transaction status on SQL operations

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          is related to

          Sub-task - The sub-task of the issue JBAS-5083 Add the transaction active check to the jdbc resource adapter

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              adrian.brock Adrian Brock (Inactive)
              adrian.brock Adrian Brock (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: