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

In Network server, rollback inside a java procedure does not close the resultsets created before the call to the java procedure.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1
    • None
    • Network Server
    • Normal
    • Embedded/Client difference

    Description

      Inside network server framework, if there is java procedure will rollback inside it, the rollback does not close the resultsets that were created before the call to java procedure was made. This happens in trunk, 10.3 and 10.2 codelines. I haven't tried earlier versions of Derby. In embedded mode, the resultsets (created before the call to java procedure) get closed when the rollback is done inside the java procedure.

      I will soon attach a standalone test case for this behavior.

      Attachments

        1. test_rollback_in_procedure.java
          6 kB
          Mamta A. Satoor

        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

              Unassigned Unassigned
              mamtas Mamta A. Satoor
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: