Doubt with hibernate and date field

[Ed]

I'm using hibernate to access to a Data base done with MSAccess
The class that I am persisting has an attribute which type is "java.sql.Timestamp (its name is hExit), the type of the columns is Datetime

I don't have problems to save it.
The problems is when I want to access to the records filtering the date
I tried using the "criteria" that provide the API of hibernate, but it gives to me all of record or none

can you help me?

[Heather]

I would change the attributes to a Calendar type .
the mapping would be something like that:

Code:

<property name="date" type="calendar" column="finishdate"/>

Code:

Query query = getSession().createQuery(select .... where (req.date between :date1 and :date2)
.setCalendar("date1 ",this.getYear()[0])
.setCalendar("date2",this.getYear()[1]);

[Peter]

Active " show_sql " and check the SQL query that is sending you.
Maybe Access doesn't support "< >,between dates" and so on.
search on internet this.