Hi all!

I have a problem with dates in hibernate search.

I'm trying to index an object:

entityManager.index(myObject);

This object, contains a property of java.util.Date type. All fields are saved OK.

My problem is, for example:
- value of property date in my database: 02-06-2009 (dd/MM/yyyy format)
- value of property date in the index: 01-06-2009

Why my dates are one day less?

Thanks a lot

Sorry, i see that this only happend when date is like 01-06-2009 00:00
and this not happend when date is like 01-06-2009 21:15

I start my VM with de argument -Duser.timezone=Europe/Madrid ...


Thx

can anybody help me?

Hi,

I am pretty sure that's a timezone issue. If you look at the Hibernate Search code for the DateBridge you see it uses Lucene's DateTools which uses the UTC timezone.

How you handle this depends on your application and usecase. You might for example consider storing the dates in UTC in the database.

--Hardy

hi!

Finally a found the solution, this is:

@Field(index = org.hibernate.search.annotations.Index.TOKENIZED,name="ftpublish",store=Store.YES,bridge=@FieldBridge(impl= FtpublishBridge.class))
public Date getFtpublish(){
...
}
In FtpublishBridge i get the GMT + 1 and dates ares saved correctly

Is this a good solution?

Thanks a lot

I guess it works, but you might get into trouble when the timezone changes your application runs in. If you just statically add GMT+1 the whole application might not be 'portable'.

--Hardy

I also managed this problem by writing my own FieldBridge implementation.
I didn't have to add one additional hour!
Using your own FieldBridge causes hibernate to use the same time zone as the application,
so every think will be fine.

RGs.