Hi,
i have been learning Hibernate for the couple of days and trying to create a sample application
but have stumbled onto an issue for which i couldn't find any answers( even after searching the forums).

Problem:

the following query joins two tables and return the results.



Hibernate Query executed at the backend


Now my issue is how to iterate though the result obtained ?
i cannot cast the list to particular domain object as it returns data from both the entities.
please help!

Your query should return a List of Student objects. In your Student object you would have a variable of type Standard, and you could define the relationship like this

Account {
...
@OneToOne(fetch=FetchType....)
@JoinColumn(name="id", nullable=true)
private Standard standard;
...
}

(Your Standard class would also need to be an entity)

As you iterate through the returned student objects, you can access student.getStandard() and it will have been populated (assuming your FetchType is EAGER or you are still within the current transaction.