Oracle数据库转MYSQL后出现Every derived table must have its own alias语法错误

[daguzhang]

Oracle数据库里面一切正常，换成mysql5.6后分页出现Every derived table must have its own alias语法错误，麻烦大神帮忙，多谢！！！
环境：mysql5.6 + hibernate3

connector: mysql-connector-java-5.1.34

hibernate配置：
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mysqldb?useUnicode=true&characterEncoding=UTF-8
username=root
password=1234

出错语句:
Query q = session.createQuery(hql);
//return q.list(); 如果不分页就没有错误
return q.setFirstResult((page - 1) * rows).setMaxResults(rows).list();//加上分页就报错

详细错误：
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Every derived table must have its own alias
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
at com.mysql.jdbc.Util.getInstance(Util.java:360)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 58 more

[大猫队长]

q.list() 会把 语句转换成 SELECT * from (SELECT * from XXX) 吧？ 你可以输出sql试试 ，mysql 不支持这种 》》》》》这我执行这种语句的结果》》》》》》 [SQL]SELECT * from (SELECT * from user) [Err] 1248 - Every derived table must have its own alias

[daguzhang]

谢谢 我如果不用分页 只用 q.list();是不报错的，可以出来结果

[听雪飞鸟]

看看你的数据库方言对不对，从oracle转换成mysql记得要把方言改过来。