i have to table players and teams
i have a bidirectional association between the two object

in team mapping file :

<set name="players" cascade=

According to the way Hibernate works, I believe that you can simply do:



This will return a list...which you can traverse:

This way you can go through all the matches.

Someone correct me if I'm wrong. :)

-G

That probably the correct way to do it for most situations, as it allows you to maintain your object-level abstractions.

If you really need/want to be able to "iterator with both instances of Player and Team in each row", then try:

which will return you a result where each row is an Object[] where the first dimension is the player object and the second is the palyer's team.

Or even more succintly, just turn around the perspective of the object query:

from Player p join fetch p.team

would be preferred ;)