Hibernate Criteria for Dates

by

Why do you use Restrictions.like(...)?

You should use Restrictions.eq(...).

Note you can also use .le, .lt, .ge, .gt on date objects as comparison operators. LIKE operator is not appropriate for this case since LIKE is useful when you want to match results according to partial content of a column.
Please see http://www.sql-tutorial.net/SQL-LIKE.asp for the reference.

For example if you have a name column with some people’s full name, you can do where name like 'robert %' so that you will return all entries with name starting with 'robert ' (% can replace any character).

In your case you know the full content of the date you’re trying to match so you shouldn’t use LIKE but equality. I guess Hibernate doesn’t give you any exception in this case, but anyway you will probably have the same problem with the Restrictions.eq(...).

Your date object you got with the code:

SimpleDateFormat formatter = new SimpleDateFormat("dd-MM-YYYY");
String myDate = "17-04-2011";
Date date = formatter.parse(myDate);

This date object is equals to the 17-04-2011 at 0h, 0 minutes, 0 seconds and 0 nanoseconds.

This means that your entries in database must have exactly that date. What i mean is that if your database entry has a date “17-April-2011 19:20:23.707000000”, then it won’t be retrieved because you just ask for that date: “17-April-2011 00:00:00.0000000000”.

If you want to retrieve all entries of your database from a given day, you will have to use the following code:

    SimpleDateFormat formatter = new SimpleDateFormat("dd-MM-YYYY");
    String myDate = "17-04-2011";
    // Create date 17-04-2011 - 00h00
    Date minDate = formatter.parse(myDate);
    // Create date 18-04-2011 - 00h00 
    // -> We take the 1st date and add it 1 day in millisecond thanks to a useful and not so known class
    Date maxDate = new Date(minDate.getTime() + TimeUnit.DAYS.toMillis(1));
    Conjunction and = Restrictions.conjunction();
    // The order date must be >= 17-04-2011 - 00h00
    and.add( Restrictions.ge("orderDate", minDate) );
    // And the order date must be < 18-04-2011 - 00h00
    and.add( Restrictions.lt("orderDate", maxDate) );

More Related Contents:

  1. having an exception when saving oracle type object in some entity
  2. What’s the difference between JPA and Hibernate? [closed]
  3. Can someone explain mappedBy in JPA and Hibernate?
  4. Mapping ManyToMany with composite Primary key and Annotation:
  5. When to use EntityManager.find() vs EntityManager.getReference() with JPA
  6. How to get SQL from Hibernate Criteria API (*not* for logging)
  7. JPA and Hibernate – Criteria vs. JPQL or HQL
  8. Hibernate criteria: Joining table without a mapped association
  9. Could not serialize object cause of HibernateProxy
  10. @PreUpdate and @Prepersist in hibernate/JPA (using session)
  11. Hibernate bidirectional @ManyToOne, updating the not owning side not working
  12. Hibernate, iBatis, Java EE or other Java ORM tool
  13. How to get distinct results in hibernate with joins and row-based limiting (paging)?
  14. Hibernate recursive many-to-many association with the same entity
  15. How to call Oracle Function or Procedure using Hibernate (EntityManager) or JPA
  16. Hibernate could not fetch the SequenceInformation from the database
  17. Need to reset the value of sequence in Oracle
  18. How to call an Oracle function from Hibernate with a return parameter?
  19. Mapping array with Hibernate
  20. Hibernate sequence on oracle, @GeneratedValue(strategy = GenerationType.AUTO)
  21. JPA Multiple Embedded fields
  22. Connection cannot be cast to oracle.jdbc.OracleConnection
  23. Hibernate native query – char(3) column
  24. Spring Data JPA: How can Query return Non- Entities Objects or List of Objects?
  25. Using hibernate criteria, is there a way to escape special characters?
  26. How to make a database listener with java?
  27. JPA: difference between @JoinColumn and @PrimaryKeyJoinColumn?
  28. Solve Hibernate Lazy-Init issue with hibernate.enable_lazy_load_no_trans
  29. How to call oracle stored procedure which include user-defined type in java?
  30. Hibernate/persistence without @Id

Leave a Comment