hi,

I tried reading the information on the web and hibernate docs but I could not understand how to iterate through a result set in teh following scenario:

I have 2 tables Customers and Orders.

I created 2 POJOs corresponding to those tables.

Now, I would like to execute a query say (in SQL systax)

Select c.name, c.email, o.orderID, o.OrderName from customers c and orders o

How should I iterate through the result set as the result set has data pertaining to both CustomerPOJO and OrderPOJO?

Example, if my query was "from CoustomerPOJO" then, I get teh CustomerPOJO Object from teh List. But in thsi case, its is not just one particular object but its a data from both the objects.

Please let me know if I need to do any additional configuration in the hibernate config file.

Thanks for your help!

One tip: to successfully use H you should try thinking in terms of objects and properties, and not in the terms of records and columns.

Now, lets assume that Order object has property of Customer type and the property is mapped in H mapping files, then the HQL will be

From Order o where o.something = :someparam

Then you probably want just a list of property values and do not want to instantiate all those stinking objects :)

Then HQL will look like:
Select o.property, o.customer.property from Order o where o.something = :someparam

Such query returns list of arrays to iterate through.
http://www.hibernate.org/hib_docs/v3/re ... ing-scalar


and of course you can escape into SQL
http://www.hibernate.org/hib_docs/v3/re ... rysql.html

Hello Konstantin ,

Thanks for taking time to reply. Your tip really helped me in understanding hibernate better than any other document.

Thanks a ton!

Enjoy Hibernate, and do not forget to rate ;)