Hibernate IN Clause with multiple columns

by

Putting down here how I implemented this. Basically we need to make a Hibernate Component (read @Embeddable object) out of the set of columns we need to query on and embed it in the main Entity.

The group of columns can be combined as below:

@Embeddable
public class CompositeColumns{
  private String col1;
  private String col2;

  //Empty constructor is required by Hibernate for instantiation
  public CompositeColumns(){
  }

  public CompositeColumns(String col1, String col2){
            this.col1 = col1;
            this.col2 = col2;
      }

  @Column(name="COL1")
  public String getCol1(){
  }
  ...
  ... 
  //Rest of getters and setters
}

Embed the above in your main entity class as below:

@Entity
public class MyEntity{
 @Id
 private Integer id;
 private String col3;
 private String col4
 @Embedded
 private CompositeColumns pairedCol1Col2;
 ...
 ...
 //Getters Setters

}

The query would then look as below:

List<CompositeColumns> cols = //get a list of CompositeColumns type

Query query=session.createQuery( "from MyEntity where pairedCol1Col2 in (:list)" );
query.setParameterList( "list", list );

This does the job.

Note: I ran this on an Oracle database

More Related Contents:

  1. How does JPA orphanRemoval=true differ from the ON DELETE CASCADE DML clause
  2. Hibernate Criteria Join with 3 Tables
  3. How to use @Where in Hibernate
  4. Another Repeated column in mapping for entity error
  5. Does the JPA specification allow references to non-primary key columns?
  6. Hibernate: comparing current & previous record
  7. Struggling to understand EntityManager proper use
  8. java.lang.ClassNotFoundException: org.hibernate.HibernateException
  9. Hibernate problem – “Use of @OneToMany or @ManyToMany targeting an unmapped class”
  10. How to use the Java 8 LocalDateTime with JPA and Hibernate
  11. Hibernate throws org.hibernate.AnnotationException: No identifier specified for entity: com..domain.idea.MAE_MFEView
  12. Using JPA entities in JSF. Which is the best strategy to prevent LazyInitializationException?
  13. Hibernate field naming issue with Spring Boot (naming strategy)
  14. JPA/Hibernate remove entity sometimes not working
  15. Hibernate hbm2ddl.auto=update doesn’t update column definitions in MySQL
  16. Spring Data JDBC / Spring Data JPA vs Hibernate
  17. How to configure Spring to make JPA (Hibernate) and JDBC (JdbcTemplate or MyBatis) share the same transaction
  18. Hibernate ID Generator
  19. what is the right path to refer a jar file in jpa persistence.xml in a web app?
  20. JPA CriteriaBuilder – How to use “IN” comparison operator
  21. Setting properties programmatically in Hibernate
  22. Hibernate, alter identifier/primary key
  23. Hibernate: More than one row with the given identifier was found error
  24. Hibernate unidirectional one to many association – why is a join table better?
  25. What is the right way to use spring MVC with Hibernate in DAO, service layer architecture
  26. hibernate – get id after save object
  27. How to use JPA2’s @Cacheable instead of Hibernate’s @Cache
  28. Hibernate 3.6 – session.get() vs session.load()
  29. UnsupportedOperationException: The application must supply JDBC connections
  30. New object with HQL

Leave a Comment