outer or full join must be followed by path expression ?!

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

I write a simple hibernate query.But get exception

Code:

outer or full join must be followed by path expression

My code is:

Code:

      Session s=HibernateLocalUtil.currentSession();
      Transaction t=s.beginTransaction();
      
            String sql="select p.ProjectCode,a.Name from com.digitalchina.gx.common.bean.PubProStatus p left join com.digitalchina.gx.common.bean.PubApplyProinfo a where p.ProjectCode=a.ApplyCode";
      List list=s.createQuery(sql).list();
      System.out.println("get list: >> "+list);
      

      t.commit();
      HibernateUtil.closeSession();

why this simple code report error? Thks
How to use join query? Help!

kata · **Joined:** Mon Oct 11, 2004 3:51 am **Posts:** 1

I also want to know...[/quote]

ernst_pluess · **Posted:** Tue Dec 21, 2004 4:36 am

try

Code:

select p.ProjectCode,a.Name from com.digitalchina.gx.common.bean.PubProStatus p, com.digitalchina.gx.common.bean.PubApplyProinfo a where p.ProjectCode=a.ApplyCode

ernst_pluess · **Posted:** Tue Dec 21, 2004 5:06 am

BTW:
Joins are supported only for associations managed by hibernate. This means you could get your stuff working by adding the association to the mapping. This would be the path hibernate is asking for.

HTH
Ernst

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

ernst_pluess wrote:

BTW:
Joins are supported only for associations managed by hibernate. This means you could get your stuff working by adding the association to the mapping. This would be the path hibernate is asking for.

HTH
Ernst

Thks ernst_pluess!

You are right! In the previous, my two tables have not any associations.They associate using a column simply. I add associations to mappings and the query works well. It mean that if I use "join", I need have to make Hibernate to know the association with two tables in mapping.

That is exactly what you said.

Code:

Joins are supported only for associations managed by hibernate.

:)

Thks