自由飞翔

我在仰望,java之上

统计

留言簿(2)

我关注的blog

阅读排行榜

评论排行榜

异常积累: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;



Gavin

posted on 2011-10-27 14:33 GavinMiao 阅读(9281) 评论(1)  编辑  收藏 所属分类: 异常积累

评论

# re: 异常积累:org.hibernate.exception.SQLGrammarException: could not execute query-hibernate解释后的sql语句有问题 2016-06-15 21:34 wshiwangite

写的不错,问题解决了...  回复  更多评论   


只有注册用户登录后才能发表评论。


网站导航: