Invalid column name problem [message #703833] |
Thu, 28 July 2011 00:59 |
Missing name Mising name Messages: 12 Registered: July 2011 |
Junior Member |
|
|
I've just taken over an existing project that uses eclipselink.
I've added a new column to a table and have updated the classes to include the new column. When I run the application I get the following error.
javax.faces.FacesException: javax.el.ELException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.1.v20100817-r8050): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: 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)
Does anyone have any ideas as to why this would happen?
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03507 seconds