Details

    • Type: Sub-task Sub-task
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.10.1.1
    • Fix Version/s: 10.10.1.1
    • Component/s: SQL
    • Labels:
      None

      Description

      The table in the Reference Manual topic "Limitations for database values" currently states that the maximum number of parameters in a stored procedure is 90. Should this table row simply be removed? I gather there is no limit any more.

      If I find other references to the limit, I'll fix them too.

      1. rrefdbmlimits.html
        7 kB
        Kim Haase
      2. DERBY-6034.diff
        0.5 kB
        Kim Haase

        Activity

        Hide
        Kim Haase added a comment -

        Closing, since the change has appeared in the Latest Alpha Manuals.

        Show
        Kim Haase added a comment - Closing, since the change has appeared in the Latest Alpha Manuals.
        Hide
        Kim Haase added a comment -

        Thanks, Knut!

        Committed patch DERBY-6034.diff to documentation trunk at revision 1428902.

        I agree that we don't have to duplicate documentation about JVM limits. It is interesting that according to that section in the SE spec, the limit could be less than 255 if some parameters are large in size: "Note that a method descriptor is defined in terms of a notion of method parameter length in which a parameter of type long or double contributes two units to the length, so parameters of these types further reduce the limit." I hope our tests account for that.

        Show
        Kim Haase added a comment - Thanks, Knut! Committed patch DERBY-6034 .diff to documentation trunk at revision 1428902. I agree that we don't have to duplicate documentation about JVM limits. It is interesting that according to that section in the SE spec, the limit could be less than 255 if some parameters are large in size: "Note that a method descriptor is defined in terms of a notion of method parameter length in which a parameter of type long or double contributes two units to the length, so parameters of these types further reduce the limit." I hope our tests account for that.
        Hide
        Knut Anders Hatlen added a comment -

        The patch looks fine to me. +1 to commit.

        There still is a limit on how many parameters a Java method can have, but I don't think we need to document that. Per the Java Virtual Machine Specification, a Java method cannot have more than 255 parameters: http://docs.oracle.com/javase/specs/jvms/se7/html/jvms-4.html#jvms-4.11

        Show
        Knut Anders Hatlen added a comment - The patch looks fine to me. +1 to commit. There still is a limit on how many parameters a Java method can have, but I don't think we need to document that. Per the Java Virtual Machine Specification, a Java method cannot have more than 255 parameters: http://docs.oracle.com/javase/specs/jvms/se7/html/jvms-4.html#jvms-4.11
        Hide
        Kim Haase added a comment -

        Attaching DERBY-6034.diff and rrefdbmlimits.html, showing the modification to rrefdbmlimits.dita.

        I found no other references to this limit in the documentation. Hope this change is correct.

        Show
        Kim Haase added a comment - Attaching DERBY-6034 .diff and rrefdbmlimits.html, showing the modification to rrefdbmlimits.dita. I found no other references to this limit in the documentation. Hope this change is correct.

          People

          • Assignee:
            Kim Haase
            Reporter:
            Kim Haase
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development