Help:about outer join in HQL

Kisses99 · **Joined:** Wed Feb 25, 2004 12:13 am **Posts:** 2

Code:

net.sf.hibernate.QueryException: outer or full join must be followed by path expression [select contact.coi_name,client.cli_cncompanyname from  net.isquare.imiracle.client.po.ContactInfoPO as contact  join net.isquare.imiracle.client.po.ClientInfoPO as client on contact.client.cli_id=client.cli_id]

Code:

Query q = session.createQuery("select contact.coi_name,client.cli_cncompanyname from  net.isquare.imiracle.client.po.ContactInfoPO as contact  join net.isquare.imiracle.client.po.ClientInfoPO as client on contact.client.cli_id=client.cli_id");// where 1=1" + queryStr);

clientinfo hbm:

Code:

<set name="contact" lazy="true" inverse="true" cascade="all" >
   <key column="cli_id"/>
   <one-to-many class="net.isquare.imiracle.client.po.ContactInfoPO"/>
</set>

contactinfo hbm:

Code:

<many-to-one name="client" class="net.isquare.imiracle.client.po.ClientInfoPO" >
 <column name="cli_id"/>
</many-to-one> 
      

emmanuel · **Posted:** Wed Feb 25, 2004 8:21 am

Code:

select contact.coi_name,client.cli_cncompanyname from  net.isquare.imiracle.client.po.ContactInfoPO as contact  join contact.client as client

Kisses99 · **Joined:** Wed Feb 25, 2004 12:13 am **Posts:** 2

no use, the exception persists

emmanuel · **Posted:** Thu Feb 26, 2004 7:09 am

Did it in the wrong side

Code:

select contact.coi_name,client.cli_cncompanyname from  net.isquare.imiracle.client.po.ClientInfoPO as client join client.contact as contact