org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: 10 near line 1, column 111 [from com.scihi.cms.entity.main.Order where orderStatus = 2 and TIMESTAMPDIFF(SECOND,DATE_ADD(buyDate,INTERVAL 10 DAY_MINUTE),now())>0]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 10 near line 1, column 111 [from com.scihi.cms.entity.main.Order where orderStatus = 2 and TIMESTAMPDIFF(SECOND,DATE_ADD(buyDate,INTERVAL 10 DAY_MINUTE),now())>0]
from com.scihi.cms.entity.main.Order where orderStatus = 2 and TIMESTAMPDIFF(SECOND,DATE_ADD(buyDate,INTERVAL 10 DAY_MINUTE),now())>0
hql语句不支持吗？ 怎么修改
------解决思路----------------------
不支持的你把那个createQuery改成createSQLQuery，，，因为你用Sql语句
------解决思路----------------------
TIMESTAMPDIFF(SECOND,DATE_ADD(buyDate,INTERVAL 10 DAY_MINUTE),now()) 这一段是用的sql写的吧？
------解决思路----------------------
String sql ="select m_user.`name`,m_user.mobile,m_user.imgurl FROM m_user INNER JOIN m_address_book ON m_address_book.user_id=m_user.id";
Query query =dao.getCurrentSession().createSQLQuery(sql);
------解决思路----------------------
又是 HQL 又是 SQL ？你要么纯HQL 要么纯SQL 你后面有段是用sql写的 不是hql 所以hibernate无法识别
------解决思路----------------------
你就用sql写呗 多自由呀