Hi All.

I am running hibernate 1.2 with postgresql 7.2.4.
I would like to do a HQL query like the following WHERE clause.



The problem is the query in psql works fine but in hibernate the nested part of the query is always met even if it shouldn't be.

I also tried the following with the same result:


I am not sure if this is fixed in a newer version of hibernate.
If so it could be the reason I need to get around to upgrading.

Thanks in advance.
Ian...

I'm sorry? What is the problem???

Some generated SQL?

Sorry I should have made it clearer.
If I run the hibernate generated sql in psql (replacing the ?) the query runs as expected.
Basically only return table entries that are either not in the given statuses or the start time is earlier than the eolTime.
In hibernate it always returns the table regardless of status or times.

Cheers.
Ian.

Sorry I have failed to include some important information.
Also I was chasing the wrong problem, sorry if I wasted your time. :(

I am actually passing a named parameter date (java.util.Date) instead of the item.eolTime which hibernate logs as 'binding '13 March 2004' to parameter: 1'
hence it was always matching the date as they where all set to today though the times where different so the nested AND was working fine.
Though I want to do second precision checking for this date.
I use the Query.setDate("item_eolTime",java.util.Date()) to set this named parameter.

ie. AND NOT (table.statusId IN ('bad','worse') AND table.startTime > :item_eolTime)
Is there something I should be doing to in order to not loose the time part of java.util.Date ?

Cheers.
Ian.

Yes, use query.setTimestamp()

I'm extremely sorry for not researching properly before posting.
I found on forum "Hibernate's ability to query time" the solution to the actual problem I was having.
I am now using Query.setTimestamp(String, java.util.Date) and it works beautifully.

Sorry again for time wasting.
Thank you very much for persisting with me in this wild goose chase.
Cheers.
Ian.