@Basic(optional = false) vs @Column(nullable = false) in JPA

by

Gordon Yorke (EclipseLink Architecture Committee Member, TopLink Core Technical Lead, JPA 2.0 Expert Group Member) wrote a good answer on this topic so instead of paraphrasing him, I’ll quote his answer:

The difference between optional and
nullable is the scope at which they
are evaluated. The definition of
‘optional‘ talks about property and
field values and suggests that this
feature should be evaluated within the
runtime. ‘nullable‘ is only in
reference to database columns.

If an implementation chooses to
implement optional then those
properties should be evaluated in
memory by the Persistence Provider and
an exception raised before SQL is sent
to the database otherwise when using
‘updatable=false‘ ‘optional‘
violations would never be reported.

More Related Contents:

  1. JPA JoinColumn vs mappedBy
  2. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  3. Difference between FetchType LAZY and EAGER in Java Persistence API?
  4. Hibernate Annotations – Which is better, field or property access?
  5. How to map an entity field whose name is a reserved word in JPA
  6. What’s the difference between JPA and Hibernate? [closed]
  7. How to map calculated properties with JPA and Hibernate
  8. What is the solution for the N+1 issue in JPA and Hibernate?
  9. JPA CascadeType.ALL does not delete orphans
  10. Bypass GeneratedValue in Hibernate (merge data not in db?)
  11. When and why JPA entities should implement the Serializable interface?
  12. Map enum in JPA with fixed values?
  13. JPA: How to have one-to-many relation of the same Entity type
  14. Storing a Map using JPA
  15. How to persist a property of type List in JPA?
  16. I found JPA, or alike, don’t encourage DAO pattern
  17. Getting Database connection in pure JPA setup
  18. Hibernate – @ElementCollection – Strange delete/insert behavior
  19. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  20. How to clone a JPA entity
  21. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  22. Is it possible to dynamically define column names in Hibernate / JPA?
  23. Specifying an Index (Non-Unique Key) Using JPA
  24. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  25. Hibernate throws strange error: Class is not mapped
  26. Hibernate triggering constraint violations using orphanRemoval
  27. Hibernate vs JPA vs JDO – pros and cons of each? [closed]
  28. What is Persistence Context?
  29. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  30. Does JPA support mapping to sql views?

Leave a Comment