Unique constraint with JPA and Bean Validation

by

Unless you acquire a lock on a whole table, it is basically not possible to check for unicity using a SQL query (any concurrent transaction could modify data after a manual check but before the commit of the ongoing transaction). In other words, it isn’t possible to implement a valid unique verification at the Java level and thus to provide a validation implementation. The only reliable way to check for unicity is while committing the transaction.

The BV spec summarizes it like this:

Appendix D. Java Persistence 2.0 integration

Question: should we add @Unique that
would map to @Column(unique=true)?

@Unique cannot be tested at the Java
level reliably but could generate a
database unique constraint generation.
@Unique is not part of the BV spec
today.

So while I agree that it would be nice to have unique (and non null) constraint violations wrapped in a Bean Validation exception, this is currently not the case.

References

More Related Contents:

  1. JSR303 custom validators being called twice
  2. How can I validate two or more fields in combination?
  3. JSR 303 Validation, If one field equals “something”, then these other fields should not be null
  4. Is there an implementation of JSR-303 (bean validation) available?
  5. Autowired Repository is Null in Custom Constraint Validator
  6. Difference between FetchType LAZY and EAGER in Java Persistence API?
  7. Why is Hibernate Open Session in View considered a bad practice?
  8. JPA: How to have one-to-many relation of the same Entity type
  9. Difference between @Valid and @Validated in Spring
  10. Configure hibernate (using JPA) to store Y/N for type Boolean instead of 0/1
  11. No Dialect mapping for JDBC type: 1111
  12. Hibernate one-to-one: getId() without fetching entire object
  13. Validate an XML file against local DTD file with Java
  14. Hibernate: Where do insertable = false, updatable = false belong in composite primary key constellations involving foreign keys?
  15. Have JPA/Hibernate to replicate the “ON DELETE SET NULL” functionality
  16. How can I avoid the Warning “firstResult/maxResults specified with collection fetch; applying in memory!” when using Hibernate?
  17. JPA, How to use the same class (entity) to map different tables?
  18. Validating IPv4 string in Java
  19. @Id @GeneratedValue but set own ID value
  20. The onFlushDirty Hibernate Interceptor method is never called
  21. How to validate XML against XSD 1.1 in Java?
  22. Is it possible to write a generic enum converter for JPA?
  23. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  24. Why hibernate generates insert and update for OneToMany mapping
  25. repaint() in Java [duplicate]
  26. HQL joined query to eager fetch a large number of relationships
  27. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  28. Setting a JPA timestamp column to be generated by the database?
  29. org.hibernate.loader.MultipleBagFetchException: cannot simultaneously fetch multiple bags
  30. Does JPA support mapping to sql views?

Leave a Comment