I'm using Hibernate 3.3 with PostgreSQL 8.3
I'm trying to set the UniqueConstraint on the table Rubric in Hibernate. Note that the corresponding constraints on the table Rubric in PosgreSQL database aren't defined. I want only Hibernate checks the constraint, beacause I can't change the database structure.

But when I create an object Rubric that violates the constraint Hibernate does not check it and inserts the Rubric into the database. Is there any workaround?

Here is the code:

@Table(uniqueConstraints = @UniqueConstraint(columnNames = { "col1", "col2" }))
public class Rubric extends AbstractPersistentEntity
{
...
@ManyToOne(optional = false)
@JoinColumn(nullable = false)
private MyColumn col1;

@Column(length = 4)
@Index(name = "col2_indx")
private int col2;

}

@MappedSuperclass
public abstract class AbstractPersistentEntity
{...}

The purpose of this annotation is purely to get mapped as corresponding constraints on the table on the database.
If you can't can't change the database structure then this annotation is for the birds,
as hibernate doesn't internally check the uniqueness of this attributes.

Why do you can't change the database structure ?
If "col1", "col2" should be unique then in first line the database should know about I think.