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

Explicit commit inside a java procedure makes a dynamic result sets passed out unavailable

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.4.1.3
    • 10.3.3.0, 10.4.1.3
    • JDBC
    • None
    • Regression

    Description

      Repro (Main.java) that shows changed behavior after svn 602991
      (the patch committed for this issue). It seems a regression: (originally from Dag H. Wanvik attached to DERBY-1585)

      An explicit commit inside a stored procedure makes a dynamic result sets passed out unavailable, even if the commit is executed prior to the result set; as in the repro.

      Attachments

        1. Main.java
          3 kB
          Daniel John Debrunner

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-6038 Intermittent failure in LangProcedureTest: cannot drop table because of open ResultSet

          • Major - Major loss of function.
          • Closed

          Activity

            People

              mamtas Mamta A. Satoor
              djd Daniel John Debrunner
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: