Description Sabine Heider 2010-10-19 06:58:31 EDT

There seems to be a problem with @AttributeOverride when different nested embeddables inside an entity have an attribute of the same name. See the following example:

@Entity
@Table(name="MY_ENTITY")
public class MyEntity {

    @Id
    private int id;

    @Embedded
    @AttributeOverrides ({
        @AttributeOverride(name="quantity.value", column=@Column(name="QTYVALUE")),
        @AttributeOverride(name="quantity.unitCode", column= @Column(name="QTYUNIT")),
        @AttributeOverride(name="amount.value", column=@Column(name="AMOUNTVALUE")),
       @AttributeOverride(name="amount.currencyCode", column= @Column(name="AMOUNTCURR"))
    })	
    private Price price;
}


@Embeddable
public class Price {
    @Embedded
    Quantity quantity;

    @Embedded
    Amount amount;

}


@Embeddable
public class Quantity {
    int value;
    String unitCode;
}


@Embeddable
public class Amount {
    private int value;
    private String currencyCode;
}

Note that both Quantity and Amount have an attribute called "value". 

When I try to persist an instance of MyEntity, I get the following exception:

Internal Exception: com.sap.dbtech.jdbc.exceptions.jdbc40.SQLSyntaxErrorException: [-4005] (at 53): Unknown column name:VALUE
Error Code: -4005
Call: INSERT INTO MY_ENTITY (ID, AMOUNTCURR, AMOUNTVALUE, VALUE, QTYUNIT) VALUES (?, ?, ?, ?, ?)
	bind => [1, EUR, 3, 2, kg]

When I rename one of the "value" fields, everything works fine.