Hi All

order.java:-------------------------------------------------------------------------
private int id;
private Date Date;
private int amount;
private customer customer;

@ManyToOne
@JoinColumn(name="customer_id")
public customer getCustomer() {
return customer;
}
public void setCustomer(customer customer) {
this.customer = customer;
}
@Id
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public Date getDate() {
return Date;
}

customer.java-------------------------------------------------------------------------------------------------
private int id;
private String name;
private String address;
private int age,salary;
private List<orders> cus_orders;

@OneToMany(mappedBy = "customer",fetch = FetchType.EAGER)

public List<orders> getCus_orders() {
return cus_orders;
}
public void setCus_orders(List<orders> cus_orders) {
this.cus_orders = cus_orders;
}

@Id
@GeneratedValue
public int getId() {
return id;
}
public void setId(int id) {

FOLLOWING IS THE CODE THAT EXECUTES WITH NO EXCEPTION---------------------------------------------------------------

Criteria crit = session.createCriteria(orders.class).createAlias("customer", "cust").add(Restrictions.eq("amount",1500)).add(Restrictions.eq("cust.name","Kaushik"));
List list = crit.list();
Iterator<orders> itr = list.iterator();
while(itr.hasNext()){
System.out.println("---------------------->>>>>"+ (itr.next()).getCustomer().getName());
}

AND CHANGING THE CRITERIA QUERY OTHER WAY ,I AM GETTING EXCEPTION------------------------------------------
Criteria crit = session.createCriteria(customer.class).createAlias("orders", "ord).add(Restrictions.eq("name","Kaushik")).add(Restrictions.eq("ord.amount",1500));
List list = crit.list();

Here is the exception--------------------------------------------------------------------------------------------

Exception in thread "main" org.hibernate.QueryException: could not resolve property: orders of: Entity.customer
at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:83)
at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:77)
at org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1978)
at org.hibernate.loader.criteria.EntityCriteriaInfoProvider.getType(EntityCriteriaInfoProvider.java:57)
at org.hibernate.loader.criteria.CriteriaQueryTranslator.getPathInfo(CriteriaQueryTranslator.java:245)
at org.hibernate.loader.criteria.CriteriaQueryTranslator.createCriteriaEntityNameMap(CriteriaQueryTranslator.java:229)
at org.hibernate.loader.criteria.CriteriaQueryTranslator.<init>(CriteriaQueryTranslator.java:112)
at org.hibernate.loader.criteria.CriteriaLoader.<init>(CriteriaLoader.java:88)


Please Let me know why I cannot write the query the other way around (the highlighted way)
Waiting for your response

Varun Maheshwari

Hi,


The property is called cus_orders