Unique Constraint Over Multiple Columns
There is no Hibernate annotation that checks uniqueness before insert/update. But there is annotation which will generate such a constraint to database if automatic database creation is used:
@Table(
name="ACTIVE_BAND",
uniqueConstraints=
@UniqueConstraint(columnNames={"active_band_user", "active_band_date"})
)
In a more modern syntax, it would be :
@Table(
name="ACTIVE_BAND",
uniqueConstraints =
[UniqueConstraint(
columnNames = ["active_band_user", "active_band_date"]
)]
)