<dynamic-component> in HQL Query

alexism · **Joined:** Thu Feb 16, 2006 9:53 am **Posts:** 24

Hi all,

I'm using a dynamic-component and I would like to know how to write query on it.

Actually, my class is:

Code:

class A{
  string name;
  Map dynamicMap; 
}

The keys contained by the map are defined at runtime.
Let's assume that we have a FOO_KEY, how can I write a query with a clause on this key.

Per example, what is the HQL for :

Code:

select * from A where FOO_COL='test'

I tried in vain:

Code:

"from A where dynamicMap.FOO_KEY = :value"

Thanks for your help.

Alexis

Hibernate version: 3.1.2

kgignatyev · **Posted:** Fri Feb 17, 2006 1:23 pm

FOO_KEY should be declared in the mapping per
http://www.hibernate.org/hib_docs/v3/re ... ts-dynamic

For example the mapping:
<class lazy="false" name="ClassWithDynaComp" table="dyna_clomp_holder">
<id name="name">
<generator class="assigned"/>
</id>
<dynamic-component name="dynamicMap" >
<property name="aa" column="aa" type="string"/>
</dynamic-component>
</class>

Allows this query:
s.createQuery( "from ClassWithDynaComp where dynamicMap.aa LIKE '%'")