ejbql

case-insensitive search in EJB QL

Hello, This looks really simple and I can't believe I haven't found a solution myself. I have a bean named PersonBean, which has a name. Now I want to write a finder method that takes a string and looks for people with that string in their name, case-insensitively. Here is my current EJB QL: SELECT OBJECT(p) FROM Person p WHERE (p.name...

Why isn't this EJBQL query validated by JBoss 5?

Hello, I am migrating an existing application from Weblogic server 9 to JBoss 5. My problem is with a query that has a character condition in the WHERE clause, like this one: SELECT DISTINCT OBJECT(myObject) FROM MyObject myObject WHERE myObject.myAttribute = 'F' ... which I believe was working with WLS now leads to an aborted dep...