Correct usage of @AttributeOverride on embedded class

[John Summers]

Hello chaps,

I am writing some small hibernate examples and the simple @AttributeOverride is 'doing my head in' (as we say in the UK). The code below gives the error
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'boringEntity_boringCode' in 'field list'
and I'm pretty sure this is because I'm using the @AttributeOverride wrong so hibernate is using the default name for the FK reference for BoringEntity, which won't work. Take a look:

@Entity
@Table(name="1_CompoundIdEntity2")
public class CompoundIdEntity2 {

	@EmbeddedId
	@AttributeOverride(name="boringCode", column=@Column(name="boringEntityId"))//WHOOPS this doesn't work!!
	public CompoundId compoundId;
	
	@OneToOne(optional=false)
	@MapsId("boringCode")
	public BoringEntity boringEntity;
	
	@Embeddable
	public class CompoundId implements Serializable{
		public int someCode;//db field: 1_CompoundIdEntity2.someCode
		
		public int boringCode;//db field: 1_CompoundIdEntity2.boringEntityId links FK to 1_BoringEntity.boringCode
		
		//should override equals and hashcode
	}
}

@Entity
@Table(name="1_BoringEntity")
public class BoringEntity {
	@Id
	@GeneratedValue(strategy=GenerationType.AUTO)
	public int boringCode;
	
	public String boringDesc;
}

And the tables are:

1_CompoundIdEntity2
-someCode
-boringEntityId

1_BoringEntity
-boringCode
-boringDesc

Any help appreciated. I don't find the documentation for this tag particularly revealing I'm afraid.
Cheers,
John

[John Summers]

Solved!!

Silly me.. I forgot to add

@JoinColumn(name="boringEntityId")

beside the @OneToOne tag.If you don't put @JoinColumn then HB use the default name which is boringEntity_boringCode. No @AssociationOverride required.

Regards,
John