Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-356

DB2 requires CASTs when parameters appear in SELECT clause

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.9.0, 0.9.6, 0.9.7, 1.0.0
    • 1.0.1, 1.1.0
    • jdbc
    • None
    • Kodo JDO

    Description

      When executing a query that selects a literal value, OpenJPA converts the literal into a parameter in the SQL SELECT clause. In DB2, such parameters must be CAST to the appropriate type.

      Note that this is not reproducible via OpenJPA's JPA bindings, as JPQL does not allow literals in the SELECT clause. However, the OpenJPA query parse trees do allow this syntax, and Kodo's JDO bindings allow such constructs.

      Attachments

        Activity

          People

            Unassigned Unassigned
            pcl Patrick Linskey
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: