Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via eclipse.org by Unknown author, 1 year ago
="SELECT Staff_id, Staff_description, Staff_image_large, Staff_order, Staff_linkedin, Staff_email, Staff_position_title, Staff_telephone_mobile, Staff_telephone_direct, Site_owner_id, Staff_status, Staff_approved, Staff_image_small, Staff_name, Staff_department_id, Site_locationseq FROM WWWWebsite_Staff WHERE (Site_owner_id = ?)")
java.sql.SQLException: Invalid column name 'Staff_approved'.
Error Code: 207
Call: SELECT Staff_id, Staff_description, Staff_image_large, Staff_order, Staff_linkedin, Staff_email, Staff_position_title, Staff_telephone_mobile, Staff_telephone_direct, Site_owner_id, Staff_status, Staff_approved, Staff_image_small, Staff_name, Staff_department_id, Site_locationseq FROM WWWWebsite_Staff WHERE (Site_owner_id = ?)
	bind => [27]
Query: ReadAllQuery(name="WWWWebsiteStaff.findBySiteOwnerId" referenceClass=WWWWebsiteStaff sql="SELECT Staff_id, Staff_description, Staff_image_large, Staff_order, Staff_linkedin, Staff_email, Staff_position_title, Staff_telephone_mobile, Staff_telephone_direct, Site_owner_id, Staff_status, Staff_approved, Staff_image_small, Staff_name, Staff_department_id, Site_locationseq FROM WWWWebsite_Staff WHERE (Site_owner_id = ?)")	at javax.faces.component.UIData.getValue(UIData.java:585)	at org.ajax4jsf.component.UIDataAdaptorBase.getValue(UIDataAdaptorBase.java:1647)	at org.ajax4jsf.component.SequenceDataAdaptor.getDataModel(SequenceDataAdaptor.java:65)	at org.ajax4jsf.component.SequenceDataAdaptor.createDataModel(SequenceDataAdaptor.java:59)	at org.richfaces.component.UIDataTable.createDataModel(UIDataTable.java:121)	at org.ajax4jsf.component.UIDataAdaptorBase.getExtendedDataModel(UIDataAdaptorBase.java:621)	at org.ajax4jsf.component.UIDataAdaptorBase.setRowKey(UIDataAdaptorBase.java:339)	at org.richfaces.renderkit.AbstractTableRenderer.encodeTableStructure(AbstractTableRenderer.java:138)	at org.richfaces.renderkit.html.DataTableRenderer.doEncodeBegin(DataTableRenderer.java:140)	at org.richfaces.renderkit.html.DataTableRenderer.doEncodeBegin(DataTableRenderer.java:128)	at org.ajax4jsf.renderkit.RendererBase.encodeBegin(RendererBase.java:100)	at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:788)	at javax.faces.component.UIData.encodeBegin(UIData.java:879)	at org.ajax4jsf.component.UIDataAdaptorBase.encodeBegin(UIDataAdaptorBase.java:1225)	at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:275)	at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:258)	at org.richfaces.renderkit.html.PanelRenderer.doEncodeChildren(PanelRenderer.java:200)	at org.richfaces.renderkit.html.PanelRenderer.doEncodeChildren(PanelRenderer.java:195)	at org.ajax4jsf.renderkit.RendererBase.encodeChildren(RendererBase.java:120)	at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:812)	at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:271)	at com.sun.faces.renderkit.html_basic.GridRenderer.encodeChildren(GridRenderer.java:242)	at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:812)	at javax.faces.component.UIComponent.encodeAll(UIComponent.java:886)	at javax.faces.render.Renderer.encodeChildren(Renderer.java:137)	at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:812)	at javax.faces.component.UIComponent.encodeAll(UIComponent.java:886)	at javax.faces.component.UIComponent.encodeAll(UIComponent.java:892)	at com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:245)	at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:176)	at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.java:320)	at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:100)	at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:176)	at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)	at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)