glassfish
  1. glassfish
  2. GLASSFISH-2484

Allow IN Expression to take in collections as parameters

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 9.0pe
    • Fix Version/s: not determined
    • Component/s: entity-persistence
    • Labels:
      None
    • Environment:

      Operating System: All
      Platform: All

    • Issuezilla Id:
      2,484

      Description

      For instance, the query "SELECT i FROM Person i WHERE i.address IN
      (:collection)"
      using setParameter("collection",list)
      where list contains multiple strings Results in
      "IllegalArgumentException: You have attempted to set a value of type class
      java.util.ArrayList for parameter collection with expected type of class
      java.lang.String from query"

      Even though the spec states that the input parameter must "be like the same
      abstract schema type of the state_field_path_expression in type"
      TopLink Essentials could be extended to accept a collection containing valid
      types.

      This might be related to the validation done for gf GLASSFISH-136

        Activity

        Hide
        Tom Mueller added a comment -

        Bulk change to set fix version to "not determined" where the issue is open but the value is for a released version.

        Show
        Tom Mueller added a comment - Bulk change to set fix version to "not determined" where the issue is open but the value is for a released version.

          People

          • Assignee:
            tware
            Reporter:
            chris_delahunt
          • Votes:
            12 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: