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

Network client does not retain the INOUT parameter value change for subsequent execution

    XMLWordPrintableJSON

Details

    • Urgent
    • High Value Fix, Newcomer, Repro attached
    • Embedded/Client difference, Wrong query result

    Description

      If I set a INOUT parameter to a value (say 12.3) and it gets
      modified by the procedure to another value (say 45.6) then on
      the next execution
      of the same CallableStatement, embedded maintains the
      current value (45.6), while network server reverts to the
      former value (12.3).

      This issue was found while converting the test lang/procedure.java. See references to this issue in the converted LangProcedureTest.java

      Attachments

        1. Test_2515.java
          3 kB
          Richard N. Hillegas
        2. derby-2515-01-ac-copyINOUTreturnValues.diff
          24 kB
          Richard N. Hillegas
        3. derby-2515-02-aa-polishCatchBlock.diff
          3 kB
          Richard N. Hillegas

        Issue Links

          Activity

            People

              rhillegas Richard N. Hillegas
              kmarsden Katherine Marsden
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: