Unexpected token: single quotes?

mina79 · **Joined:** Sun Oct 21, 2007 3:58 pm **Posts:** 1

Hello,

I have following query:

Code:

List found =  getHibernateTemplate().find("from Position where (select now()- interval '24 hours' < time and pos.tag=?", tag.getMacAddr());

Unfortunately I get error:

nexpected token: '24 hours' near line 1, column 58 [from fi.mst.model.Position where (select now()- interval '24 hours' < time and pos.tag=?]; nested exception is org.hibernate.hql.ast.QuerySyntaxException:

I guess that the problem is the single quotes. How could I fix this problem?

himawan · **Joined:** Sat Aug 19, 2006 6:31 pm **Posts:** 139

Have you tried escaping the single quotes using \?

cosmo1t · **Joined:** Tue Oct 23, 2007 3:53 pm **Posts:** 1

I think the error is from the keyword interval. I'm dealing with the same issue right now.