Derby
  1. Derby
  2. DERBY-4777

Different behavior in Client and Embedded modes when update on an invalid cursor

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.7.1.1
    • Fix Version/s: 10.7.1.1
    • Component/s: JDBC
    • Labels:
      None
    • Bug behavior facts:
      Embedded/Client difference

      Description

      Consider the sql snippet below:

      create table test(c1 int, c2 int);
      insert into test values(1,1);
      update test set c1=2 where current of jdk4;

      for the 'update' line, we get 'ERROR XJ202: Invalid cursor name 'JDK4'. ' in Client mode, while 'ERROR 42X30: Cursor 'JDK4' not found. Verify that autocommit is OFF.' in Embed mode.

      1. releaseNote.html
        4 kB
        Rick Hillegas
      2. releaseNote.html
        5 kB
        Myrna van Lunteren
      3. derby-4777-releasenote.stat
        0.0 kB
        Yun Lee
      4. derby-4777-releasenote.patch
        2 kB
        Yun Lee
      5. DERBY-4777_b.diff
        3 kB
        Myrna van Lunteren
      6. DERBY-4777_b.stat
        0.3 kB
        Myrna van Lunteren
      7. derby-4777.stat
        0.1 kB
        Yun Lee
      8. derby-4777.patch
        2 kB
        Yun Lee

        Issue Links

          Activity

          Yun Lee created issue -
          Yun Lee made changes -
          Field Original Value New Value
          Status Open [ 1 ] In Progress [ 3 ]
          Yun Lee made changes -
          Attachment derby-4777.patch [ 12452168 ]
          Attachment derby-4777.stat [ 12452169 ]
          Yun Lee made changes -
          Issue & fix info [Patch Available]
          Yun Lee made changes -
          Link This issue is related to DERBY-3801 [ DERBY-3801 ]
          Yun Lee made changes -
          Link This issue is part of DERBY-310 [ DERBY-310 ]
          Myrna van Lunteren made changes -
          Attachment DERBY-4777_b.stat [ 12452352 ]
          Attachment DERBY-4777_b.diff [ 12452353 ]
          Myrna van Lunteren made changes -
          Affects Version/s 10.7.0.0 [ 12314971 ]
          Issue & fix info [Patch Available] [Release Note Needed]
          Dag H. Wanvik made changes -
          Summary perform different in Client and Embed modes when update on an invalid cursor Different behavior in Client and Embedded modes when update on an invalid cursor
          Yun Lee made changes -
          Attachment derby-4777-releasenote.patch [ 12452736 ]
          Attachment derby-4777-releasenote.stat [ 12452737 ]
          Yun Lee made changes -
          Issue & fix info [Release Note Needed] [Patch Available]
          Myrna van Lunteren made changes -
          Attachment releaseNote.html [ 12453149 ]
          Myrna van Lunteren made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Issue & fix info [Patch Available]
          Fix Version/s 10.7.0.0 [ 12314971 ]
          Resolution Fixed [ 1 ]
          Myrna van Lunteren made changes -
          Link This issue is part of DERBY-4609 [ DERBY-4609 ]
          Rick Hillegas made changes -
          Attachment releaseNote.html [ 12459478 ]
          Rick Hillegas made changes -
          Affects Version/s 10.7.1.1 [ 12315564 ]
          Affects Version/s 10.7.1.0 [ 12314971 ]
          Fix Version/s 10.7.1.1 [ 12315564 ]
          Fix Version/s 10.7.1.0 [ 12314971 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12518087 ] Default workflow, editable Closed status [ 12802710 ]

            People

            • Assignee:
              Yun Lee
              Reporter:
              Yun Lee
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development