CODEWITHSUNDEEP
javahibernatehibernate-mappinghibernate-annotations
nuaavee
nuaavee

Reputation: 1356

Hibernate @OneToOne mapping with a @Where clause

Will this work -

@OneToOne()
@JoinColumn(name = "id", referencedColumnName = "type_id")
@Where(clause = "type_name = OBJECTIVE")
public NoteEntity getObjectiveNote() {
  return objectiveNote;
}

This is what I am trying to do - get the record from table note whose type_id is the id of the current object and type_name is OBJECTIVE.

I can't get the above mapping to work. What am I doing wrong here?

Upvotes: 13

Views: 11356

Answers (3)

michal.jakubeczy
michal.jakubeczy

Reputation: 9517

You can try using JoinColumnsOrFormulas annotation.

@OneToOne()
@JoinColumnsOrFormulas({
    @JoinColumnOrFormula(column =
        @JoinColumn(name = "id", referencedColumnName = "type_id")),
    @JoinColumnOrFormula(formula =
        @JoinFormula(value = "OBJECTIVE", referencedColumnName = "type_name"))
})
public NoteEntity getObjectiveNote() {
  return objectiveNote;
}

This should produce join condition even with additional filtering for type_name = OBJECTIVE.

Upvotes: 1

vadipp
vadipp

Reputation: 948

Actually you can achieve this by specifying @OneToOne without any @Where, but putting @Where on the referenced entity class. I tested this on Hibernate 4.3.11.

This works if you don't care about any entity objects that do not match your @Where.

If you do care about other entities, you can probably create a subclass entity, put @Where on it and join that subclass. But I have not tested this scenario.

Upvotes: 4

Affe
Affe

Reputation: 47994

This just plain does not work, sorry :( You will need to do it as one to many and live with getting a collection with a single element.

If you really want it to work this way, you can trick hibernate by storing both the foreign key ID and the type_name in a join table and telling it that both columns make up the foreign key.

Upvotes: 10

Related Questions