Hello,

I develop an application to build automatically request.
In one of my tests, I want to put a date constraint in a query like
select x from t where d='30/04/2006'

input : '30/04/2006'

I want to build a criteria on it and this is done :

Since the entry_date field of Class Sample is java.util.Date, the method 'createNewInstance' returns a new java.util.Date with the String parameter "30/04/2006".
But there is an exception : org.hibernate.type.DateType.toString

I think it's because the parameter is as formated as in my database : yyyy-MM-dd.

My question is simply how to integrate in a criteria a comparison between a field util.Date and a String parameter containing the date ?

You need to pass a Date type object

This is what I did !

I create a method called 'createNewInstance' which return an Object, used in criteria restriction:


createNewInstance method takes 3 String parameters : the first and the second are the class name and the field name; I retrieve the corresponding data type and I build and return a new instance of this data type object with the third String parameter.
In that way, I have the good instancied object to put in the restriction methods ! With the example I gave below, createNewInstance returns a new java.util.Date with 30/04/2006.

Since yesterday, I had problems with all Restrictions methods like ilike, gt, lt...
Today, I carefully did my test and actually, only the ilike method doesn't work !!! the same code, but not the method name !!! ilike method doesn't work and gt does ???


Any idea ?

What are you trying to do using 'ilike' to compare dates? ilike is used mainly to compare strings. A date is a number. It is either equal, less than, or greater than another date/number.