操作错误,请参考原因或联系系统管理员


classclass com.jmst.sql.JmstSQLException
messageorg.hibernate.hql.ast.QuerySyntaxException: unexpected token: A near line 1, column 570 [select count(*) from com.jmst.webpublish.objects.Article where boardID in (12,103,107,201,202,203,204,401,402,403,404,601,602,603,701,702,703,704,301,302,303,304,307,308,7011,7012,7013,7014,7015,7016,801,504,1001,1002,1003,1004,1110,1111,1112,1101,1102,506,507,508,110101,5061,5062,5063,5064,5065,5066,5067,5071,5072,5073,5074,5075,5076,5077,5078,5081,5082,5083,5084,5085,5086,1103,1104,1105,1106,11101,11102,11103,11104,11105,11106,11107,11108,1111,1112,6041,6042,6043,6011,6012,6013,6014,6015,6016,6017,6018,6021,6022,6023,6024,6031,6032,5024,7017,5068,7019,5069,506A,97,501) and time>CONVERT(varchar(12),getdate()-3,23)]
0com.jmst.sql.hibernate.HibernateHelper.queryCount(HibernateHelper.java:786)
1com.jmst.webpublish.struts.action.jmst.SearchContent.SearchNewArticle(SearchContent.java:51)
2sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
3sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
4sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
5java.lang.reflect.Method.invoke(Method.java:597)
6org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
7org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
8org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
9org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
10org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
11org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
12org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
13org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
14org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
15org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
16org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
17javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
18javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
19org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
20org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
21com.jmst.SystemFilter.ParamsFilters2.doFilter(ParamsFilters2.java:78)
22org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
23org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
24com.jmst.SystemFilter.ParamsFilters.doFilter(ParamsFilters.java:39)
25org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
26org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
27com.jmst.servlet.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:102)
28org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
29org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
30org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
31org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
32org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
33org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
34org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:517)
35org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
36org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)
37org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
38org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)
39org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
40java.lang.Thread.run(Thread.java:619)
classclass org.hibernate.hql.ast.QuerySyntaxException
messageunexpected token: A near line 1, column 570 [select count(*) from com.jmst.webpublish.objects.Article where boardID in (12,103,107,201,202,203,204,401,402,403,404,601,602,603,701,702,703,704,301,302,303,304,307,308,7011,7012,7013,7014,7015,7016,801,504,1001,1002,1003,1004,1110,1111,1112,1101,1102,506,507,508,110101,5061,5062,5063,5064,5065,5066,5067,5071,5072,5073,5074,5075,5076,5077,5078,5081,5082,5083,5084,5085,5086,1103,1104,1105,1106,11101,11102,11103,11104,11105,11106,11107,11108,1111,1112,6041,6042,6043,6011,6012,6013,6014,6015,6016,6017,6018,6021,6022,6023,6024,6031,6032,5024,7017,5068,7019,5069,506A,97,501) and time>CONVERT(varchar(12),getdate()-3,23)]
0org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
1org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
2org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
3org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:258)
4org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
5org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
6org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:77)
7org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:56)
8org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
9org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
10org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
11org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
12com.jmst.sql.hibernate.HibernateHelper.queryCount(HibernateHelper.java:775)
13com.jmst.webpublish.struts.action.jmst.SearchContent.SearchNewArticle(SearchContent.java:51)
14sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
16sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
17java.lang.reflect.Method.invoke(Method.java:597)
18org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
19org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
20org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
21org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
22org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
23org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
24org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
25org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
26org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
27org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
28org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
29javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
30javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
31org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
32org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
33com.jmst.SystemFilter.ParamsFilters2.doFilter(ParamsFilters2.java:78)
34org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
35org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
36com.jmst.SystemFilter.ParamsFilters.doFilter(ParamsFilters.java:39)
37org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
38org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
39com.jmst.servlet.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:102)
40org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
41org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
42org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
43org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
44org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
45org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
46org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:517)
47org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
48org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)
49org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
50org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)
51org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
52java.lang.Thread.run(Thread.java:619)