jUDDI
  1. jUDDI
  2. JUDDI-785

find with CASE_INSENSITIVE_SORT throws JPA exception

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.2
    • Component/s: core
    • Labels:
      None

      Description

      JUDDI_764caseInsensitiveSortTModelKey(org.apache.juddi.v3.tck.UDDI_070_FindEntityIntegrationTest) Time elapsed: 0.066 sec <<< ERROR!
      javax.xml.ws.soap.SOAPFaultException: "Encountered "upper" at character 670, but expected: ["AVG", "COUNT", "KEY", "MAX", "MIN", "SUM", "VALUE", <IDENTIFIER>]." while parsing JPQL "select t from Tmodel t where 1=1 and t.entityKey in ( ?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17, ?18, ?19, ?20, ?21, ?22, ?23, ?24, ?25, ?26, ?27, ?28, ?29, ?30, ?31, ?32, ?33, ?34, ?35, ?36, ?37, ?38, ?39, ?40, ?41, ?42, ?43, ?44, ?45, ?46, ?47, ?48, ?49, ?50, ?51, ?52, ?53, ?54, ?55, ?56, ?57, ?58, ?59, ?60, ?61, ?62, ?63, ?64, ?65, ?66, ?67, ?68, ?69, ?70, ?71, ?72, ?73, ?74, ?75, ?76, ?77, ?78, ?79, ?80, ?81, ?82, ?83, ?84, ?85, ?86, ?87, ?88, ?89, ?90, ?91, ?92, ?93, ?94, ?95, ?96, ?97, ?98, ?99, ?100, ?101, ?102, ?103, ?104, ?105, ?106, ?107, ?108, ?109, ?110, ?111, ?112, ?113, ?114, ?115, ?116, ?117, ?118, ?119) order by upper(t.name) asc, t.modified desc". See nested stack trace for original parse error.

      FindTModel fb = new FindTModel();
      fb.setAuthInfo(authInfoJoe);
      fb.setFindQualifiers(new FindQualifiers());
      fb.getFindQualifiers().getFindQualifier().add(UDDIConstants.CASE_INSENSITIVE_SORT_TMODEL);
      fb.getFindQualifiers().getFindQualifier().add(UDDIConstants.APPROXIMATE_MATCH);
      fb.setName(new Name(UDDIConstants.WILDCARD, null));
      inquiry.findTModel(fb);

        Issue Links

          Activity

          Alex O'Ree created issue -
          Alex O'Ree made changes -
          Field Original Value New Value
          Description JUDDI_764caseInsensitiveSortTModelKey(org.apache.juddi.v3.tck.UDDI_070_FindEntityIntegrationTest) Time elapsed: 0.066 sec <<< ERROR!
          javax.xml.ws.soap.SOAPFaultException: "Encountered "upper" at character 670, but expected: ["AVG", "COUNT", "KEY", "MAX", "MIN", "SUM", "VALUE", <IDENTIFIER>]." while parsing JPQL "select t from Tmodel t where 1=1 and t.entityKey in ( ?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17, ?18, ?19, ?20, ?21, ?22, ?23, ?24, ?25, ?26, ?27, ?28, ?29, ?30, ?31, ?32, ?33, ?34, ?35, ?36, ?37, ?38, ?39, ?40, ?41, ?42, ?43, ?44, ?45, ?46, ?47, ?48, ?49, ?50, ?51, ?52, ?53, ?54, ?55, ?56, ?57, ?58, ?59, ?60, ?61, ?62, ?63, ?64, ?65, ?66, ?67, ?68, ?69, ?70, ?71, ?72, ?73, ?74, ?75, ?76, ?77, ?78, ?79, ?80, ?81, ?82, ?83, ?84, ?85, ?86, ?87, ?88, ?89, ?90, ?91, ?92, ?93, ?94, ?95, ?96, ?97, ?98, ?99, ?100, ?101, ?102, ?103, ?104, ?105, ?106, ?107, ?108, ?109, ?110, ?111, ?112, ?113, ?114, ?115, ?116, ?117, ?118, ?119) order by upper(t.name) asc, t.modified desc". See nested stack trace for original parse error.
          JUDDI_764caseInsensitiveSortTModelKey(org.apache.juddi.v3.tck.UDDI_070_FindEntityIntegrationTest) Time elapsed: 0.066 sec <<< ERROR!
          javax.xml.ws.soap.SOAPFaultException: "Encountered "upper" at character 670, but expected: ["AVG", "COUNT", "KEY", "MAX", "MIN", "SUM", "VALUE", <IDENTIFIER>]." while parsing JPQL "select t from Tmodel t where 1=1 and t.entityKey in ( ?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17, ?18, ?19, ?20, ?21, ?22, ?23, ?24, ?25, ?26, ?27, ?28, ?29, ?30, ?31, ?32, ?33, ?34, ?35, ?36, ?37, ?38, ?39, ?40, ?41, ?42, ?43, ?44, ?45, ?46, ?47, ?48, ?49, ?50, ?51, ?52, ?53, ?54, ?55, ?56, ?57, ?58, ?59, ?60, ?61, ?62, ?63, ?64, ?65, ?66, ?67, ?68, ?69, ?70, ?71, ?72, ?73, ?74, ?75, ?76, ?77, ?78, ?79, ?80, ?81, ?82, ?83, ?84, ?85, ?86, ?87, ?88, ?89, ?90, ?91, ?92, ?93, ?94, ?95, ?96, ?97, ?98, ?99, ?100, ?101, ?102, ?103, ?104, ?105, ?106, ?107, ?108, ?109, ?110, ?111, ?112, ?113, ?114, ?115, ?116, ?117, ?118, ?119) order by upper(t.name) asc, t.modified desc". See nested stack trace for original parse error.

           FindTModel fb = new FindTModel();
                          fb.setAuthInfo(authInfoJoe);
                          fb.setFindQualifiers(new FindQualifiers());
                          fb.getFindQualifiers().getFindQualifier().add(UDDIConstants.CASE_INSENSITIVE_SORT_TMODEL);
                          fb.getFindQualifiers().getFindQualifier().add(UDDIConstants.APPROXIMATE_MATCH);
                          fb.setName(new Name(UDDIConstants.WILDCARD, null));
                          inquiry.findTModel(fb);
          Alex O'Ree made changes -
          Component/s core [ 12312646 ]
          Alex O'Ree made changes -
          Link This issue relates to JUDDI-786 [ JUDDI-786 ]
          Alex O'Ree made changes -
          Link This issue relates to JUDDI-766 [ JUDDI-766 ]
          Alex O'Ree made changes -
          Fix Version/s 3.2.1 [ 12325541 ]
          Fix Version/s 3.2 [ 12314000 ]
          Alex O'Ree made changes -
          Summary find tmodel with CASE_INSENSITIVE_SORT_TMODEL throws JPA exception find with CASE_INSENSITIVE_SORT throws JPA exception
          Alex O'Ree made changes -
          Fix Version/s 3.2 [ 12314000 ]
          Fix Version/s 3.2.1 [ 12325541 ]
          Alex O'Ree made changes -
          Link This issue relates to OPENJPA-1817 [ OPENJPA-1817 ]
          Kurt T Stam made changes -
          Link This issue is blocked by OPENJPA-1817 [ OPENJPA-1817 ]
          Alex O'Ree made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Won't Fix [ 2 ]
          Alex O'Ree made changes -
          Resolution Won't Fix [ 2 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          Kurt T Stam made changes -
          Status Reopened [ 4 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Alex O'Ree made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Alex O'Ree made changes -
          Link This issue relates to JUDDI-764 [ JUDDI-764 ]
          Alex O'Ree made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Assignee Kurt T Stam [ kstam ] Alex O'Ree [ spyhunter99 ]
          Resolution Fixed [ 1 ]
          Kurt T Stam made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

            People

            • Assignee:
              Alex O'Ree
              Reporter:
              Alex O'Ree
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development