Hello all,

This is the setup: In my Document object, I have a collection (title) which consists of String map keys and String values. The object is stored on a database via a hibernate 3 persistence:

<class name="Document" table="WG_DOCUMENTOS">
<cache usage="read-write"/>
<id name="id" type="java.lang.Integer">
<generator class="increment"/>
</id>
<property name="fecha_creacion"/>
<map name="title" table="WG_DOCUMENTOS_TITULOS">
<key column="DOC"/>
<map-key type="java.lang.String" column="LANG"/>
<element type="text" column="TITLE"/>
</map>
</class>

I need to get the Document objects with a title like a given string. I can do it with "where ? in elements(title)", but I need to use a ilike comparison (case insensitive and %-pattern-matching). How do I do that in HQL? any clue? I'm new to HQL and it looks so powerful that it's hard to fully understand its principles..

HQL doesn't support ilike. Criteria do, but not HQL. This is how to do it in HQL:Then you just have to use qry.setString(searchTitle.toLowerCase());

Thanks..

If it's not a big deal, how would you handle that same query with criteria querys?

Something along these lines: