Hibernate @OneToOne mapping with a @Where clause

Question

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?

You need to show `NoteEntity`. Also, try configuring `true` in order to see what's in the SQL. — Adeel Ansari, Dec 08 '10 at 03:44

score 10 · Accepted Answer · answered Dec 08 '10 at 00:34

10

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.

answered Dec 08 '10 at 00:34

Affe

47,174
11
83
83

1

Ok, how? Option #2 – Christian Bongiorno May 04 '16 at 19:13
@Affe i can confirm that first option by changing the object to a list and doing onetomany(even if the design is onetoone), then getting a single element works fine. Thanks – rpajaziti Apr 17 '20 at 16:43

score 4 · Answer 2 · answered Oct 27 '17 at 12:14

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.

score 0 · Answer 3 · answered Jun 26 '23 at 10:24

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.

Hibernate @OneToOne mapping with a @Where clause

3 Answers3

Linked