Hibernate @OneToOne mapping with a @Where clause

java hibernate hibernate-mapping hibernate-annotations
nuaavee picture nuaavee · Dec 8, 2010 · Viewed 7k times · Source

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?

Answer

Affe picture Affe · Dec 8, 2010

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.

Related questions

How can I mark a foreign key constraint using Hibernate annotations?

I am trying to use Hibernate annotation for writing a model class for my database tables. I have two tables, each having a primary key User and Question. @Entity @Table(name="USER") public class User { @Id @Column(name="user_id") @…

Read More
Doesn't work setting default value of property in Hibernate

I have a boolean property in my entity. Here's my annotations for it: @Column(name = "IS_ACTIVE", nullable = false, columnDefinition="BIT DEFAULT 1", length = 1) public Boolean getActive() { return isActive; } But columnDefinition="BIT DEFAULT 1" doen't work perfectly. Here's SQL code I get …

Read More
How can i insert a row using hibernate method?

I am trying to insert a row into a relation table Stock Category. I am following this example: http://www.mkyong.com/hibernate/hibernate-many-to-many-example-join-table-extra-column-annotation/ Now I already have data in table stock and category. Later I want to associate a …

Read More