HQL Query using a Map

reemo1 · **Joined:** Tue Dec 14, 2004 4:13 pm **Posts:** 2

I am using Hibernate 2.1.

I am wondering how to write an HQL query that takes a HashMap relationship I have set up at the object level into consideration.

For example I have a map defined in my xdoclet as follows:

Code:

   /**
    * @hibernate.map table="ed_landing_page_article" cascade="none" lazy="false"
    * @hibernate.collection-key column="ed_landing_page_id"
    * @hibernate.index-many-to-many column="ed_landing_page_bucket_id" class="com.edmunds.editorial.model.LandingPageBucket"
    * @hibernate.collection-many-to-many column="article_id" class="com.edmunds.editorial.model.Article"
    * @hibernate.collection-cache usage="read-write" */
   public Map getArticleMap() {
      return articleMap;
   }

How can I use the articleMap in my HQL query to do a join to another object that is the actual key within this map. My key is a LandingPageBucket object. How can I join these 2 objects via HQL?

Regards.

anthony · **Posted:** Tue Dec 14, 2004 4:18 pm

index-many-to-many?
check ternary association in reference guide

reemo1 · **Joined:** Tue Dec 14, 2004 4:13 pm **Posts:** 2

Yes this is an index-man-to-many relationship.

I just want to know the syntax basically to use a map in a HQL query?

For instance:

select objectWithMap from
objectWithMap , keyInMapObject
where objectWithMap.map = keyInMapObject

I want to know how to do a join in HQL using a map?

Where is this "ternary assocation" ref guide?

Thanks!

garpinc · **Joined:** Thu Sep 09, 2004 6:46 pm **Posts:** 96

Did you get any response to this?