sysdate expression throw unknow column exception

prettyhandling · **Joined:** Mon Aug 02, 2004 9:33 am **Posts:** 69

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.1

Name and version of the database you are using: Mysql 5.1.12

Collection categories = getHibernateTemplate().find(
"from Category cat where cat.parentCategory.id = null and (cat.categoryDetails.expire is null or cat.categoryDetails.expire > sysdate)");

I got an unknown column 'sysdate' exception. Pls help, Thanks !

regards,
Mark

ramnath · **Posted:** Tue Jan 03, 2006 5:28 am

More info required.

what is sysdate? column or value of a Date Object????????

ouzo · **Joined:** Wed May 05, 2004 8:01 am **Posts:** 53

as sysdate is a no arg function the query syntax should be:

from Category cat where cat.parentCategory.id = null and (cat.categoryDetails.expire is null or cat.categoryDetails.expire > sysdate())

did that help?

prettyhandling · **Joined:** Mon Aug 02, 2004 9:33 am **Posts:** 69

I went to http://www.hibernate.org/hib_docs/refer ... ryhql.html

and found that hibernate able to distinguish sysdate just like when u do a select sysdate in oracle database !

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

i think that sysdate in mysql is
now() or curdate()
but for this query it is better usage parameter and add date from java (it work for any database)
another problem with this query is

cat.parentCategory.id = null

this return no rows always - it is false always