0 Replies Latest reply on Nov 24, 2002 10:27 AM by Dzidas

    How implement posgresql ILIKE function?

    Dzidas Newbie

      Hello,
      I use JBoss 3.0, CMP 2, PostgreSQL.
      I wrote find method and this method using LIKE.
      But LIKE is case-sensitive in Posgresql. Another command is ILIKE and it is case-insensitive.
      But when I try insert this function in jbosscmp-jdbx.xml, I will get error.

      2002-11-24 15:50:35,439 ERROR [org.jboss.ejb.EjbModule] Starting failed
      org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "ILIKE" at line 2, column 71.
      Was expecting one of:
      "=" ...
      "" ...
      )
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.(JDBCJBossQLQuery.java:46)

      Can I solve this problem and use ILIKE or ~*?
      Thanks