craig hollinshead

Using the ASCII escape codes (> for greater than, < for less than) will fix the XML incompatibility with the greater/less than signs in the filter:

<filter name="limitCategoryTalksByDaterange" condition="talkstart &#62;= :tstart and talkstart &#60;= :tend" />

How can greater than or less than symbols be added to the condition on a Hibernate filter specified in the hbm.xml file?

I am trying to add a filter to limit the collection to a specific date range:

<filter name="limitTalksByDateRange" condition="talkstart >= :tstart and talkstart <= :tend" />

Unfortunately this breaks the XML parsing. I've tried backslash-escaping, "ge" and "le" and even "between :tstart and "tend" which is mentioned in the Hibernate documentation. None has worked.

I'm trying to define a collection filter on a set that will allow items in the list to be filtered by a list of valid audience values (integers). In regular HQL I have this working by passing a List<Integer> to the query by converting an array of Integer values:

qy.setParameterList("aud",Arrays.asList(audiences));

But now I'm trying to define a collection filter on a set of items returned in another object, and I can't figure out what data type to define on in filter-param type field. I've tried several variations (java.util.List, java.lang.Integer, List<Integer>, Integer, etc) to no avail. Any suggestions would be greatly appreciated.

Here's the mapping file:

<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="com.foo.hibernate.Event" table="event" catalog="webcast"> <id name="id" type="java.lang.Long"> <column name="id" /> <generator class="identity" /> </id> <property name="title" type="java.lang.String"> <column name="title" not-null="true" /> </property> <property name="description" type="java.lang.String"> <column name="description" length="2048" /> </property> <property name="eventstart" type="java.sql.Timestamp"> <column name="eventstart" length="19" /> </property> <property name="eventend" type="java.sql.Timestamp"> <column name="eventend" length="19" /> </property> <property name="type" type="java.lang.Integer"> <column name="type" /> </property> <property name="rssurl" type="java.lang.String"> <column name="rssurl" length="2048" /> </property> <property name="audience" type="java.lang.Integer"> <column name="audience" /> </property> <property name="audgroupid" type="java.lang.Integer"> <column name="audgroupid" /> </property> <set name="talks" inverse="true" order-by="talkstart desc"> <key> <column name="eventid" /> </key> <one-to-many class="com.foo.hibernate.Talk" /> <filter name="audienceFilter" condition="audience in (:aud)" /> </set> </class> <!-- filters --> <filter-def name="audienceFilter"> <filter-param name="aud" type="java.lang.Integer" /> </filter-def> </hibernate-mapping>