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 = ?)")

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web12196

  • via eclipse.org by Unknown author, 10 months 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 = ?)")
  • Transaction cannot proceed STATUS_COMMITTED Error Code: 0 Call: SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?) bind => [1 parameter bound] Query: ReadAllQuery(name="fileVersions
  • Transaction cannot proceed STATUS_COMMITTED Error Code: 0 Call: SELECT id, closed, changeSetID, xyFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?) bind => [1 parameter bound] Query: ReadAllQuery(name="fileVersions
  • Stack trace

    • 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.