AI 助理
备案控制台
开发者社区> 问答> 正文

分页问题，点击上一页首页没报错，但点击下一页尾页报错。hibernate4 db2?报错

数据库是db2 9.7      hibernate4    点击分页上一页或首页没问题，但点击下一页或最后一页就报错。

Hibernate: select tsuserstb0_.USERID as USERID1_1_, tsuserstb0_.CREASTAF as CREASTAF2_1_, tsuserstb0_.CREATIME as CREATIME3_1_, tsuserstb0_.LOCORGNO as LOCORGNO4_1_, tsuserstb0_.PWDMODIFYTIME as PWDMODIF5_1_, tsuserstb0_.REMARK01 as REMARK6_1_, tsuserstb0_.REMARK02 as REMARK7_1_, tsuserstb0_.STAORGNO as STAORGNO8_1_, tsuserstb0_.UPDASTAF as UPDASTAF9_1_, tsuserstb0_.UPDATIME as UPDATIM10_1_, tsuserstb0_.USERNAME as USERNAM11_1_, tsuserstb0_.USERPWD as USERPWD12_1_, tsuserstb0_.USERSTATE as USERSTA13_1_ from TS_USERSTB tsuserstb0_ fetch first 10 rows only

Hibernate: select count(*) as col_0_0_ from TS_USERSTB tsuserstb0_
Hibernate: select * from ( select inner2_.*, rownumber() over(order by order of inner2_) as rownumber_ from ( select tsuserstb0_.USERID as USERID1_1_, tsuserstb0_.CREASTAF as CREASTAF2_1_, tsuserstb0_.CREATIME as CREATIME3_1_, tsuserstb0_.LOCORGNO as LOCORGNO4_1_, tsuserstb0_.PWDMODIFYTIME as PWDMODIF5_1_, tsuserstb0_.REMARK01 as REMARK6_1_, tsuserstb0_.REMARK02 as REMARK7_1_, tsuserstb0_.STAORGNO as STAORGNO8_1_, tsuserstb0_.UPDASTAF as UPDASTAF9_1_, tsuserstb0_.UPDATIME as UPDATIM10_1_, tsuserstb0_.USERNAME as USERNAM11_1_, tsuserstb0_.USERPWD as USERPWD12_1_, tsuserstb0_.USERSTATE as USERSTA13_1_ from TS_USERSTB tsuserstb0_ fetch first 20 rows only ) as inner2_ ) as inner1_ where rownumber_ > 10 order by rownumber_
[com.alibaba.druid.filter.stat.StatFilter]merge sql error, dbType db2, sql :
select * from ( select inner2_.*, rownumber() over(order by order of inner2_) as rownumber_ from ( select tsuserstb0_.USERID as USERID1_1_, tsuserstb0_.CREASTAF as CREASTAF2_1_, tsuserstb0_.CREATIME as CREATIME3_1_, tsuserstb0_.LOCORGNO as LOCORGNO4_1_, tsuserstb0_.PWDMODIFYTIME as PWDMODIF5_1_, tsuserstb0_.REMARK01 as REMARK6_1_, tsuserstb0_.REMARK02 as REMARK7_1_, tsuserstb0_.STAORGNO as STAORGNO8_1_, tsuserstb0_.UPDASTAF as UPDASTAF9_1_, tsuserstb0_.UPDATIME as UPDATIM10_1_, tsuserstb0_.USERNAME as USERNAM11_1_, tsuserstb0_.USERPWD as USERPWD12_1_, tsuserstb0_.USERSTATE as USERSTA13_1_ from TS_USERSTB tsuserstb0_ fetch first 20 rows only ) as inner2_ ) as inner1_ where rownumber_ > 10 order by rownumber_
com.alibaba.druid.sql.parser.ParserException: syntax error, expect RPAREN, actual IDENTIFIER of
    at com.alibaba.druid.sql.parser.SQLExprParser.accept(SQLExprParser.java:1590)
    at com.alibaba.druid.sql.parser.SQLExprParser.over(SQLExprParser.java:1040)
    at com.alibaba.druid.sql.parser.SQLExprParser.parseAggregateExpr(SQLExprParser.java:1013)
    at com.alibaba.druid.sql.parser.SQLExprParser.methodRest(SQLExprParser.java:753)
    at com.alibaba.druid.sql.parser.SQLExprParser.primaryRest(SQLExprParser.java:727)
    at com.alibaba.druid.sql.parser.SQLExprParser.parseSelectItem(SQLExprParser.java:1881)
    at com.alibaba.druid.sql.parser.SQLSelectParser.parseSelectList(SQLSelectParser.java:359)
    at com.alibaba.druid.sql.dialect.db2.parser.DB2SelectParser.query(DB2SelectParser.java:72)
    at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:62)
    at com.alibaba.druid.sql.parser.SQLSelectParser.parseTableSource(SQLSelectParser.java:386)
    at com.alibaba.druid.sql.parser.SQLSelectParser.parseFrom(SQLSelectParser.java:378)
    at com.alibaba.druid.sql.dialect.db2.parser.DB2SelectParser.query(DB2SelectParser.java:74)
    at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:62)
    at com.alibaba.druid.sql.parser.SQLStatementParser.parseSelect(SQLStatementParser.java:1771)
    at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:180)
    at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:145)
    at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:140)
    at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:53)
    at com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:145)
    at com.alibaba.druid.filter.stat.StatFilter.createSqlStat(StatFilter.java:630)
    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:331)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:159)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:183)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:157)
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1881)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1858)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
    at org.hibernate.loader.Loader.doQuery(Loader.java:906)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
    at org.hibernate.loader.Loader.doList(Loader.java:2550)
    at org.hibernate.loader.Loader.doList(Loader.java:2536)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)
    at org.hibernate.loader.Loader.list(Loader.java:2361)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)
    at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1230)
    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
    at hx.dao.base.Impl.BaseDaoImpl.find(BaseDaoImpl.java:127)
    at hx.service.sysmanage.Impl.TsUserstbServiceImpl.datagrid(TsUserstbServiceImpl.java:78)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
    at com.sun.proxy.$Proxy22.datagrid(Unknown Source)
    at hx.action.TsUserstbAction.datagrid(TsUserstbAction.java:83)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:891)
    at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1293)
    at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68)
    at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:117)
    at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:108)
    at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1369)
    at ognl.ASTMethod.getValueBody(ASTMethod.java:90)
    at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
    at ognl.SimpleNode.getValue(SimpleNode.java:258)
    at ognl.Ognl.getValue(Ognl.java:494)
    at ognl.Ognl.getValue(Ognl.java:458)
    at com.opensymphony.xwork2.ognl.OgnlUtil$2.execute(OgnlUtil.java:309)
    at com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecute(OgnlUtil.java:340)
    at com.opensymphony.xwork2.ognl.OgnlUtil.getValue(OgnlUtil.java:307)
    at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:423)
    at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:287)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:250)
    at org.apache.struts2.interceptor.DeprecationInterceptor.intercept(DeprecationInterceptor.java:41)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
    at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:76)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at org.apache.struts2.interceptor.DateTextFieldInterceptor.intercept(DateTextFieldInterceptor.java:125)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:253)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:139)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
    at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
    at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:564)
    at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:81)
    at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:151)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1008)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1852)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
    at java.lang.Thread.run(Thread.java:662)
Hibernate: select count(*) as col_0_0_ from TS_USERSTB tsuserstb0_

展开
收起
爱吃鱼的程序员 2020-06-09 16:39:05 634 0
1 条回答
写回答
取消 提交回答
  • 爱吃鱼的程序员
    https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIB

    我测试最新版本是好的，你升级到最新版本druid-1.0.8吧

    http://repo1.maven.org/maven2/com/alibaba/druid/1.0.18/

    <!--druid--><dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>1.0.18</version></dependency>我已经用1.0.18了

    @wenshao

    这是我的service

    @Override
       publicDatagriddatagrid(Userstbuserstb){
          Datagriddg=newDatagrid();
          Stringhql="fromTsUserstbt";
          StringtotalHql="selectcount(*)"+hql;
          List<TsUserstb>ltu=tsUserstbDao.find(hql,userstb.getPage(),userstb.getRows());
          List<Userstb>lu=newArrayList<Userstb>();
          if(ltu!=null&&ltu.size()>0){
             for(TsUserstbt:ltu){
                Userstbu=newUserstb();
                BeanUtils.copyProperties(t,u);
                lu.add(u);
             }
          }
          dg.setTotal(tsUserstbDao.count(totalHql));
          dg.setRows(lu);
          returndg;
       }



    这是dao

    publicList<T>find(Stringhql,intpage,introws){
          Queryq=this.getCurrentSession().createQuery(hql);
          returnq.setFirstResult((page-1)*rows).setMaxResults(rows).list();
       }

    over(orderbyorderofinner2_)这个语法比较奇怪。

    不过这个应该只是logerror，不影响运行吧。

    很奇怪com.alibaba.druid.sql.parser.ParserException:syntaxerror,errorin:'ascfetchfirst20rowsonly',expectFETCH,actualFETCHfetch嗯，运行是不影响的。但这个错误看起来很难过。我把这个语句单独在db2上执行没有报错的。看起来确实很奇怪

    @wenshao

    Hibernate:selecttsuserstb0_.USERIDasUSERID1_1_,tsuserstb0_.CREASTAFasCREASTAF2_1_,tsuserstb0_.CREATIMEasCREATIME3_1_,tsuserstb0_.LOCORGNOasLOCORGNO4_1_,tsuserstb0_.PWDMODIFYTIMEasPWDMODIF5_1_,tsuserstb0_.REMARK01asREMARK6_1_,tsuserstb0_.REMARK02asREMARK7_1_,tsuserstb0_.STAORGNOasSTAORGNO8_1_,tsuserstb0_.UPDASTAFasUPDASTAF9_1_,tsuserstb0_.UPDATIMEasUPDATIM10_1_,tsuserstb0_.USERNAMEasUSERNAM11_1_,tsuserstb0_.USERPWDasUSERPWD12_1_,tsuserstb0_.USERSTATEasUSERSTA13_1_fromTS_USERSTBtsuserstb0_orderbytsuserstb0_.USERIDascfetchfirst20rowsonly
    [com.alibaba.druid.filter.stat.StatFilter]mergesqlerror,dbTypedb2,sql:
    selecttsuserstb0_.USERIDasUSERID1_1_,tsuserstb0_.CREASTAFasCREASTAF2_1_,tsuserstb0_.CREATIMEasCREATIME3_1_,tsuserstb0_.LOCORGNOasLOCORGNO4_1_,tsuserstb0_.PWDMODIFYTIMEasPWDMODIF5_1_,tsuserstb0_.REMARK01asREMARK6_1_,tsuserstb0_.REMARK02asREMARK7_1_,tsuserstb0_.STAORGNOasSTAORGNO8_1_,tsuserstb0_.UPDASTAFasUPDASTAF9_1_,tsuserstb0_.UPDATIMEasUPDATIM10_1_,tsuserstb0_.USERNAMEasUSERNAM11_1_,tsuserstb0_.USERPWDasUSERPWD12_1_,tsuserstb0_.USERSTATEasUSERSTA13_1_fromTS_USERSTBtsuserstb0_orderbytsuserstb0_.USERIDascfetchfirst20rowsonly
    com.alibaba.druid.sql.parser.ParserException:syntaxerror,errorin:'ascfetchfirst20rowsonly',expectFETCH,actualFETCHfetch
       atcom.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:232)
       atcom.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:407)
       atcom.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:145)
       atcom.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:140)
       atcom.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:53)
       atcom.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:145)
       atcom.alibaba.druid.filter.stat.StatFilter.createSqlStat(StatFilter.java:630)
       atcom.alibaba.druid.filter.stat.StatFilter.statementPrepareAfter(StatFilter.java:305)
       atcom.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:124)
       atcom.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448)
       atcom.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:342)
       atcom.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:331)
       atorg.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:159)
       atorg.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:183)
       atorg.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:157)
       atorg.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1881)
       atorg.hibernate.loader.Loader.executeQueryStatement(Loader.java:1858)
       atorg.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
       atorg.hibernate.loader.Loader.doQuery(Loader.java:906)
       atorg.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
       atorg.hibernate.loader.Loader.doList(Loader.java:2550)
       atorg.hibernate.loader.Loader.doList(Loader.java:2536)
       atorg.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)
       atorg.hibernate.loader.Loader.list(Loader.java:2361)
       atorg.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)
       atorg.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)
       atorg.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198)
       atorg.hibernate.internal.SessionImpl.list(SessionImpl.java:1230)
       atorg.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
       athx.dao.base.Impl.BaseDaoImpl.find(BaseDaoImpl.java:127)
       athx.service.sysmanage.Impl.TsUserstbServiceImpl.datagrid(TsUserstbServiceImpl.java:81)
       atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)
       atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       atjava.lang.reflect.Method.invoke(Method.java:597)
       atorg.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
       atorg.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
       atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
       atorg.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
       atorg.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
       atorg.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
       atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
       atorg.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
       atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
       atorg.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
       atcom.sun.proxy.$Proxy22.datagrid(UnknownSource)
       athx.action.TsUserstbAction.datagrid(TsUserstbAction.java:83)
       atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)
       atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       atjava.lang.reflect.Method.invoke(Method.java:597)
       atognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:891)
       atognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1293)
       atognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68)
       atcom.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:117)
       atcom.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:108)
       atognl.OgnlRuntime.callMethod(OgnlRuntime.java:1369)
       atognl.ASTMethod.getValueBody(ASTMethod.java:90)
       atognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
       atognl.SimpleNode.getValue(SimpleNode.java:258)
       atognl.Ognl.getValue(Ognl.java:494)
       atognl.Ognl.getValue(Ognl.java:458)
       atcom.opensymphony.xwork2.ognl.OgnlUtil$2.execute(OgnlUtil.java:309)
       atcom.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecute(OgnlUtil.java:340)
       atcom.opensymphony.xwork2.ognl.OgnlUtil.getValue(OgnlUtil.java:307)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:423)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:287)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:250)
       atorg.apache.struts2.interceptor.DeprecationInterceptor.intercept(DeprecationInterceptor.java:41)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atorg.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atcom.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)
       atcom.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atcom.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
       atorg.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:76)
       atcom.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atcom.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atcom.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229)
       atcom.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atcom.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229)
       atcom.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atcom.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atorg.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atorg.apache.struts2.interceptor.DateTextFieldInterceptor.intercept(DateTextFieldInterceptor.java:125)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atorg.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atorg.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:253)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atcom.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atcom.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atcom.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atcom.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
       atcom.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atcom.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:139)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atorg.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atcom.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atcom.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)
       atcom.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
       atorg.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
       atorg.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:564)
       atorg.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:81)
       atorg.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)
       atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
       atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
       atorg.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:151)
       atorg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
       atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
       atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
       atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
       atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
       atorg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
       atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
       atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
       atorg.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
       atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
       atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
       atorg.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1008)
       atorg.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
       atorg.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1852)
       atjava.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
       atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
       atjava.lang.Thread.run(Thread.java:662)
    Hibernate:selectcount(*)ascol_0_0_fromTS_USERSTBtsuserstb0_

    2020-06-09 16:39:22
    赞同 展开评论 打赏
问答分类：
SQL Java 关系型数据库 数据库连接 数据库
问答标签：
报错Hibernate
问答地址：
开发者社区 > 数据库 > 问答

版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

相关问答
为什么我GET的时候，会报错呢？#Hibernate-获取
1425
1
0
new Configuration() 报错#JAVA 框架-Hibernate-hello
3146
1
0
hibernate class标签报错 ?报错
434
1
0
关于hibernate指定查询集合字段的方法?报错
554
1
0
hibernate关系映射配置出错?报错
381
1
0
关于Hibernate discriminator标签的问题?报错
394
1
0
hibernate抛异常时会自己关闭连接吗？?报错
469
1
0
ssh保存数据报错org.hibernate.event.PreInsertEv?报错
475
1
0
spring4 整合 hibernate4，org.hibernate.engi?报错
434
1
0
hibernate一对多单向注解配置：报错
37455
1
0
问答排行榜
最热
最新
1 【大咖问答】对话PostgreSQL 中国社区发起人之一，阿里云数据库高级专家 德哥 1819013
2 据说在家办公的程序员是这样写代码的？ 1793136
3 阿里云开放端口权限 690270
4 如何升级配置 536292
5 【藏经阁一起读（27）】本周推荐《Apache Flink案例集（2022版）》，你有哪些心得？ 522847
6 【精品问答】python技术1000问(1) 514126
7 Flink Forward Asia 2021 有奖问答 512907
8 OceanBase 使用动画（持续更新） 359373
9 阿里云LNAMP(Linux + Nginx + Apache + MySQL + PHP)环境一键安装脚本 329801
10 OSS存储服务-客户端工具 321581
11 为体验实验室取一个新名字。 307477
12 企业邮箱发送邮件时，若出现投递失败产生退信，内容提示包含如下： the mta server of * reply:550 failed to meet SPF requirements 或者 the mta server of 163.com — 163mx01.mxmail.netease.com(220.181.14.141) reply:550 MI:SPF mx14,QMCowECpA0qTiftVaeB3Cg—.872S2 1442548128 http://mail.163.com/help 304089
13 Win Server 2003-2016 加密勒索事件必打补丁合集 295329
14 FLASH播放器，在IE浏览器下显示请确定您的域名已完成备案和CNAME绑定 284203
15 安全组详解，新手必看教程 277341
16 写code还是做管理，开发者如何进行职业规划？ 269138
17 惊喜翻倍：免费ECS+免费环境配置~！(ECS免费体验6个月活动3月31日结束) 255880
18 阿里云手机和阿云浏览器连接问题专帖 235687
19 支付宝H5 下载的时候，提示 【请确保该下载文件来源安全,如需浏览,请长按网址复制后使用浏览器访问】 227733
20 请问阿里云邮箱如何开启SMTP服务啊！ 225866
1 “AI +脱口秀”，笑点能靠算法去创造吗？ 210
2 请教：通过按钮打开另外一个表单，并把其中一个值传递给另一个表单的其中一个字段。 156
3 AI宠物更适合当代年轻人的陪伴需求吗？ 734
4 AI客服未来会完全代替人工吗？ 906
5 “云+AI”能够孵化出多少可能？ 831
6 当AI频繁生成虚假信息，我们还能轻信大模型吗？ 630
7 使用免费证书后 服务器浏览器访问没有问题，外网访问 显示证书不可信，使用同一种浏览器哦 183
8 FFA 2024 大会门票免费送！AI时代下大数据技术未来路在何方？ 1518
9 为什么宜搭的流程流入到钉钉OA审批，钉钉OA审批要收钱啊。。。。 213
10 宜搭UPDATE或UPSERT一次更新数据超过100条怎么办？ 谢谢各位大大帮帮忙！！！ 181
11 通义千问2.5-7B-Instruct已经下载到本地为什么使还需要联网？而且最近下载模型也提示400 107
12 CUDA error: CUDA-capable device(s) is busy 163
13 AI时代，存力or算力哪一个更关键？ 1226
14 求宜搭关联表单的更新方法！！！ 341
15 全网寻找 #六边形战士# 程序员，你的 AI 编码助手身份标签是什么？ 1294
16 老哥们有个需求想请教一下，十分感谢 332
17 关于“通义灵码”而言，这次更新后，他更加人性化，然而我更喜欢fittencode,理由如下 417
18 关于宜搭自定义页面的文本组件循环获取其它表单的子表单数据。 173
19 flink1.20.0 部署后发布报错，是怎么回事，各种配置都配置了 213
20 关于开发者的100件小事，你知道哪些？ 1316
推荐问答
乘风问答官招募中！机械键盘免费拿

相关文章

  • 阿里云数据库获中国计算机学会“科技进步一等奖”！
  • 堡垒机是用来干什么的？堡垒机的好处有什么？
  • 连续四年，稳居第一！
  • 计算机网络的功能
  • JVM进阶调优系列(10)敢向stop the world喊卡的G1垃圾回收器 | 有必要讲透

    • 相关电子书

    更多
    • 低代码开发师（初级）实战教程 立即下载
    冬季实战营第三期：MySQL数据库进阶实战 立即下载
    阿里巴巴DevOps 最佳实践手册 立即下载