Unique Constraint Over Multiple Columns

hibernate postgresql seam hibernate-mapping seam2
DaveB picture DaveB · Aug 14, 2012 · Viewed 41k times · Source

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

Answer

Mikko Maunu picture Mikko Maunu · Aug 14, 2012

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"})
)

Related questions

Connecting PostgreSQL 9.2.1 with Hibernate

I have a blank Spring MVC project, and I've installed Hibernate and the PostgreSQL drivers using Maven. I'm running short on complete tutorials that show how to connect PostgreSQL with Hibernate. Any help here?

Read More
How do you add PostgreSQL Driver as a dependency in Maven?

I'm trying to develop a Java application with Maven while using Hibernate with a PostgreSQL database for persistence. I don't understand how I'm supposed to connect the PostgreSQL drivers to my application. I get that you add dependencies in Maven's …

Read More
proper hibernate annotation for byte[]

I have an application using hibernate 3.1 and JPA annotations. It has a few objects with byte[] attributes (1k - 200k in size). It uses the JPA @Lob annotation, and hibernate 3.1 can read these just fine on all major databases -- …

Read More