Unique Constraint Over Multiple Columns

user_942261 0
Viewed 49231

I am using SEAM 2/Hibernate along with PostgreSQL 9 database. I have the following table

Active Band
===========
active_band_id serial
active_band_user text
active_band_date timestamp
active_band_process integer

I would like to add a constraint that ensures each new entry has a unique combination of active_band_user and active_band_date.

There could potentially be many attempted inserts per second so I need this to be as efficient as possible, is there a SEAM / hibernate annotation I can use in the entity mapping?

Thanks in advance

seam2 hibernate-mapping seam postgresql hibernate
3 Answers

In a more modern syntax, it would be :

@Table(
    name="ACTIVE_BAND", 
    uniqueConstraints =
        [UniqueConstraint(
                columnNames = ["active_band_user", "active_band_date"]
        )]
)
user_141190740

This syntax worked for me with Java 17

@Entity
@Table(name = "ELECTION_RESULTS",
    uniqueConstraints = { @UniqueConstraint(name = "UC_CP", columnNames = { "constituency", "party_code" }) })
  
public class ElectionResults {
 @Column(..)
 ......
}
user_108682640
Related