Hibernate Basic: how to query when there is a composite id

Question

Hi, I have a domain object say, SalesOrder which has a composite id called id, made of salesOrder id and repid which is contained in another class called SalesOrderID(which is serializable and implements equals and hashcode)

my question is when i want to query SalesOrder, session.createSQLQuery("FROM SalesOrder where id=:soID")

and soID is populated with salesorder id and repid. this failes no matter what.

can anyone please help me?

thanks

Answer 1

It most likely fails because you're trying to create an SQL query. You should be using HQL instead:

 Query query = session.createQuery("from SalesOrder so where so.id=:id");
 query.setParameter("id", salesOrderID);
 query.list();

If this was a typo in your question and you are indeed using createQuery() method then please post the exception stack trace.

Answer 2

I had an incorrect mapping in the database beans class. Sorry for all the trouble, learned my lesson, apologize for wasting ur times