could not resolve property - java.lang.IllegalArgumentException: org.hibernate.QueryException

Help
2013-05-27
2013-05-29
  • Dirk Coetsee
    Dirk Coetsee
    2013-05-27

    Hi, Im getting a java.lang.IllegalArgumentException: org.hibernate.QueryException: could not resolve property:xxxxx
    this is after the list view displayed correctly, I'm selection details, enter new rows and then switch back to list

    SEVERE: Fail executing SELECT e.classificationSchemeSK, e.edwRelease, e.hubRelease, e.effectiveTimestamp, e.endTimestamp, e.deleteIndicator, e.requestorName, e.projectName, e.statusCodeId, e.classificationSchemeId, e.classificationSchemeName, e.schemeCode, e.shortName, e.longName, e.schemeDescription, e.classificationSchemeParentId, e.dataWarehouseTableName, e.classificationSchemePrnId, e.etlProcessInstantiationId, e.numericCodeIndicator, e.codeLengthMSR from ClassificationScheme e

    java.lang.IllegalArgumentException: org.hibernate.QueryException: could not resolve property: classificationSchemeSK of: com.bmo.classification.module.ClassificationScheme [SELECT e.classificationSchemeSK, e.edwRelease, e.hubRelease, e.effectiveTimestamp, e.endTimestamp, e.deleteIndicator, e.requestorName, e.projectName, e.statusCodeId, e.classificationSchemeId, e.classificationSchemeName, e.schemeCode, e.shortName, e.longName, e.schemeDescription, e.classificationSchemeParentId, e.dataWarehouseTableName, e.classificationSchemePrnId, e.etlProcessInstantiationId, e.numericCodeIndicator, e.codeLengthMSR from com.bmo.classification.module.ClassificationScheme e]
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1376)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1317)
    at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:280)
    at org.openxava.jpa.impl.EntityManagerDecorator.createQuery(EntityManagerDecorator.java:131)
    at org.openxava.tab.impl.JPATabProvider.nextBlock(JPATabProvider.java:153)
    at org.openxava.tab.impl.JPATabProvider.nextChunk(JPATabProvider.java:139)
    at org.openxava.tab.impl.EntityTabDataProvider.nextChunk(EntityTabDataProvider.java:32)
    at org.openxava.tab.impl.EntityTab.nextChunk(EntityTab.java:249)
    at org.openxava.tab.impl.TableModelBean.getRow(TableModelBean.java:121)
    at org.openxava.tab.impl.TableModelBean.getObjectAt(TableModelBean.java:150)
    at org.openxava.tab.impl.XTableModelDecoratorBase.getObjectAt(XTableModelDecoratorBase.java:55)
    at org.openxava.actions.ViewDetailAction.execute(ViewDetailAction.java:77)
    at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:399)
    at org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:318)
    at org.openxava.controller.ModuleManager.execute(ModuleManager.java:278)
    at org.apache.jsp.xava.execute_jsp._jspService(execute_jsp.java:192)
    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:646)
    at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
    at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
    at org.openxava.web.servlets.Servlets.getURIAsStream(Servlets.java:66)
    at org.openxava.web.dwr.Module.getURIAsStream(Module.java:204)
    at org.openxava.web.dwr.Module.request(Module.java:62)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)
    at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)
    at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)
    at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)
    at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)
    at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)
    at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    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.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:293)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
    at java.lang.Thread.run(Thread.java:680)
    Caused by: org.hibernate.QueryException: could not resolve property: classificationSchemeSK of: com.bmo.classification.module.ClassificationScheme [SELECT e.classificationSchemeSK, e.edwRelease, e.hubRelease, e.effectiveTimestamp, e.endTimestamp, e.deleteIndicator, e.requestorName, e.projectName, e.statusCodeId, e.classificationSchemeId, e.classificationSchemeName, e.schemeCode, e.shortName, e.longName, e.schemeDescription, e.classificationSchemeParentId, e.dataWarehouseTableName, e.classificationSchemePrnId, e.etlProcessInstantiationId, e.numericCodeIndicator, e.codeLengthMSR from com.bmo.classification.module.ClassificationScheme e]
    at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:81)
    at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:75)
    at org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1465)
    at org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElementType.java:315)
    at org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.java:487)

     
  • Javier Paniza
    Javier Paniza
    2013-05-29

    Hi Dirk,

    s after the list view displayed correctly, I'm selection details, enter new rows and then switch back to list

    What a strange behavior!

    Does ClassificationScheme have a property called classificationSchemeSK?
    Have you tried to remove the @Tab ClassificationScheme?
    Can you put here the ClassificationScheme complete code?


    Help others in this forum as I help you.
    Need more help? Get OpenXava professional support.