I'm using "named parameters" and the method Query.setProperties to bind variables in SQL statement.
This method doesn't bind the components of my persistent object but only the properties.
Is this Correct? Is there another way to bind dynamically the components and properties without having to bind manually each variables (obviously not with setString(String name, String val), setInteger(String name, String val)..., I know that) ?

Could you give an example of what you are using this for?

// my persistent object
public class PersistentObject implements Serializable {
// my property
private String prop;

// my component
private Period period



public String getProp() {...};
public void setProp(String prop) {...};

public Period getPeriod() {...};
public void setPeriod(Period period) {...};

...

}

// my component
public class Period implements Serializable {
private Date begin;
private Date end;

public Date getBegin() {...};
public void setBegin(Date d) {...};

public Date getEnd() {...};
public void setEnd(Date d) {...};

...

}

// Data access object (DAO):
PersistentObjectDAO {
...
public static List search(PersistentObject po) {
...
// open an hibernate session
Session session = factory.openSession();
String sql = "from PersistentObject as p where p.prop = :prop and p.period.begin = :period.begin and p.period.end = :period.end";

Query query = session.createQuery(sql);
query.setMaxResults(20);
query.setFirstResult(100);

// bind all properties dynamically
query.setProperties(po);

// Now I must bind the components "not dynamically"
query.setDate("period.begin", po.getPeriod.getBegin());
query.setDate("period.end", po.getPeriod.getEnd());

...
List result = query.list();
...
return result;
}
...
}

Is there another way to bind "dynamically" the components?

No :)

Thank you

Lorenzo

You might want to take a look at the Query by Example system in section 14.6 of the Hibernate Reference. I think that this does what you're looking for.

Also, check out setProperties(Object bean) method in Query -

Bind the property values of the given bean to named parameters of the query, matching property names with parameter names and mapping property types to Hibernate types using hueristics.