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