Hi there,

I am a newbie to hibernate and was wondering if anyone could help..

I have a SQL statement that goes across a number of views

SELECT ci.CONDITIONITEMID, c.description, ci.DESCRIPTION
FROM REFCONDITIONITEM ci, refcondition c, tradeconditionitem tc
WHERE tc.tradeid = ?
and ci.conditionid = c.conditionid
and ci.conditionitemid = tc.conditionitemid
order by c.entryOrder, ci.entryorder

The result from the query is then used to populate a java Arraylist object and the object is returned.

I need to be able to map all the different columns form the different views to one data access object, say ConditionsDAO.java so that when the user gets hold of this object they have the results of the above query...a bit like the arraylist that it currently generates.

Is this possible to use many-to-one tag to do this? how do you use it to do what I want to do?

If this is really a one-to-many, you can map it as a class A having a Set attribute containing Bs. You can however of course write an HQL query which returns you a array list containing duplicates of your A or an attribute of A if that is what you desire. Hibernate maps Object models, so if you can represent this as a proper OO model, we might be able to tell you how to map it.

I want to be able to return the results of this query as a Java object using hibernate. Does HQL allow you to do something like this?

Yes, it does. If you can't map it properly, use select new, like in:


See the Docs: http://www.hibernate.org/hib_docs/reference/html/query-language.html#query-language-s4

I am not quite sure if I knwo what needs to be done here!!

For instance, where does the HQL statement sit?

What If I want it to return an object called ConditionsDAO? what should the getters and setter for this class do?

I can not quite put the whole picture together!

Please learn how to use Hibernate first, check out the documentation or probably some tutorials frome here: http://www.hibernate.org/78.html.

good idea!