JPA @UniqueConstraint doesn't see the columns

Question

In Spring JPA I havean entity and I init the schema using FlywayDb. My entity is:

@Entity
@Table(schema = "scheduler",
        uniqueConstraints={@UniqueConstraint(name = "uq_task", columnNames = {"task", "date_at"})}
)
public class Task {
    @Id
    private Long id;

    @Embedded
    @Column(nullable = false)
    private ITask task;

    @Column(nullable = false)
    private Date dateAt;

}

The schema is initialized as follows:

CREATE SCHEMA scheduler;

CREATE TABLE scheduler.task (
    id bigserial primary key,
    task bytea NOT NULL,
    date_at timestamp NOT NULL
);

CREATE UNIQUE INDEX uq_task
  ON scheduler.task(task, date_at);

Without the constraints on the entity, it works, with it doesn't. In particular I have the exception:

Caused by: org.hibernate.AnnotationException: Unable to create unique key constraint (task, date_at) on table task: database column 'task' not found. Make sure that you use the correct column name which depends on the naming strategy in use (it may not be the same as the property name in the entity, especially for relational types)
    at org.hibernate.cfg.Configuration.buildUniqueKeyFromColumnNames(Configuration.java:1684)
    at org.hibernate.cfg.Configuration.buildUniqueKeyFromColumnNames(Configuration.java:1616)
    at org.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:1452)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1846)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:857)

I use an H2 database.

ITask is an interface with several POJO implementations. ITask interface is annotated with @Embeddable.

My guess is that JPA tries to apply the unique constraints on columns that are not yet created by FlywayDb library. But this makes no sense to me.

Any idea?

one question when you remove the jpa annotation of unique constraint dose it work ?! — shareef, Nov 01 '15 at 20:56
Yes, as I said, without annotation in the entity class but with the constraints defined in the sql file for flyway, everything is ok! — mat_boy, Nov 01 '15 at 20:57
task in flyway is of type `byte` but in jpa its Object `Task` is that even righ ! you may need to make `@Column(name="task")` and `@Column(name="date_at")` that may fixes and i think you need to add join for self join that is ... read http://stackoverflow.com/questions/15216321/jpa-self-join-using-jointable — shareef, Nov 01 '15 at 21:13

burovmarley · Accepted Answer · 2015-11-01T21:38:00.860

1

After update of you question now I can guess that there is a problem with attribute in your ITask insterface please read that doc. In my opinion you have to override embbedable entity attribute to fix your problems.

edited Nov 01 '15 at 21:38

answered Nov 01 '15 at 21:14

burovmarley

644
3
8

I updated the question. ITask is an interface annotated with @Embeddable – mat_boy Nov 01 '15 at 21:29
I've modified my answer – burovmarley Nov 01 '15 at 21:41
I removed the `@Embeddable` and now it complains for the missing `date_at` column – mat_boy Nov 01 '15 at 21:44
try to change annotation from @Column(nullable = false) to @Column(name="date_at", nullable = false) – burovmarley Nov 01 '15 at 21:46
Yeah, it helps. Now it complains about the column type for the column task: `Found: varbinary, expected: blob`. Doesn't make sense, it is an object, why I should use blob? – mat_boy Nov 01 '15 at 21:52
Try back to Embeddable and add to task field annotation OverrideAttribute to set the real column name. This should help – burovmarley Nov 01 '15 at 21:55
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/93945/discussion-between-burovmarley-and-mat-boy). – burovmarley Nov 02 '15 at 06:38

JPA @UniqueConstraint doesn't see the columns

1 Answers1