Specifying an Index (Non-Unique Key) Using JPA

by

With JPA 2.1 you should be able to do it.

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Index;
import javax.persistence.Table;

@Entity
@Table(name = "region",
       indexes = {@Index(name = "my_index_name",  columnList="iso_code", unique = true),
                  @Index(name = "my_index_name2", columnList="name",     unique = false)})
public class Region{

    @Column(name = "iso_code", nullable = false)
    private String isoCode;

    @Column(name = "name", nullable = false)
    private String name;

}

Update: If you ever need to create and index with two or more columns you may use commas. For example:

@Entity
@Table(name    = "company__activity", 
       indexes = {@Index(name = "i_company_activity", columnList = "activity_id,company_id")})
public class CompanyActivity{

More Related Contents:

  1. JPA JoinColumn vs mappedBy
  2. Difference between FetchType LAZY and EAGER in Java Persistence API?
  3. How to map a composite key with JPA and Hibernate?
  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. Do I need elements in persistence.xml?
  7. What’s the difference between JPA and Hibernate? [closed]
  8. What is the “owning side” in an ORM mapping?
  9. What is the solution for the N+1 issue in JPA and Hibernate?
  10. JPA CascadeType.ALL does not delete orphans
  11. What is the difference between persist() and merge() in JPA and Hibernate?
  12. Bypass GeneratedValue in Hibernate (merge data not in db?)
  13. JPQL Create new Object In Select Statement – avoid or embrace?
  14. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  15. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  16. JPA/Hibernate Native Queries do not recognize Parameters
  17. How to solve the LazyInitializationException when using JPA and Hibernate
  18. Hibernate – @ElementCollection – Strange delete/insert behavior
  19. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  20. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  21. Is it possible to dynamically define column names in Hibernate / JPA?
  22. Doing an “IN” query with Hibernate
  23. The onFlushDirty Hibernate Interceptor method is never called
  24. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  25. Hibernate throws strange error: Class is not mapped
  26. Batch inserts with JPA/EJB3
  27. Hibernate vs JPA vs JDO – pros and cons of each? [closed]
  28. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  29. Change Table Name of an Entity on runtime? [duplicate]
  30. How to map one class to different tables using hibernate/jpa annotations

Leave a Comment