I have a sql-query defined as follows:

select * from Billing b where b.datecharged::date = :forDate

The datecharged column is defined as a timestamp.

When I get the named query from the session, it thinks it takes two parameters, namely, :date and :forDate.

I searched the forum but didn't find anything in regard to this.

I don't see anything in any documentation that acknowledges that this might be a problem.

I will work around it, but I would think this would be considered a bug.

Hibernate version: Core: 3.2.6ga

Full stack trace of any exception that occurs:

Name and version of the database you are using: PostgreSQL v 8.0.311

Looks like the Spring guys had the same issue reported to them in March 2008:

http://jira.springframework.org/browse/SPR-4612


--
Stephen Souness