Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-47444

Service builder array query parameters are not handled well on all database servers

    Details

    • Fix Priority:
      4

      Description

      When there's an array parameter for the service builder finders, the queries might become too "complex" for some of the database servers.

      LPS-44007 is fixing the limitation of SQL Server (max. 2000 query parameter), however the change makes Oracle to be limited to 1000 array elements.

      The ideal solution might be to cut the in clause into multiple ones with directly added values, but it needs to be evaluated on other database servers (and it's only working on int parameters for security reason).

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              miguel.pastor Miguel Ángel Pastor Olivar (Inactive)
              Reporter:
              zsolt.balogh Zsolt Balogh
              Participants of an Issue:
              Recent user:
              Esther Sanz
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                4 years, 33 weeks ago

                  Packages

                  Version Package