glassfish
  1. glassfish
  2. GLASSFISH-481

add query hint to disable jpql validation

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • 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:
      481

      Description

      There are some restrictions to jpql in the EJB 3.0 persistence specification
      for the query language that disallow some things that will work on some
      databases. As a result, JPQL validation will disallow writing queries that
      could provide correct results on certain databases.

      An example is: IN

      From the spec:

      in_expression ::=
      state_field_path_expression [NOT] IN ( in_item

      {, in_item}

      * | subquery)
      in_item ::= literal | input_parameter
      The state_field_path_expression must have a string, numeric, or enum value

      On an Oracle database IN can be used with Dates. With a hint to disable
      validation, it would be possible to write a JPQL query that would correctly
      return values that used an IN with a Date.

        Activity

        tware created issue -
        Hide
        marina vatkina added a comment -

        Reassigned

        Show
        marina vatkina added a comment - Reassigned
        kenaiadmin made changes -
        Field Original Value New Value
        issue.field.bugzillaimportkey 481 32085
        Hide
        Tom Mueller added a comment -

        Bulk update to change fix version to "not determined" for all issues still open but with a fix version for a released version.

        Show
        Tom Mueller added a comment - Bulk update to change fix version to "not determined" for all issues still open but with a fix version for a released version.
        Tom Mueller made changes -
        Fix Version/s not determined [ 11149 ]
        Fix Version/s 9.0pe [ 10971 ]

          People

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

            Dates

            • Created:
              Updated: