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.

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1
    • Fix Version/s: None
    • Component/s: Network Server
    • Urgency:
      Normal
    • Bug behavior facts:
      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.

        Issue Links

          Activity

          Hide
          Dag H. Wanvik added a comment -

          We should update LangProcedureTest when this issue is fixed; with the the client driver we skip a test case due to this issue.

          Show
          Dag H. Wanvik added a comment - We should update LangProcedureTest when this issue is fixed; with the the client driver we skip a test case due to this issue.
          Hide
          Tiago R. Espinha added a comment -

          Triaged for 10.5.2.

          Assigned normal urgency and checked Embedded/Client difference.

          Show
          Tiago R. Espinha added a comment - Triaged for 10.5.2. Assigned normal urgency and checked Embedded/Client difference.
          Hide
          Mamta A. Satoor added a comment -

          Added a junit test case for this behavior. The test went into trunk(revision 627673) and 10.3 codeline(revision 627674).

          The test case runs in embedded mode to show the correct behavior for rollback inside a java procedure causing all the resultsets to close. The test case for now has been commented out for network server mode and it should be enabled when this jira entry is fixed.

          Show
          Mamta A. Satoor added a comment - Added a junit test case for this behavior. The test went into trunk(revision 627673) and 10.3 codeline(revision 627674). The test case runs in embedded mode to show the correct behavior for rollback inside a java procedure causing all the resultsets to close. The test case for now has been commented out for network server mode and it should be enabled when this jira entry is fixed.
          Hide
          Mamta A. Satoor added a comment -

          This test program in it's current state is coded to run in Network server mode and one can see from the output of the test run that resultsets are left open after the rollback

          • Testing with jdbc:derby://localhost:1527/c:/dellater/db;create=true
            rs1 still open???????
            resultSet still open???????

          When the code is changed so it is run in embedded mode, the output is as follows which shows the expected behavior of resultset closing because of the rollback inside the java procedure

          • Testing with org.apache.derby.jdbc.EmbeddedDriver
            closed as expected rs1
            closed as expected resultSet
          Show
          Mamta A. Satoor added a comment - This test program in it's current state is coded to run in Network server mode and one can see from the output of the test run that resultsets are left open after the rollback Testing with jdbc:derby://localhost:1527/c:/dellater/db;create=true rs1 still open??????? resultSet still open??????? When the code is changed so it is run in embedded mode, the output is as follows which shows the expected behavior of resultset closing because of the rollback inside the java procedure Testing with org.apache.derby.jdbc.EmbeddedDriver closed as expected rs1 closed as expected resultSet

            People

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

              Dates

              • Created:
                Updated:

                Development