HTTP Status 500 - Parameter createDate does not exist as a named parameter in [FROM InfoArticle infoArticle WHERE infoArticle.infoType.id = :infoTypeId AND infoArticle.isClosed='1' AND infoArticle.createDate >= '2022-09-01 00:00:00' ORDER BY infoArticle.isTop DESC,infoArticle.createDate DESC]


type Exception report

message Parameter createDate does not exist as a named parameter in [FROM InfoArticle infoArticle WHERE infoArticle.infoType.id = :infoTypeId AND infoArticle.isClosed='1' AND infoArticle.createDate >= '2022-09-01 00:00:00' ORDER BY infoArticle.isTop DESC,infoArticle.createDate DESC]

description The server encountered an internal error that prevented it from fulfilling this request.

exception

java.lang.IllegalArgumentException: Parameter createDate does not exist as a named parameter in [FROM InfoArticle infoArticle WHERE infoArticle.infoType.id = :infoTypeId AND infoArticle.isClosed='1' AND infoArticle.createDate >= '2022-09-01 00:00:00'  ORDER BY infoArticle.isTop DESC,infoArticle.createDate DESC]
	org.hibernate.impl.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:356)
	org.hibernate.impl.AbstractQueryImpl.setString(AbstractQueryImpl.java:643)
	com.cl.framework.dao.HibernateDAOSupport.getQueryWithParameter(HibernateDAOSupport.java from InputFileObject:411)
	com.cl.framework.dao.HibernateDAOSupport$15.doInHibernate(HibernateDAOSupport.java from InputFileObject:381)
	org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
	org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
	com.cl.framework.dao.HibernateDAOSupport.findAll(HibernateDAOSupport.java from InputFileObject:378)
	com.fpscc.info.dao.hibernate.InfoArticleDAOImpl.getNextInfoByIdAndTime(InfoArticleDAOImpl.java from InputFileObject:101)
	com.fpscc.info.service.impl.InfoArticleServiceImpl.getNextInfoByIdAndTime(InfoArticleServiceImpl.java from InputFileObject:70)
	sun.reflect.GeneratedMethodAccessor358.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
	org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	$Proxy19.getNextInfoByIdAndTime(Unknown Source)
	com.cl.webnew.newsList.action.NewsListAction.look(NewsListAction.java from InputFileObject:324)
	sun.reflect.GeneratedMethodAccessor194.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:892)
	ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1294)
	ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68)
	com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:117)
	com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:108)
	ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1370)
	ognl.ASTMethod.getValueBody(ASTMethod.java:91)
	ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
	ognl.SimpleNode.getValue(SimpleNode.java:258)
	ognl.Ognl.getValue(Ognl.java:467)
	ognl.Ognl.getValue(Ognl.java:431)
	com.opensymphony.xwork2.ognl.OgnlUtil$3.execute(OgnlUtil.java:352)
	com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecuteMethod(OgnlUtil.java:404)
	com.opensymphony.xwork2.ognl.OgnlUtil.callMethod(OgnlUtil.java:350)
	com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:430)
	com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:290)
	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:251)
	com.cl.framework.interceptor.ActionParameterInterceptor.intercept(ActionParameterInterceptor.java from InputFileObject:121)
	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
	com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:168)
	com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
	com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
	org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:76)
	com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
	com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
	com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229)
	com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
	com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
	com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
	com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:140)
	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
	com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
	com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
	org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
	com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
	com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)
	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
	org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
	org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:575)
	org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:81)
	org.apache.struts2.dispatcher.ng.filter.StrutsExecuteFilter.doFilter(StrutsExecuteFilter.java:93)
	org.apache.struts2.dispatcher.ng.filter.StrutsPrepareFilter.doFilter(StrutsPrepareFilter.java:91)
	com.fpscc.filter.MyStrutsPrepareFilter.doFilter(MyStrutsPrepareFilter.java from InputFileObject:25)
	com.cl.framework.filter.XssFilter.doFilter(XssFilter.java from InputFileObject:36)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.50 logs.


Apache Tomcat/7.0.50