Hibernate Community • View topic - Questions about Hibernate Query over Collections

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Questions about Hibernate Query over Collections

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

kaisor

Post subject: Questions about Hibernate Query over Collections

Posted: Tue Oct 10, 2006 11:12 am

Newbie

Joined: Tue Jan 24, 2006 12:04 pm
Posts: 12

Code:

class Shop {
     Integer id;
     Set<RelContact> relContacts; //getter and setter omitted
}

class RelContact {
    Contact contact;
    RelationType relationType;
}

class Contact {
    Integer id;
    String firstname;
    String lastname;
}

here is the HQL
" from Shop s where s.relContacts.contact.firstname like'xxx' ".

any wrong with the hql above?
it can work under hibernate 3.0, but when with 3.1.3 it throws following exception.

org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: firstname of: component[contact,relationType]
[from Shop s where s.relContacts.contact.firstname='xxx' ];

any advice will be appreciated!

Code:

Last edited by kaisor on Wed Oct 11, 2006 4:17 am, edited 1 time in total.

Top

stevewickii

Post subject: Need more information

Posted: Tue Oct 10, 2006 12:15 pm

Beginner

Joined: Mon Apr 24, 2006 9:47 pm
Posts: 33
Location: Kansas City, MO

Post your Hibernate mapping files for these three classes.

Top

kaisor

Post subject:

Posted: Wed Oct 11, 2006 4:14 am

Newbie

Joined: Tue Jan 24, 2006 12:04 pm
Posts: 12

The relationship table between shop and contact ist a composite-element. It
contains three id: shopid, contactid and relationId. (contact can be assigned to shop under different relationtype)

here is the hbm

Code:

<set name="relContacts"
       table="REL_OBJ_CONTACT" 
       cascade="save-update, delete" 
   lazy="false">
       <key column="SHOPID"/>
         
   <composite-element class="RelContact">
      <many-to-one name="contact" 
          column="contactid"
          not-found="ignore"
          class="Contact" 
          cascade="save-update"/>
      
                <many-to-one name="relationType" 
          column="relationid"
               not-found="ignore"
              class="RelationType" 
          cascade="save-update"/>

     </composite-element>
</set>

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