异常积累：org.hibernate.exception.SQLGrammarException: could not execute query-hibernate解释后的sql语句有问题...

 

错误信息
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；

转载于:https://my.oschina.net/ZYLzzz/blog/745470