Hi,

I want to query persons for their birthday using Hibernate Search.

The date fild in my person class is like this:




When i query for


I get all persons with the birthday 19420125. So there is always a difference of one day. I think this is because the dates are stored GMT based in the index.

Is there a solution for this date-difference problem while searching?

Thanks,

Alexander

Hi,

I was facing the same problem once before. The 'problem' is that the DateBridge class is using Lucene's DateTools class for converting to and from dates (http://fisheye.jboss.org/browse/Hibernate/search/trunk/src/java/org/hibernate/search/bridge/builtin/DateBridge.java?r=11625). If you check the documentation of DateTools you will see that it uses UTC as timezone. For that reason you will have to make sure that the date instances you are working with are all in UTC. Given that you are just interested in a resolution of days this should be no problems.

How do you create your date instances in your entities? Check the Calendar class. There is for example a getInstance(TimeZone zone) which allows you to get a Calendar instance with a certain time zone. If you consistently use the UTC timezone in your application everything should be fine.

If your requirements are that you have to preserve the timezone you could write your own DateBridge.

Generally, you have to be careful when constructing/using dates within your java app and then transfering them across to other systems, be it a database or a Lucene index.

Hope this helps.

--Hardy

@Hardy: thanks for your help. I ended up in using my own DateBridge.

Regards,

Alexander