How to map a "conditional" join using Annotations

forgotmyusernameagain2 · **Joined:** Sun Sep 24, 2006 11:48 am **Posts:** 21

I have a User class and a Picture class.

There is a method called getPictures that returns a Set of <Picture>

public Set<Picture> getPictures();

I would like to add an additional method now that will just return the main picture

public Picture getMainPicture();

Is it possible to do a direct mapping within the Hibernate Annotations?

In this case it would be the picture of the above Set where mainpic=1

Cheers!

mooritze · **Joined:** Tue Oct 10, 2006 3:23 am **Posts:** 33

Hi,
Why don't you map another property with a @Where(clause=.. clause and mark it as updateable=false

forgotmyusernameagain2 · **Joined:** Sun Sep 24, 2006 11:48 am **Posts:** 21

Thanks!

have you got an example?

Just spend half an hour googling and could not find any examples for @Where ...

emmanuel · **Posted:** Wed Oct 11, 2006 11:23 am

The hibernate annotations unit test suite contains *a lot* of material, actually all the supported mappings

forgotmyusernameagain2 · **Joined:** Sun Sep 24, 2006 11:48 am **Posts:** 21

emmanuel wrote:

The hibernate annotations unit test suite contains *a lot* of material, actually all the supported mappings

Ok, I try to find it.

In the meantime I tried:

Code:

   @Column(name = "mainpic", unique = false, nullable = false, updatable = false)
   @OneToOne(fetch=FetchType.EAGER)
    @JoinColumn(name="uid")
    @Where(clause="mainpic=1")
@NotFound(action=NotFoundAction.IGNORE)
   
    
   public Picture getMainpicture() {
      return this.mainpicture;
   }

however this led to an org.hibernate.ObjectNotFoundException
No row with the given identifier exists: [User#147854]

forgotmyusernameagain2 · **Joined:** Sun Sep 24, 2006 11:48 am **Posts:** 21

Hm..havent found anything :-(