Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-1895

ANN-823 - Unit tests fail because Insert into ... values(upper(?)) fails on DB2

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: EAP 5.0.0, 4.2.0.GA_CP08, 4.3.0.GA_CP07, EAP 5.0.1.CR1, EAP 5.0.1.CR2, EAP 5.0.1, 4.2.0.GA_CP09, 4.3.0.GA_CP08
    • Component/s: Hibernate
    • Labels:
      None
    • Environment:

      DB2 V91

    • Affects:
      Release Notes
    • Workaround Description:
      Hide

      The solution is to use a CAST around the parameter marker to tell DB2 what
      type to expact. For example:
      UPPER(CAST(? AS CHAR(10))
      UPPER(CAST(? AS VARCHAR(50))
      The Db2 knows what type to use for the parameter marker and the function can
      be properly resolved.

      http://bytes.com/topic/db2/answers/182742-sql0418n-error-untyped-parameter-markers-cannot-used-some-cases

      Show
      The solution is to use a CAST around the parameter marker to tell DB2 what type to expact. For example: UPPER(CAST(? AS CHAR(10)) UPPER(CAST(? AS VARCHAR(50)) The Db2 knows what type to use for the parameter marker and the function can be properly resolved. http://bytes.com/topic/db2/answers/182742-sql0418n-error-untyped-parameter-markers-cannot-used-some-cases
    • Release Notes Docs Status:
      Not Required

      Gliffy Diagrams

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jaredmorgs Jared Morgan
                Reporter:
                gbadner Gail Badner
                Writer:
                Jared Morgan
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: