Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Invalid column name problem
Invalid column name problem [message #703833] Wed, 27 July 2011 20:59 Go to next message
Missing name Mising name is currently offline 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?
Re: Invalid column name problem [message #703911 is a reply to message #703833] Wed, 27 July 2011 23:38 Go to previous message
Missing name Mising name is currently offline Missing name Mising name
Messages: 12
Registered: July 2011
Junior Member
Forget it. I figured it out. I hadn't created the column in one of my databases.
(no subject) [message #703922 is a reply to message #703833] Wed, 27 July 2011 23:38 Go to previous message
Missing name Mising name is currently offline Missing name Mising name
Messages: 12
Registered: July 2011
Junior Member
Forget it. I figured it out. I hadn't created the column in one of my databases.
Previous Topic:Toplink 10 to Eclipselink migration
Next Topic:(no subject)
Goto Forum:
  


Current Time: Fri Apr 18 04:08:20 EDT 2014

Powered by FUDForum. Page generated in 0.01650 seconds