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"
出現的錯誤信息:
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"
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货