Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3579

The Developer's Guide incorrectly describes the behavior of transactions inside procedures and functions

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.2.1
    • Fix Version/s: 10.4.2.0, 10.5.1.1
    • Component/s: Documentation
    • Labels:
      None

      Description

      The "Programming database-side JDBC procedures" section of the Developer's Guide misleads users about how transactions can be managed inside database procedures. For instance, the section titled "Invoking a procedure using the CALL command" says the following: "Procedures that use nested connections, on the other hand, are not permitted to commit or roll back and can therefore be rolled back after the calling statement." This is not true. User-coded procedures can issue both commit() and rollback() on the nested connection bound to the "jdbc:default:connection" URL and those methods have the desired behavior. The whole "Programming database-side JDBC procedures" section could use an overhaul since it appears to make other misleading statements about the behavior of transactions inside routines. Thanks to Dag for pointing out the following email thread: http://www.nabble.com/Transaction-Problems-of-a-Derby-Stored-Procedure-td15494178.html

        Attachments

        1. DERBY-3579.diff
          2 kB
          Camilla Haase
        2. DERBY-3579.zip
          4 kB
          Camilla Haase
        3. DERBY-3579-2.diff
          19 kB
          Camilla Haase
        4. DERBY-3579-2.stat
          0.5 kB
          Camilla Haase
        5. DERBY-3579-2.zip
          28 kB
          Camilla Haase
        6. DERBY-3579-3.diff
          19 kB
          Camilla Haase
        7. DERBY-3579-3.zip
          28 kB
          Camilla Haase
        8. z.java
          0.6 kB
          Richard N. Hillegas

          Activity

            People

            • Assignee:
              chaase3 Camilla Haase
              Reporter:
              rhillegas Richard N. Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: