mysql hql top_hibernate mysql 分页时报错显示的代码和sql server 类似 select top 1……...-CSDN博客

本文链接：https://blog.csdn.net/weixin_34820733/article/details/113428958

[ERROR][com.alibaba.druid.filter.stat.StatFilter]merge sql error, dbType mysql, sql :

select top 1 ddiary0_.diary_id as diary_id1_9_, ddiary0_.site_id as site_id26_9_, ddiary0_.catalog_id as catalog27_9_, ddiary0_.user_id as user_id28_9_, ddiary0_.annex_id as annex_id2_9_, ddiary0_.client_agent as client_a3_9_, ddiary0_.client_ip as client_i4_9_, ddiary0_.client_type as client_t5_9_, ddiary0_.content as content6_9_, ddiary0_.contribute as contribu7_9_, ddiary0_.diary_size as diary_si8_9_, ddiary0_.ext1 as ext9_9_, ddiary0_.ext2 as ext10_9_, ddiary0_.ext3 as ext11_9_, ddiary0_.ext4 as ext12_9_, ddiary0_.last_read_time as last_re13_9_, ddiary0_.last_reply_time as last_re14_9_, ddiary0_.locked as locked15_9_, ddiary0_.modify_time as modify_16_9_, ddiary0_.mood_level as mood_le17_9_, ddiary0_.reply_count as reply_c18_9_, ddiary0_.reply_notify as reply_n19_9_, ddiary0_.role as role20_9_, ddiary0_.type_id as type_id29_9_, ddiary0_.tag as tag21_9_, ddiary0_.title as title22_9_, ddiary0_.txt as txt23_9_, ddiary0_.view_count as view_co24_9_, ddiary0_.write_time as write_t25_9_ from wxs.d_diary ddiary0_ where ddiary0_.diary_id and ddiary0_.user_id=? order by ddiary0_.diary_id desc1068481ncom.alibaba.druid.sql.parser.ParserException: syntax error, error in :' top 1 ddiary0_.diary_id as diary_i',expect LITERAL_INT, actual LITERAL_INT top

at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:210)

at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:307)

at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:112)

at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:107)

at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:54)

at com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:145)

at com.alibaba.druid.filter.stat.StatFilter.createSqlStat(StatFilter.java:629)

at com.alibaba.druid.filter.stat.StatFilter.statementPrepareAfter(StatFilter.java:305)

at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:124)

at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448)

at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:342)

at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:318)

at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:162)

at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:186)

at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:160)

at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1885)

at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862)

at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)

at org.hibernate.loader.Loader.doQuery(Loader.java:910)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)

at org.hibernate.loader.Loader.doList(Loader.java:2554)

at org.hibernate.loader.Loader.doList(Loader.java:2540)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)

at org.hibernate.loader.Loader.list(Loader.java:2365)

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)

at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)

at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)

at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)

at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)

at com.cx.wxs.base.dao.BaseDaoImpl.get(BaseDaoImpl.java:557)

at com.cx.wxs.dao.impl.DDiaryDaoImpl.getCurrentDiarys(DDiaryDaoImpl.java:171)

at com.cx.wxs.service.impl.DDiaryServiceImpl.getCurrentDiarys(DDiaryServiceImpl.java:92)

at com.cx.wxs.action.diary.diaryAction.articlePreview(diaryAction.java:139)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)

at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:806)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:729)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)