Discussions

EJB programming & troubleshooting: EJB-QL case insensitive search

  1. EJB-QL case insensitive search (1 messages)

    Does anyone know how to build a query in EJB-QL on which a string comparsion is done in a case-insensitive way? I use dynamic queries under BEA Weblogic v.7.0.
  2. EJB-QL case insensitive search[ Go to top ]

    I work with Websphere Application Server 4.0 and DB2 7.1, and in the finder descriptor (ibm-ejb-jar-ext.xmi file for me) says:

    ejbqlQueryString="select e from MyTableBean e where ucase(e.description) = ?1"

    This descriptor turns uppercase the query result, and when calling the finder method I turn uppercase the parameter (?1), so that I'm comparing both strings uppercase.

    Hope it works for you.