错误信息
Hibernate:
select
first 0 agentstate0_.id as id2_,
agentstate0_.agentid as agentid2_,
agentstate0_.agentpassword as agentpas3_2_,
agentstate0_.agenttype as agenttype2_,
agentstate0_.apptype as apptype2_,
agentstate0_.autoidle as autoidle2_,
agentstate0_.autoworkinterval as autowork7_2_,
agentstate0_.autoworkon as autoworkon2_,
agentstate0_.devicenumber as devicenu9_2_,
agentstate0_.donotdistribute as donotdi10_2_,
agentstate0_.group_id as group11_2_,
agentstate0_.phonetype as phonetype2_
from
cts_agentinfo agentstate0_
where
agentstate0_.group_id='999999'
WARN - SQL Error: -201, SQLState: 42000
ERROR - A syntax error has occurred.
ERROR - Error:
org.hibernate.exception.SQLGrammarException: could not execute query
原因1：hibernate方言有问题
原因2：hibernate设置分页的first与max为0；