Hi,

I have table with the following columns:

- name
- status
- from
- to
- pid

If pid is null and status=1, I have to make "name", "from", "to" as unique key, otherwise new record should be inserted.

How do I handle this using @UniqueConstraint?

The JPA annotation does not support this feature, and you should not use HBM2DDL in production. You should use Flyway or Liquibase instead.

If you're using HBM2DDL during testing and you need this functionality, you can provide an additional script that does:



If this DDL statement is located in a script file called: my_unique_constraint.sql, you can provide it to Hibernate like this:

Thats great Thanks, thats what i was thinking too..

I am trying to resolve an issue in my application, which supports autosave(every 10 secs) of a form(only one table no child tables). when there is heavy load on the application hibernate inserting duplicate rows with different ids. Could you give me your view on this. Any inputs on how to fix this issue.

I basically check if the row already exists i update the fields, if its not, then create a new object call saveorupdate(object).
My application is Spring/Hibernate based application,
session factory is org.springframework.orm.hibernate4.LocalSessionFactoryBean
transactionManager is org.springframework.orm.hibernate4.HibernateTransactionManager

MERGE and UPSERT can be used for this purpose. However, these two operations are not supported by Hibernate, so you need to go the native SQL way.