Results 1 to 2 of 2
  1. #1
    ajt111 is offline Member
    Join Date
    Oct 2009
    Posts
    2
    Rep Power
    0

    Default Really Really Tough Bug in JSP

    ***************WARNING***************
    The following code is not good.
    It is a result of 3-4 developers over 2-3 years.
    I have now been assigned the task of "fixing" it.
    *************************************

    I will attach all files that I mention in this post.
    I am pretty much at a loss as to what is causing this error.
    Any help would be greatly appreciated!!
    This project uses hibernate and JSP along with JSP.

    This is where you should star:
    submission-admin-resolve.jsp line 45 has this tag:

    Java Code:
    <t:htmlTag value="div" rendered="#{AdminSubmissionBean.isAdmin}">
    			<s:gridEditor id="grid-slave2"
    				rows="#{AdminSubmissionBean.rowsSlave2}"
    				columns="#{AdminSubmissionBean.columnsSlave2}"
    				values="#{AdminSubmissionBean.valuesSlave}"
    				rowGroups="#{AdminSubmissionBean.rowGroupsSlave2}"
    				fieldTypes="#{AdminSubmissionBean.fieldTypesSlave}" />
    		</t:htmlTag>
    which produces this error:
    Java Code:
    Oct 28, 2009 10:12:57 AM org.apache.catalina.core.ApplicationDispatcher invoke
    SEVERE: Servlet.service() for servlet jsp threw exception
    java.lang.RuntimeException: invalid column name pur
    	at edu.emory.library.tast.common.grideditor.Values.getValue(Values.java:18)
    	at edu.emory.library.tast.common.grideditor.GridEditorComponent.encodeRegJS(GridEditorComponent.java:392)
    	at edu.emory.library.tast.common.grideditor.GridEditorComponent.encodeBegin(GridEditorComponent.java:1025)
    	at javax.faces.webapp.UIComponentTag.encodeBegin(UIComponentTag.java:464)
    	at javax.faces.webapp.UIComponentTag.doStartTag(UIComponentTag.java:317)
    	at org.apache.jsp.submission.submission_002dadmin_002dresolve_jsp._jspx_meth_s_005fgridEditor_005f2(submission_002dadmin_002dresolve_jsp.java:400)
    	at org.apache.jsp.submission.submission_002dadmin_002dresolve_jsp._jspx_meth_t_005fhtmlTag_005f0(submission_002dadmin_002dresolve_jsp.java:366)
    	at org.apache.jsp.submission.submission_002dadmin_002dresolve_jsp._jspx_meth_h_005fform_005f0(submission_002dadmin_002dresolve_jsp.java:216)
    	at org.apache.jsp.submission.submission_002dadmin_002dresolve_jsp._jspx_meth_f_005fview_005f0(submission_002dadmin_002dresolve_jsp.java:167)
    	at org.apache.jsp.submission.submission_002dadmin_002dresolve_jsp._jspService(submission_002dadmin_002dresolve_jsp.java:132)
    	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
    	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
    	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
    	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
    	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
    	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
    	at org.apache.myfaces.context.servlet.ServletExternalContextImpl.dispatch(ServletExternalContextImpl.java:416)
    	at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:234)
    	at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:384)
    	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:138)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:144)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at edu.emory.library.tast.EncodingFilter.doFilter(EncodingFilter.java:20)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    	at java.lang.Thread.run(Unknown Source)
    Oct 28, 2009 10:12:57 AM org.apache.catalina.core.StandardWrapperValve invoke
    SEVERE: Servlet.service() for servlet FacesServlet threw exception
    java.lang.RuntimeException: invalid column name pur
    	at edu.emory.library.tast.common.grideditor.Values.getValue(Values.java:18)
    	at edu.emory.library.tast.common.grideditor.GridEditorComponent.encodeRegJS(GridEditorComponent.java:392)
    	at edu.emory.library.tast.common.grideditor.GridEditorComponent.encodeBegin(GridEditorComponent.java:1025)
    	at javax.faces.webapp.UIComponentTag.encodeBegin(UIComponentTag.java:464)
    	at javax.faces.webapp.UIComponentTag.doStartTag(UIComponentTag.java:317)
    	at org.apache.jsp.submission.submission_002dadmin_002dresolve_jsp._jspx_meth_s_005fgridEditor_005f2(submission_002dadmin_002dresolve_jsp.java:400)
    	at org.apache.jsp.submission.submission_002dadmin_002dresolve_jsp._jspx_meth_t_005fhtmlTag_005f0(submission_002dadmin_002dresolve_jsp.java:366)
    	at org.apache.jsp.submission.submission_002dadmin_002dresolve_jsp._jspx_meth_h_005fform_005f0(submission_002dadmin_002dresolve_jsp.java:216)
    	at org.apache.jsp.submission.submission_002dadmin_002dresolve_jsp._jspx_meth_f_005fview_005f0(submission_002dadmin_002dresolve_jsp.java:167)
    	at org.apache.jsp.submission.submission_002dadmin_002dresolve_jsp._jspService(submission_002dadmin_002dresolve_jsp.java:132)
    	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
    	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
    	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
    	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
    	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
    	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
    	at org.apache.myfaces.context.servlet.ServletExternalContextImpl.dispatch(ServletExternalContextImpl.java:416)
    	at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:234)
    	at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:384)
    	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:138)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:144)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at edu.emory.library.tast.EncodingFilter.doFilter(EncodingFilter.java:20)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    	at java.lang.Thread.run(Unknown Source)
    Attached Files Attached Files

  2. #2
    r035198x is offline Senior Member
    Join Date
    Aug 2009
    Posts
    2,388
    Rep Power
    8

    Default

    The query run to retrieve data from the table for the bean AdminSubmissionBean contains a request for a column called pur which is not on the table in the database or simply the SQL syntax was wrong.
    If you did not write any queries then a property in one of your entities is marked as a persistable property (called pur) but the table mapping to that entity does not contain that column.

Similar Threads

  1. Tough Homework Questions, PLEASE HELP!
    By passage in forum New To Java
    Replies: 21
    Last Post: 01-16-2008, 11:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •