HQL: "from Room room where room.endDt > = ? and room.startDt <= ? "
出現的錯誤信息:
2007-09-05 15:15:19 Hibernate operation: could not execute query; bad SQL grammar
[ select room0_.name as name,room0.id as id ,room0_.modificationDate as odificationDate
from appointment room0_
where (room0_.end_dt> =? )and(room0_.start_dt <=? )and(room0_.entry_by= 'PMC_ITD_KL ' )
order by room0_.modificationDate DESC];
nested exception is java.sql.SQLException: Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '100 room0_.id as id, room0_.subject as subject1_, room0_.resource_code as resour ' at line 1 "
------解决方案--------------------
你这个是sql语法错误，看看哪里写错了
------解决方案--------------------
那就是小错误 比如 ' '没写什么的 自己检查啊