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

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 19 weeks, 3 days ago

                  Packages

                  Version Package