Hi,

I want to limit the results where the article publicationDate field is past or present. This isn't working:

Date now = new Date();
List articles = getHibernateTemplate().find("from stpns.dom.Article a where a.publicationDate <= '" + now.toString() + "'");

here's the sql:
publication_date TIMESTAMP NOT NULL

here's the mapping:
<property name="publicationDate" type="date" column="publication_date" not-null="true" />

Here's the dom field
private java.util.Date publicationDate;


This works in mysql query browser:
SELECT * FROM articles a where a.publication_date <= '2005-12-11'

Thanks for the help and sorry for such a dumb question. I searched around and couldn't find it.

Try to use setParameter: