Hello there! I'm having some problems when dealing with java.sql.Time properties. My Database is a SQL Server 2000 with a DateTime column. My property is mapped as a java.sql.Time

My problem is, when I create a criteria I'm doing this:

Criteria c = session.createCriteria(Entity.class);
c.add(Expression.gt("beginTime", timeObject);

But what is being generated on the SQL is column_name > '10:00:00' (suppose our timeObject maps to a date at 10 o'clock).

Any hints on how to use it?

Thanks

What is your exact problem?
Why don't you use java.util.Date?

Best regards
Sven

If your column is DateTime then I suppose that you are interested in date AND time. Then just map the column to the property of type java.util.Date and averything shoulld work.

Hello Konstantin! r u the same guy from Hivemind list? Dude you are everywhere ;).

Well my problem isn't with the mapping it self. The issue is, on the database I have only time recorded, like 10:15:00. I need to fetch data that meets a given criteria, like "fetch all data that the time is before now" problem is now, is a "complete" date object (mm/dd/yyyy HH:mm:ss). I was doing with a calendar object, but it required me doing a lot of conversion, and I could't filter anything from HQL.

What I'd like to know is how to work with only times on Hibernate.

Thanks

I'm not really into SQL Server 2000, but when using a DateTime in SQL Server 2000 you will have the whole date, not only the time, right?

So, you will have to convert this data type to only retrieve the time.

What is your expected result in SQL?

Best regards
Sven