HTTP Status 500 - com.zving.framework.data.exception.SetParamException: java.sql.SQLException: Parameter index out of range (5 > number of parameters, which is 4).


type Exception report

message com.zving.framework.data.exception.SetParamException: java.sql.SQLException: Parameter index out of range (5 > number of parameters, which is 4).

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

exception

com.zving.framework.data.QueryException: com.zving.framework.data.exception.SetParamException: java.sql.SQLException: Parameter index out of range (5 > number of parameters, which is 4).
	com.zving.framework.data.QueryBuilder.executePagedDataTable(QueryBuilder.java:175)
	com.zving.framework.data.QueryBuilder.executePagedDataTable(QueryBuilder.java:162)
	com.zving.framework.data.QueryBuilder.fetch(QueryBuilder.java:470)
	com.zving.front.tag.VideoListTag.prepareData(VideoListTag.java:77)
	com.zving.staticize.tag.AbstractListTag.onTagStart(AbstractListTag.java:74)
	com.zving.front.tag.VideoListTag.onTagStart(VideoListTag.java:50)
	com.zving.staticize.tag.SimpleTag.doStartTag(SimpleTag.java:30)
	com.zving.framework.template.command.TagCommand.execute(TagCommand.java:44)
	com.zving.framework.template.TemplateExecutor.execute(TemplateExecutor.java:53)
	com.zving.staticize.template.TemplateInstance.execute(TemplateInstance.java:112)
	com.zving.front.ui.VideoFontUI.videoPlay(VideoFontUI.java:311)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	com.zving.framework.core.method.FacadeMemberMethodLocator.execute(FacadeMemberMethodLocator.java:46)
	com.zving.framework.core.handler.ActionHandler.invoke(ActionHandler.java:135)
	com.zving.framework.core.handler.ActionHandler.handle(ActionHandler.java:96)
	com.zving.framework.core.DispatchServlet.handleURL(DispatchServlet.java:337)
	com.zving.framework.core.DispatchServlet.service(DispatchServlet.java:242)
	com.zving.preloader.facade.ServletFacade.service(ServletFacade.java:40)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.zving.front.filter.MirrorPrivFilter.doFilter(MirrorPrivFilter.java:27)
	com.zving.preloader.facade.FilterFacade.doFilter(FilterFacade.java:41)
	org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
	org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
	org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)

root cause

com.zving.framework.data.exception.SetParamException: java.sql.SQLException: Parameter index out of range (5 > number of parameters, which is 4).
	com.zving.framework.data.DataAccess.setParams(DataAccess.java:191)
	com.zving.framework.data.DataAccess.executePagedDataTable(DataAccess.java:336)
	com.zving.framework.data.QueryBuilder.executePagedDataTable(QueryBuilder.java:169)
	com.zving.framework.data.QueryBuilder.executePagedDataTable(QueryBuilder.java:162)
	com.zving.framework.data.QueryBuilder.fetch(QueryBuilder.java:470)
	com.zving.front.tag.VideoListTag.prepareData(VideoListTag.java:77)
	com.zving.staticize.tag.AbstractListTag.onTagStart(AbstractListTag.java:74)
	com.zving.front.tag.VideoListTag.onTagStart(VideoListTag.java:50)
	com.zving.staticize.tag.SimpleTag.doStartTag(SimpleTag.java:30)
	com.zving.framework.template.command.TagCommand.execute(TagCommand.java:44)
	com.zving.framework.template.TemplateExecutor.execute(TemplateExecutor.java:53)
	com.zving.staticize.template.TemplateInstance.execute(TemplateInstance.java:112)
	com.zving.front.ui.VideoFontUI.videoPlay(VideoFontUI.java:311)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	com.zving.framework.core.method.FacadeMemberMethodLocator.execute(FacadeMemberMethodLocator.java:46)
	com.zving.framework.core.handler.ActionHandler.invoke(ActionHandler.java:135)
	com.zving.framework.core.handler.ActionHandler.handle(ActionHandler.java:96)
	com.zving.framework.core.DispatchServlet.handleURL(DispatchServlet.java:337)
	com.zving.framework.core.DispatchServlet.service(DispatchServlet.java:242)
	com.zving.preloader.facade.ServletFacade.service(ServletFacade.java:40)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.zving.front.filter.MirrorPrivFilter.doFilter(MirrorPrivFilter.java:27)
	com.zving.preloader.facade.FilterFacade.doFilter(FilterFacade.java:41)
	org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
	org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
	org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)

root cause

java.sql.SQLException: Parameter index out of range (5 > number of parameters, which is 4).
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:862)
	com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3319)
	com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3304)
	com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3341)
	com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:3294)
	com.zving.framework.data.DataAccess.setParam(DataAccess.java:205)
	com.zving.framework.data.DataAccess.setParams(DataAccess.java:188)
	com.zving.framework.data.DataAccess.executePagedDataTable(DataAccess.java:336)
	com.zving.framework.data.QueryBuilder.executePagedDataTable(QueryBuilder.java:169)
	com.zving.framework.data.QueryBuilder.executePagedDataTable(QueryBuilder.java:162)
	com.zving.framework.data.QueryBuilder.fetch(QueryBuilder.java:470)
	com.zving.front.tag.VideoListTag.prepareData(VideoListTag.java:77)
	com.zving.staticize.tag.AbstractListTag.onTagStart(AbstractListTag.java:74)
	com.zving.front.tag.VideoListTag.onTagStart(VideoListTag.java:50)
	com.zving.staticize.tag.SimpleTag.doStartTag(SimpleTag.java:30)
	com.zving.framework.template.command.TagCommand.execute(TagCommand.java:44)
	com.zving.framework.template.TemplateExecutor.execute(TemplateExecutor.java:53)
	com.zving.staticize.template.TemplateInstance.execute(TemplateInstance.java:112)
	com.zving.front.ui.VideoFontUI.videoPlay(VideoFontUI.java:311)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	com.zving.framework.core.method.FacadeMemberMethodLocator.execute(FacadeMemberMethodLocator.java:46)
	com.zving.framework.core.handler.ActionHandler.invoke(ActionHandler.java:135)
	com.zving.framework.core.handler.ActionHandler.handle(ActionHandler.java:96)
	com.zving.framework.core.DispatchServlet.handleURL(DispatchServlet.java:337)
	com.zving.framework.core.DispatchServlet.service(DispatchServlet.java:242)
	com.zving.preloader.facade.ServletFacade.service(ServletFacade.java:40)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.zving.front.filter.MirrorPrivFilter.doFilter(MirrorPrivFilter.java:27)
	com.zving.preloader.facade.FilterFacade.doFilter(FilterFacade.java:41)
	org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
	org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
	org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)

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


Apache Tomcat/7.0.79