Help with Using JOIN - and OrderBy

ms0516 · **Joined:** Tue Apr 22, 2008 8:29 am **Posts:** 3

Code:

select m.n_id, n.n_name, m.seq_no 
from menu m, name d 
where m.n_id=n.n_id
order by n.n_name

which works.

The following code:

Code:

class MenuName {
   int id;
   string name;

   Set menus;
}

class Menu {
   pivate MenuPK primaryKey
}

class MenuPK {
  int seq;
  MenuName menuname;
}

// mapping snippet for Menu (some attributes omitted)

<class name="Menu">
  <composite-id name="PrimaryKey" class="MenuPK">
    <key-property name="seq" .. />
    <key-many-to-one name="menuname" class="MenuName" .. />
  </composite-id>
 ...
</class>

<class name="Menu">
  ..
  <propery name="name" ... />
  <set name="menus">
    <one-to-many class="Menu" .. />  
  </set>
</class>

I tried the following and get error claiming the property "name" cannot be found.

Code:

Criteria c = session.createCriteria(Menu.class)
                   .createAlias("PrimaryKey.menuname", "nm", CriteriaSpecification.INNER_JOIN)
                   .add(Restrictions.like("nm.name", "%Main Menu%"))
                   .addOrder(Order.asc("nm.name"))

It looks like the two tables are not being joined as anticipated.

Am I missing something?

Thanks.

Cameron McKenzie · **Posted:** Thu Jun 05, 2008 11:37 am

Is it returning nm.name not found, or just name? I'm wondering if its an alias problem?

ms0516 · **Joined:** Tue Apr 22, 2008 8:29 am **Posts:** 3

The underlying error is the following:

ORA-00904: "nm_"."n_name": invalid identifier

When looking at the generated SQL, there isn't a join clause.