Hi,

a simple newbie question for you :-).

I have the following mapping.

-------
<hibernate-mapping package="de.test.hibernate">
<class name="IfdmSysInt" table="IFDM_SYS_INT">
<id name="id" column="ID" type="java.lang.Long">
<generator class="sequence">
<param name="sequence">A_SEQ</param>
</generator>
</id>
<property name="nameA" column="NAME_A" type="java.lang.String" />
<list name="tableBs" table="TABLE_AB" lazy="false" cascade="all-delete-orphan">
<key><column name="A_ID" not-null="true" /></key>
<index column="IDX" />
<many-to-many class="TableB">
<column name="B_ID" not-null="true" />
</many-to-many>
</list>
</class>
</hibernate-mapping>
----------

<hibernate-mapping package="de.test.hibernate">

<class name="tableB" table="TABLE_B">
<id name="id" column="ID" type="java.lang.Long">
<generator class="sequence">
<param name="sequence">B_SEQ</param>
</generator>
</id>

<property name="name" column="NAME" type="java.lang.String" />
<list name="tableAs" table="TABLE_AB" inverse="true" lazy="true">
<key column="B_ID"/>
<index column="IDX" />
<many-to-many class="tableA" column="A_ID"/>
</list>

</class>

</hibernate-mapping>
---

And I like to do something like this with HQL:

"from tableA as a where tableBs.nameB like'%paul%'"

.. which doesn't work. How can I ask for elements in tableBs with name like xyz?

Regards,

Josh

this should be work!



for more infos look at hibernate docu at page 142...

tom