if use such mapping

<!-- bi-directional one-to-one association to PigeonholeRule -->
<one-to-one
name="pigeonholeRule"
class="com.fjky.xfile.core.orm.PigeonholeRule"
outer-join="auto"
/>


I can use hql as where XClass.PigeonholeRule.symbol<>'none'


if use such mapping, how to write hql????

<set name="setOfPigeonholeRule">
<key>
<column name="XTYPE_SYMBOL" length="16" not-null="false"
unique="true" />
</key>

<one-to-many
class="com.fjky.xfile.core.orm.PigeonholeRule" />
</set>

SQL:

select xource.* from xource
join xtype on xtype.symbol= xource.xtype_symbol
join pigeonhole_rule on pigeonhole_rule.xtype_symbol=xtype.symbol
join pigeonhole_type on pigeonhole_rule.pigeonhole_type_symbol=pigeonhole_type.symbol
where pigeonhole_type.symbol<>'none'
and xource.uid not in (select xfile.uid from xfile)


HQL:

StringBuffer hql = new StringBuffer("from Xource xource");
hql.append(" join xource.xtype xtype ");
hql.append(" join xtype.setOfPigeonholeRule pigeonholeRule ");
hql.append(" join pigeonholeRule.pigeonholeType pigeonholeType ");
hql.append(" where (xource.uid not in (select xfile.uid from Xfile xfile)) ");
hql.append(" and (pigeonholeType.symbol<>'none') ");


after join , I can't get any data. why?

what 's the problem?

I want only return Xource objects

under conditions

hql.append(" where (xource.uid not in (select xfile.uid from Xfile xfile)) ");
hql.append(" and (pigeonholeType.symbol<>'none') ");

how to?