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