Hibernate. Get object by associated one

[ctapobep]

I have class Game that has collection of players. This snippet is from Game.hbm.xml:

        <set name="players" access="property" table="players" cascade="all">
            <key column="game_id"/>
            <one-to-many class="Player"/>
        </set>

How can I get Game if I have one of its players? I use HibernateTemplate, maybe it has any handy methods for this purpose?

[denis.zhdanov]

I have class Game that has collection of players. This snippet is from Game.hbm.xml:

        <set name="players" access="property" table="players" cascade="all">
            <key column="game_id"/>
            <one-to-many class="Player"/>
        </set>

How can I get Game if I have one of its players? I use HibernateTemplate, maybe it has any handy methods for this purpose?

You're talking about bidirectional association here. I.e. if there is no 'Player -> Game' association neither spring nor hibernate can help you there.

[ctapobep]

Congratulate me! I made it!
Here it is:

        criteria.add(Restrictions.sqlRestriction(
                "{alias}.id=(select game_id from players where players.id=" + player.getId() +")"));