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

分页问题，点击上一页首页没报错，但点击下一页尾页报错。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 606 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-获取
1409
1
0
new Configuration() 报错#JAVA 框架-Hibernate-hello
3110
1
0
关于hibernate指定查询集合字段的方法?报错
539
1
0
hibernate关系映射配置出错?报错
369
1
0
hibernate抛异常时会自己关闭连接吗？?报错
450
1
0
ssh保存数据报错org.hibernate.event.PreInsertEv?报错
458
1
0
spring4 整合 hibernate4，org.hibernate.engi?报错
415
1
0
hibernate一对多单向注解配置：报错
37439
1
0
hibernate 获得的object 如何转化为pojo类??报错
374
1
0
hibernate有延迟关闭session的配置，mybatis有没有类似配置？：报错
707
1
0
问答排行榜
最热
最新
1 通过阿里云代备案系统进行个人快速备案 2699967
2 【大咖问答】对话PostgreSQL 中国社区发起人之一，阿里云数据库高级专家 德哥 1818367
3 据说在家办公的程序员是这样写代码的？ 1792409
4 阿里云开放端口权限 689954
5 如何升级配置 536086
6 【藏经阁一起读（27）】本周推荐《Apache Flink案例集（2022版）》，你有哪些心得？ 522491
7 【精品问答】python技术1000问(1) 514018
8 Flink Forward Asia 2021 有奖问答 512822
9 Linux Bash严重漏洞修复紧急通知（已全部给出最终修复方案） 456932
10 OceanBase 使用动画（持续更新） 359283
11 阿里云LNAMP(Linux + Nginx + Apache + MySQL + PHP)环境一键安装脚本 329732
12 OSS存储服务-客户端工具 321366
13 为体验实验室取一个新名字。 307349
14 企业邮箱发送邮件时，若出现投递失败产生退信，内容提示包含如下： 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 303895
15 Win Server 2003-2016 加密勒索事件必打补丁合集 295179
16 FLASH播放器，在IE浏览器下显示请确定您的域名已完成备案和CNAME绑定 283711
17 安全组详解，新手必看教程 277269
18 写code还是做管理，开发者如何进行职业规划？ 268543
19 惊喜翻倍：免费ECS+免费环境配置~！(ECS免费体验6个月活动3月31日结束) 255838
20 阿里云手机和阿云浏览器连接问题专帖 235642
1 使用PAI-快速开始，低代码实现大语言模型微调和部署，并分享配置过程、输出结果及使用体验 146
2 展示你用FaceChain-FACT生成人物写真，并分享配置过程、输出结果及使用体验 154
3 结合自己的项目上云经历，分享部署过程及体验 295
4 丹青-千变万换，体验图片局部内容替换，分享使用过程、输出结果及使用体验 523
5 使用PAI-EAS一键部署ChatGLM，并应用LangChain集成外部数据 588
6 使用通义灵码冲刺备战求职季，你有哪些深刻体验？ 719
7 分享出你的「松弛感工作」必备AI技能，并展示使用效果 862
8 “AI+作业”，是辅助还是颠覆？ 352
9 乘风问答官七月排位赛开启！CHERRY樱桃MX2.0S无线键盘等好礼等你赢~ 212
10 通用大模型VS垂直大模型，你倾向于哪一方？ 435
11 如何破除工作中的“路径依赖”？ 427
12 宜搭自定义页面，如何实现这样的效果，请帮忙给一个实例 170
13 一键生成你眼中的未来城市，分享部署过程、输出结果及使用体验 1173
14 展示你用AI工具生成动漫头像，并分享配置过程及使用体验 734
15 通义灵码：该账号暂无通义灵码使用权限，可更换其他有权限的账号。或联系企业管理员获取使用权限。 120
16 ModelScope有部署qwen2-72b的么，正常推理需要多大的显存？ 358
17 国内AI大模型高考数学成绩超GPT-4o，如何看待这一结果？ 892
18 如何避免“写代码5分钟，调试2小时”的尴尬？ 1046
19 通义灵码生成Git Commit的时候，偶尔生成中文，偶尔生成英文，根本无法控制生成的语言。 323
20 通义灵码登录失败，提示通义灵码域名无法解析 238
推荐问答
乘风问答官招募中！机械键盘免费拿

相关文章

  • 利用 DataWorks 数据推送定期推播 ClickHouse Query 诊断信息
  • 实战算法的基础入门（3）
  • 个人项目中技术落地的基础入门（1）
  • 个人项目中技术落地的基础入门（2）
  • 个人项目中技术落地的基础入门（3）

    • 相关电子书

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