Hi people...

I need to search with Criteria the Personas with a Cliente relationship...

my tables are

Persona
- id
- nombre

Cliente
- id (Fk of Persona)
- creditLimit

the HBMs are
in Persona
<one-to-one cascade="all-delete-orphan" name="cliente" />
in Cliente
<one-to-one constrained="true" name=persona />

How can I search Personas with a Cliente relationship??

for example
Table Personas
ID nombre
1 uno
2 dos
3 tres

Table Cliente
ID creditLimit
2 100

i need obtain as result only the Persona with Id 2...


Thanks in advance and sorry... my English is pretty poor

Nicolas

Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
ProjectionList proList = Projections.projectionList();
proList.add(Projections.property("propertyname in persona class"));
Criteria c = session.createCriteria(Persona.class);
c.setProjection(proList);
c.addOrder(Order.asc("some property name in persona class"));
List clients = c.createCriteria("Cliente").add(Property.forName("creditLimit").eq("100")).list();
session.getTransaction().commit();
for(Iterator it =
client.iterator();it.hasNext();){
Object[] row = (Object[])it.next();
}

You can change it according to your need :)