0 Replies Latest reply on Sep 7, 2004 1:59 PM by vying

    ucase in order by clause in jboss ql

    vying Newbie

      hi all,
      I have a problem using ucase function inside 'order by ' clause.Since Oracle provides similar function as upper and is able to use in order by clause in sql,I am wondering we can achieve this in jboss ql .Thanks

      Following is the error message:

      0:36:16,888 ERROR [EntityContainer] Starting failed
      org.jboss.deployment.DeploymentException: Error compiling JBossQL statement 'SELECT OBJECT(f) from FilterSet f where f.userAcct=?1 and f.mediaTypes=?2 and f.reportType=?3 and f.name <> 'XX--------XX' order by UCASE(f.name)'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "UCASE" at line 1, column 133.
      Was expecting one of:
      <NUMERIC_VALUED_PATH> ...
      <STRING_VALUED_PATH> ...
      <DATETIME_VALUED_PATH> ...
      )
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.(JDBCJBossQLQuery.java:51)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createJBossQLQuery(JDBCCommandFactory.java:71)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:200)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:490)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:388)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152)
      at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:342)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
      at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
      at $Proxy14.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:394)