Unique key constraint for 2 fields

[Andib]

Hi,

In Spring Roo is there a way to add a unique key constraint on an entity for 2 fields?

My Inventory entity has the following fields:

public class Inventory {

    private int quantityOnHand;

    @ManyToOne
    private Warehouse warehouse;

    @NotNull
    private String sku;
}

How do I add a constraint that sku and warehouse make a unique constraint?

[spgmx]

Just annotate Inventory with @UniqueConstraint

http://docs.oracle.com/javaee/6/api/...onstraint.html

[Andib]

Thank you! I can't believe I couldn't find that.

Is there a way to define that in the roo command line or is the only way to modify the entity directly?

[spgmx]

You could write an addon or extend the existing one