Mysql过错:Every derived table must have its own aliasITeye - 千亿集团

Mysql过错:Every derived table must have its own aliasITeye

2019年03月30日12时02分22秒 | 作者: 耘志 | 标签: 反常,问题,现在 | 浏览: 2887

请教别号反常Every derived table must have its own alias 控制台:rn ···getList HQLfrom Temp where username=? and password=?rnHibernate: select * from ( select temp0_.ID as ID0_, temp0_.usname as usname0_, temp0_.paword as paword0_ from temp temp0_ where temp0_.usname=? and temp0_.paword=? ) where rownum = ?rn2011-06-30 15:28:14,402 ERROR (org.hibernate.util.JDBCExceptionReporter:78) -[color=#FF0000] Every derived table must have its own alias[/color]loadPOJP is errorrnorg.hibernate.exception.SQLGrammarException: could not execute queryrn···rn项目原本一直是用oracle数据库的,也没呈现过什么问题,现在我用mysql,建了个表趁便一测验就报不可思议的反常,悲惨剧!结构承继的Dao类应该是没问题的,但现在反常却报在Dao类里~~~~rn相同的hibernate句子如果是回来List目标是不会报反常,但回来单个目标就报上面的反常,rn不知道有朋友遇到过相同的问题没有?rnhibernate句子很简单,不是语法错误,有朋友说是结构和mysql的版别问题~~~~rn

版权声明
本文来源于网络,版权归原作者所有,其内容与观点不代表千亿集团立场。转载文章仅为传播更有价值的信息,如采编人员采编有误或者版权原因,请与我们联系,我们核实后立即修改或删除。

猜您喜欢的文章