Hibernate Community • View topic - where attribute question

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

where attribute question

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

perman

Post subject: where attribute question

Posted: Thu Jun 03, 2004 9:30 am

Newbie

Joined: Tue May 11, 2004 11:32 am
Posts: 16

I have a collection mapping like this:

Code:

<hibernate-mapping> 
  <class name="my.FooImpl" table="foo_table"> 
    <id name="mId" column="id" type="long" access="field"> 
      <generator class="sequence"> 
        <param name="sequence">foo_seq</param> 
      </generator> 
    </id> 
    <set name="bars" table="my_link_table" access="field" lazy="true"> 
      <key column="child_id"/> 
      <many-to-many column="parent_id" class="my.FooImpl"/> 
    </set> 
  </class>

  <class name="my.BarImpl" table="bar_table">
    <id name="mId" column="id" type="long" access="field"> 
      <generator class="sequence"> 
        <param name="sequence">foo_seq</param> 
      </generator> 
    </id> 
    <property name="type" column="type" type="string"
  </class>    
</hibernate-mapping>

I'm having trouble with the "where" attribute of FooImpl.bars. How do I limit the contents of the set to only those isntances of BarImpl that have a specific value for "type"?

I was thinking of something like this:

Code:

where="my.BarImpl.type='something'"

Top

perman

Post subject:

Posted: Thu Jun 03, 2004 9:32 am

Newbie

Joined: Tue May 11, 2004 11:32 am
Posts: 16

Of course, as soon as I post, I noticed my mapping is wrong. The class of the set should be BarImpl:

Code:

<hibernate-mapping> 
  <class name="my.FooImpl" table="foo_table"> 
    <id name="mId" column="id" type="long" access="field"> 
      <generator class="sequence"> 
        <param name="sequence">foo_seq</param> 
      </generator> 
    </id> 
    <set name="bars" table="my_link_table" access="field" lazy="true"> 
      <key column="foo_id"/> 
      <many-to-many column="bar_id" class="my.BarImpl"/> 
    </set> 
  </class> 

  <class name="my.BarImpl" table="bar_table"> 
    <id name="mId" column="id" type="long" access="field"> 
      <generator class="sequence"> 
        <param name="sequence">foo_seq</param> 
      </generator> 
    </id> 
    <property name="type" column="type" type="string" 
  </class>    
</hibernate-mapping> 

Top

Page 1 of 1

[ 2 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