Hibernate Community • View topic - ManyToMany Query how to ?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

ManyToMany Query how to ?

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

muncher

Post subject: ManyToMany Query how to ?

Posted: Wed Jul 07, 2010 6:40 pm

Newbie

Joined: Wed Jul 07, 2010 6:33 pm
Posts: 6

I have the following mapping

Code:

<class name="system" table="system" catalog="dbx">
....
....
 <set name="platform" inverse="true" lazy="true" table="platformsystemmap" fetch="select">
            <key>
                <column name="system_id" not-null="true" />
            </key>
            <one-to-many class="platformsystemmap" />
        </set>
....
....
</class>

How do I write a query to retrieve all the systems with platform with some id y ?

Top

muncher

Post subject: Re: ManyToMany Query how to ?

Posted: Wed Jul 07, 2010 6:41 pm

Newbie

Joined: Wed Jul 07, 2010 6:33 pm
Posts: 6

In general how do I write a query if a table has many-to-many mapping ?

Top

Milo

Post subject: Re: ManyToMany Query how to ?

Posted: Thu Jul 08, 2010 2:48 am

Newbie

Joined: Thu Aug 20, 2009 3:00 am
Posts: 11

Something like?:

SELECT s FROM System s JOIN s.platform p WHERE p.id=:y

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum