Find by other property than PK ?

[mn]

Hello

I want to find objects releted to other object by many-to-one relationship, but not by PK, but some other prooperty, like this:

hibernate mapping for Cities object:

<many-to-one name="land"
class="Lands"
column="LAND_CODE"
property-ref="code"
not-null="true"/>

here's the code:

int count = ((Integer) getHibernateTemplate()
.iterate("select count(*) from Cities c where c.land=?", land.getCode())
.next()).intValue();

and if i store city with property land, it nicely stores land.code in LAND_CODE column, but in finders i have to do "....where c.land=?', land.getCode()...", becouse "....where c.land=?', land..." doesn't work as it should. any suggestions ?
thanks in advance
tom

[s100w]

Try something like:

public int getWipCountFor(final Land land) {
  Integer count = (Integer) getHibernateTemplate().execute(new HibernateCallback() {
    public Object doInHibernate(Session session) throws HibernateException, SQLException {
      Query query = session.createQuery("select count(*) from Cities c where c.land = :land");
      query.setParameter("land", land);
      return query.uniqueResult();
    };
  });
  return count.intValue();
}

[Ryan.Stone]

becouse "....where c.land=?', land..." doesn't work as it should.

What exactly is the problem you're running into? I do the exact same thing in my code and it works fine for me.