@JoinColumn overrides scale and percision in ManyToOne map..

acoliver · **Joined:** Tue Mar 16, 2004 3:15 pm **Posts:** 3

This is Hibernate 3.2.4 SP1 with Annotations version 3.2.1 (as supplied by JBoss AS 4.2.2)

Consider:

@Entity
p c Orders {
@Id @GeneratedValue(strategy=GenerationType.IDENTITY, generator="java5_uuid")
@GenericGenerator(name="java_uuid", strategy="c.o.s.d.i.UUIDGenerator")
@Column(precision=128, scale=0)
private BigInteger id;

@OneToMany(mappedBy="order", cascade= ...)
@Fetch(FetchMode.SUBSELECT)
private Set<OrderLineItems> items;

}

@Entity
p c OrderLineItems {
...
@ManyToOne @JoinColumn(name="order_id")
Order order;

}

The only really important pieces are that a 128 bit integer is used for the key. This throws an exception on insert of a line item because the "precision" of the order_id is off. However if you remove the @JoinColumn then the error goes away and the generated column is 128 bit. You cannot have a @Column mapping on an @ManyToOne. In the XML format there is a way to specify the scale/precision of the key with the column element.

My questions -

1. is there a way to specify both the @JoinColumn AND the precision?
2. Why does @JoinColumn override the precision specified by the @Id that is obviously carried otherwise?
3. Is that a bug?
4. Can Gavin's fashion sense be blamed for this?

-Andy

emmanuel · **Posted:** Thu Jun 05, 2008 4:53 pm

3.
can you add a testcase for that in JIRA.

emmanuel · **Posted:** Thu Jun 05, 2008 4:55 pm

And we can always blame Gavin's fashion taste, it never hurts :)

acoliver · **Joined:** Tue Mar 16, 2004 3:15 pm **Posts:** 3

http://opensource.atlassian.com/project ... se/ANN-748

done. Note that it doesn't replicate with Hypersonic.

acoliver · **Joined:** Tue Mar 16, 2004 3:15 pm **Posts:** 3

Note that the issue:
http://opensource.atlassian.com/project ... se/ANN-748 is now marked fixed. http://fisheye.labs.jboss.com/changelog ... e?cs=14760 and http://fisheye.labs.jboss.com/changelog ... e?cs=14761 are noted in jira as the fixes. I have a hacky fix that I put in our branch of H3A but Hardy's fix is simpler. I'll test this in our app next week.

Thanks to Emmanuel and Hardy Ferentschik.