org.hibernate.QueryException: could not resolve property: valu e of: org.bedework.calfacade.BwCategory [select distinct ev from org.bedework.ca lfacade.BwEventObj ev left outer join ev.categories as joined_categories where ev.tombstoned=false and (((ev.entityType=:fq__0) and ((select count(*) from ev. categories categories_x where lower(categories_x.value) like :fq__1) > 0) and (e v.colPath=:fq__2)))]

Apereo Issues | Matej Spiller-Muys | 4 years ago
  1. 0

    1. CalDav is return everything is OK even when there is exception on the server. There is some bad exception handling eating the error away. 2. request <?xml version="1.0"?> <C:calendar-query xmlns:C="urn:ietf:params:xml:ns:caldav"> <D:prop xmlns:D="DAV:"> <D:getetag/> <D:allprop/> <C:calendar-data> <C:comp name="VCALENDAR"/> </C:calendar-data> </D:prop> <C:filter> <C:comp-filter name="VCALENDAR"> <C:comp-filter name="VEVENT"> <C:prop-filter name="CATEGORIES"> <C:text-match caseless="yes" collation="i;ascii-casemap">TEST</C:text-match> </C:prop-filter> </C:comp-filter> </C:comp-filter> </C:filter> </C:calendar-query> 3. server log 17:27:10,283 DEBUG [CaldavBWServlet] entry: REPORT 17:27:10,283 DEBUG [CaldavBWServlet] Request headers 17:27:10,283 DEBUG [CaldavBWServlet] authorization = "Basic **********" 17:27:10,283 DEBUG [CaldavBWServlet] user-agent = "Jakarta Commons-HttpClient/ 3.1" 17:27:10,283 DEBUG [CaldavBWServlet] host = "d014:8080" 17:27:10,283 DEBUG [CaldavBWServlet] content-length = "625" 17:27:10,283 DEBUG [CaldavBWServlet] depth = "1" 17:27:10,283 DEBUG [CaldavBWServlet] content-type = "text/xml" 17:27:10,283 DEBUG [CaldavBWServlet] Request parameters - global info and uris 17:27:10,283 DEBUG [CaldavBWServlet] getRemoteAddr = 10.17.22.28 17:27:10,283 DEBUG [CaldavBWServlet] getRequestURI = /ucaldav/user/eVpisnik/cale ndar/ 17:27:10,283 DEBUG [CaldavBWServlet] getRemoteUser = eVpisnik 17:27:10,283 DEBUG [CaldavBWServlet] getRequestedSessionId = null 17:27:10,283 DEBUG [CaldavBWServlet] HttpUtils.getRequestURL(req) = http://d014: 8080/ucaldav/user/eVpisnik/calendar/ 17:27:10,283 DEBUG [CaldavBWServlet] contextPath=/ucaldav 17:27:10,283 DEBUG [CaldavBWServlet] query=null 17:27:10,298 DEBUG [CaldavBWServlet] contentlen=625 17:27:10,298 DEBUG [CaldavBWServlet] request=org.apache.catalina.connector.Reque stFacade@870b6e 17:27:10,298 DEBUG [CaldavBWServlet] parameters: 17:27:10,298 DEBUG [CaldavBWServlet] Request parameters 17:27:10,298 INFO [SessionListener] SESSION-START:B7A39E8D53AE9B75B14A87466349C 89F:?:1:142:139M:594M 17:27:10,298 INFO [[/ucaldav]] ========= New session(?): 1 active, 142 total. v m(used, max)=(139M, 594M) 17:27:10,298 DEBUG [CalintfImpl] New hibernate session for null 17:27:10,298 DEBUG [CalintfImpl] Open session for null 17:27:10,298 DEBUG [CalintfImpl] Begin transaction for null 17:27:10,298 DEBUG [CalSvc] Authenticated user eVpisnik logged on 17:27:10,298 DEBUG [UserGroupsLdapImpl] Logged into LDAP server, javax.naming.ld ap.InitialLdapContext@a3c486 17:27:10,298 DEBUG [UserGroupsLdapImpl] Logged into LDAP server, javax.naming.ld ap.InitialLdapContext@87c2e2 17:27:10,314 DEBUG [CalintfImpl] End transaction for 2012-08-10 17:27:10.314 17:27:10,314 DEBUG [CalintfImpl] Close for 2012-08-10 17:27:10.314 17:27:10,314 DEBUG [CalintfImpl] New hibernate session for 2012-08-10 17:27:10.3 14 17:27:10,314 DEBUG [MessageProcessor] Event USER_LOGIN 17:27:10,314 DEBUG [CalintfImpl] Open session for 2012-08-10 17:27:10.314 17:27:10,314 DEBUG [CalintfImpl] Begin transaction for 2012-08-10 17:27:10.314 17:27:10,330 DEBUG [CalintfImpl] End transaction for 2012-08-10 17:27:10.314 17:27:10,330 DEBUG [CalintfImpl] Close for 2012-08-10 17:27:10.314 17:27:10,330 DEBUG [CalintfImpl] New hibernate session for 2012-08-10 17:27:10.3 14 17:27:10,330 DEBUG [MessageProcessor] Event USER_SVCINIT 17:27:10,330 DEBUG [CalintfImpl] Open session for 2012-08-10 17:27:10.314 17:27:10,330 DEBUG [CalintfImpl] Begin transaction for 2012-08-10 17:27:10.314 17:27:10,330 DEBUG [CaldavBWServlet] No charset specified in request; forced to UTF-8 17:27:10,330 DEBUG [CaldavReportMethod] ReportMethod: doMethod 17:27:10,330 DEBUG [CaldavBWIntf] [142] <?xml version="1.0"?> <C:calendar-query xmlns:C="urn:ietf:params:xml:ns:caldav"> <D:prop xmlns:D="DAV:"> <D:getetag/> <D:allprop/> <C:calendar-data> <C:comp name="VCALENDAR"/> </C:calendar-data> </D:prop> <C:filter> <C:comp-filter name="VCALENDAR"> <C:comp-filter name="VEVENT"> <C:prop-filter name="CATEGORIES"> <C:text-match caseless="yes" collation="i;ascii-casemap">TES T</C:text-match> </C:prop-filter> </C:comp-filter> </C:comp-filter> </C:filter> </C:calendar-query> 17:27:10,330 DEBUG [CaldavReportMethod] ReportMethod: depth=1 17:27:10,330 DEBUG [CaldavBWIntf] [142] prop: {DAV:}getetag 17:27:10,330 DEBUG [CaldavBWIntf] [142] prop: {DAV:}allprop 17:27:10,330 DEBUG [CalData] calendar-data node type: 1 name:C:comp 17:27:10,330 DEBUG [CalData] <calendar-data content-type="text/calendar"> 17:27:10,330 DEBUG [CalData] <comp name=VCALENDAR> 17:27:10,330 DEBUG [CalData] </comp> 17:27:10,330 DEBUG [CalData] </calendar-data> 17:27:10,330 DEBUG [CaldavBWIntf] [142] prop: {urn:ietf:params:xml:ns:caldav}cal endar-data 17:27:10,408 DEBUG [CaldavReportMethod] REPORT: query 17:27:10,408 DEBUG [CaldavReportMethod] <filter> 17:27:10,408 DEBUG [CaldavReportMethod] <comp-filter name="VCALENDAR"> 17:27:10,408 DEBUG [CaldavReportMethod] <comp-filter name="VEVENT"> 17:27:10,408 DEBUG [CaldavReportMethod] <prop-filter name="CATEGORIES"> 17:27:10,408 DEBUG [CaldavReportMethod] <text-match collation=i;ascii-ca semap negate-condition=no> 17:27:10,408 DEBUG [CaldavReportMethod] TEST 17:27:10,408 DEBUG [CaldavReportMethod] </text-match> 17:27:10,408 DEBUG [CaldavReportMethod] </prop-filter> 17:27:10,408 DEBUG [CaldavReportMethod] </comp-filter> 17:27:10,408 DEBUG [CaldavReportMethod] </comp-filter> 17:27:10,408 DEBUG [CaldavReportMethod] </filter> 17:27:10,408 DEBUG [CaldavBWServlet] setStatus(207) 17:27:10,408 DEBUG [CaldavBWServlet] getWriter called 17:27:10,408 DEBUG [CaldavReportMethod] resourceUri: /user/eVpisnik/calendar/ 17:27:10,408 DEBUG [CaldavBWIntf] [142] About to get node for /user/eVpisnik/cal endar/ 17:27:10,408 DEBUG [CaldavBWIntf] [142] Normalized uri=/user/eVpisnik/calendar 17:27:10,408 DEBUG [CaldavBWIntf] [142] search for collection uri "/user/eVpisni k/calendar" 17:27:10,408 DEBUG [CaldavBWIntf] [142] create collection uri - cal="/user/eVpis nik/calendar" 17:27:10,408 DEBUG [CaldavReportMethod] REPORT: preq not null 17:27:10,408 DEBUG [CaldavReportMethod] doNodeAndChildren: curDepth=0 maxDepth=1 uri=/user/eVpisnik/calendar 17:27:10,408 DEBUG [CaldavReportMethod] getNodes: /user/eVpisnik/calendar 17:27:10,408 DEBUG [CoreEvents] getEvents for start=null end=null 17:27:10,408 DEBUG [CoreEvents] select distinct ev from org.bedework.calfacade.B wEventObj ev left outer join ev.categories as joined_categories where ev.tombst oned=false and (((ev.entityType=:fq__0) and ((select count(*) from ev.categorie s categories_x where lower(categories_x.value) like :fq__1) > 0) and (ev.colPath =:fq__2))) 17:27:10,423 DEBUG [CalintfImpl] handleException called 17:27:10,423 ERROR [CalintfImpl] org.bedework.calcore.hibernate.HibSessionImpl@1 0d731b org.hibernate.QueryException: could not resolve property: value of: org.bedework .calfacade.BwCategory [select distinct ev from org.bedework.calfacade.BwEventObj ev left outer join ev.categories as joined_categories where ev.tombstoned=fals e and (((ev.entityType=:fq__0) and ((select count(*) from ev.categories categor ies_x where lower(categories_x.value) like :fq__1) > 0) and (ev.colPath=:fq__2)) )] at org.hibernate.persister.entity.AbstractPropertyMapping.propertyExcept ion(AbstractPropertyMapping.java:81) at org.hibernate.persister.entity.AbstractPropertyMapping.toType(Abstrac tPropertyMapping.java:75) at org.hibernate.persister.entity.AbstractEntityPersister.toType(Abstrac tEntityPersister.java:1465) at org.hibernate.persister.collection.AbstractCollectionPersister.toType (AbstractCollectionPersister.java:1495) at org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElemen tType.java:315) at org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.ja va:487) at org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:611) at org.hibernate.hql.ast.tree.DotNode.prepareLhs(DotNode.java:263) at org.hibernate.hql.ast.tree.DotNode.resolveInFunctionCall(DotNode.java :185) at org.hibernate.hql.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:877) at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1 330) at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWal ker.java:4471) at org.hibernate.hql.antlr.HqlSqlBaseWalker.functionCall(HqlSqlBaseWalke r.java:2583) at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1 404) at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWal ker.java:4471) at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWal ker.java:4088) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:2047) at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker .java:831) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java: 617) at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWal ker.java:4479) at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWal ker.java:4016) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:2047) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:1975) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:1972) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:1975) at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker .java:831) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java: 617) at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWa lker.java:301) at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.j ava:244) at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl .java:256) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorIm pl.java:187) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl .java:138) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCa che.java:124) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessio nImpl.java:156) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImp l.java:135) at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770) at org.bedework.calcore.hibernate.HibSessionImpl.createQuery(HibSessionI mpl.java:323) at org.bedework.calcore.hibernate.EventQueryBuilder.createQuery(EventQue ryBuilder.java:308) at org.bedework.calcore.hibernate.CoreEvents.eventsQuery(CoreEvents.java :2990) at org.bedework.calcore.hibernate.CoreEvents.getEvents(CoreEvents.java:4 87) at org.bedework.calcore.hibernate.CalintfImpl.getEvents(CalintfImpl.java :915) at org.bedework.calsvc.Events.getMatching(Events.java:812) at org.bedework.calsvc.Events.getEvents(Events.java:140) at org.bedework.caldav.bwserver.BwSysIntfImpl.getEvents(BwSysIntfImpl.ja va:777) at org.bedework.caldav.server.filter.FilterHandler.query(FilterHandler.j ava:181) at org.bedework.caldav.server.CaldavBWIntf.query(CaldavBWIntf.java:1689) at org.bedework.caldav.server.CaldavReportMethod.getNodes(CaldavReportMe thod.java:641) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:615) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:572) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:552) at org.bedework.caldav.server.CaldavReportMethod.process(CaldavReportMet hod.java:388) at org.bedework.caldav.server.CaldavReportMethod.processResp(CaldavRepor tMethod.java:370) at org.bedework.caldav.server.CaldavReportMethod.process(CaldavReportMet hod.java:123) at edu.rpi.cct.webdav.servlet.common.ReportMethod.doMethod(ReportMethod. java:114) at edu.rpi.cct.webdav.servlet.common.WebdavServlet.service(WebdavServlet .java:149) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi lter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:235) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit yAssociationValve.java:190) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica torBase.java:525) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv e.java:92) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce ss(SecurityContextEstablishmentValve.java:126) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok e(SecurityContextEstablishmentValve.java:70) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC onnectionValve.java:158) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: 567) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav a:330) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :829) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ss(Http11Protocol.java:598) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44 7) at java.lang.Thread.run(Thread.java:662) 17:27:10,423 ERROR [FilterHandler] org.bedework.caldav.server.filter.FilterHandl er@1f4a edu.rpi.cct.webdav.servlet.shared.WebdavException: org.bedework.calfacade.exc.Ca lFacadeException: org.hibernate.QueryException: could not resolve property: valu e of: org.bedework.calfacade.BwCategory [select distinct ev from org.bedework.ca lfacade.BwEventObj ev left outer join ev.categories as joined_categories where ev.tombstoned=false and (((ev.entityType=:fq__0) and ((select count(*) from ev. categories categories_x where lower(categories_x.value) like :fq__1) > 0) and (e v.colPath=:fq__2)))] at org.bedework.caldav.bwserver.BwSysIntfImpl.getEvents(BwSysIntfImpl.ja va:805) at org.bedework.caldav.server.filter.FilterHandler.query(FilterHandler.j ava:181) at org.bedework.caldav.server.CaldavBWIntf.query(CaldavBWIntf.java:1689) at org.bedework.caldav.server.CaldavReportMethod.getNodes(CaldavReportMe thod.java:641) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:615) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:572) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:552) at org.bedework.caldav.server.CaldavReportMethod.process(CaldavReportMet hod.java:388) at org.bedework.caldav.server.CaldavReportMethod.processResp(CaldavRepor tMethod.java:370) at org.bedework.caldav.server.CaldavReportMethod.process(CaldavReportMet hod.java:123) at edu.rpi.cct.webdav.servlet.common.ReportMethod.doMethod(ReportMethod. java:114) at edu.rpi.cct.webdav.servlet.common.WebdavServlet.service(WebdavServlet .java:149) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi lter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:235) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit yAssociationValve.java:190) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica torBase.java:525) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv e.java:92) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce ss(SecurityContextEstablishmentValve.java:126) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok e(SecurityContextEstablishmentValve.java:70) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC onnectionValve.java:158) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: 567) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav a:330) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :829) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ss(Http11Protocol.java:598) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44 7) at java.lang.Thread.run(Thread.java:662) Caused by: org.bedework.calfacade.exc.CalFacadeException: org.hibernate.QueryExc eption: could not resolve property: value of: org.bedework.calfacade.BwCategory [select distinct ev from org.bedework.calfacade.BwEventObj ev left outer join ev .categories as joined_categories where ev.tombstoned=false and (((ev.entityTyp e=:fq__0) and ((select count(*) from ev.categories categories_x where lower(cate gories_x.value) like :fq__1) > 0) and (ev.colPath=:fq__2)))] at org.bedework.calcore.hibernate.HibSessionImpl.handleException(HibSess ionImpl.java:1082) at org.bedework.calcore.hibernate.HibSessionImpl.handleException(HibSess ionImpl.java:1045) at org.bedework.calcore.hibernate.HibSessionImpl.createQuery(HibSessionI mpl.java:326) at org.bedework.calcore.hibernate.EventQueryBuilder.createQuery(EventQue ryBuilder.java:308) at org.bedework.calcore.hibernate.CoreEvents.eventsQuery(CoreEvents.java :2990) at org.bedework.calcore.hibernate.CoreEvents.getEvents(CoreEvents.java:4 87) at org.bedework.calcore.hibernate.CalintfImpl.getEvents(CalintfImpl.java :915) at org.bedework.calsvc.Events.getMatching(Events.java:812) at org.bedework.calsvc.Events.getEvents(Events.java:140) at org.bedework.caldav.bwserver.BwSysIntfImpl.getEvents(BwSysIntfImpl.ja va:777) ... 34 more Caused by: org.hibernate.QueryException: could not resolve property: value of: o rg.bedework.calfacade.BwCategory [select distinct ev from org.bedework.calfacade .BwEventObj ev left outer join ev.categories as joined_categories where ev.tomb stoned=false and (((ev.entityType=:fq__0) and ((select count(*) from ev.categor ies categories_x where lower(categories_x.value) like :fq__1) > 0) and (ev.colPa th=:fq__2)))] at org.hibernate.persister.entity.AbstractPropertyMapping.propertyExcept ion(AbstractPropertyMapping.java:81) at org.hibernate.persister.entity.AbstractPropertyMapping.toType(Abstrac tPropertyMapping.java:75) at org.hibernate.persister.entity.AbstractEntityPersister.toType(Abstrac tEntityPersister.java:1465) at org.hibernate.persister.collection.AbstractCollectionPersister.toType (AbstractCollectionPersister.java:1495) at org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElemen tType.java:315) at org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.ja va:487) at org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:611) at org.hibernate.hql.ast.tree.DotNode.prepareLhs(DotNode.java:263) at org.hibernate.hql.ast.tree.DotNode.resolveInFunctionCall(DotNode.java :185) at org.hibernate.hql.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:877) at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1 330) at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWal ker.java:4471) at org.hibernate.hql.antlr.HqlSqlBaseWalker.functionCall(HqlSqlBaseWalke r.java:2583) at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1 404) at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWal ker.java:4471) at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWal ker.java:4088) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:2047) at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker .java:831) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java: 617) at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWal ker.java:4479) at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWal ker.java:4016) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:2047) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:1975) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:1972) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:1975) at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker .java:831) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java: 617) at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWa lker.java:301) at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.j ava:244) at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl .java:256) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorIm pl.java:187) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl .java:138) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCa che.java:124) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessio nImpl.java:156) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImp l.java:135) at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770) at org.bedework.calcore.hibernate.HibSessionImpl.createQuery(HibSessionI mpl.java:323) ... 41 more 17:27:10,423 ERROR [CaldavBWServlet] org.bedework.caldav.server.CaldavBWServlet@ 1e25c3 edu.rpi.cct.webdav.servlet.shared.WebdavException at org.bedework.caldav.server.filter.FilterHandler.query(FilterHandler.j ava:195) at org.bedework.caldav.server.CaldavBWIntf.query(CaldavBWIntf.java:1689) at org.bedework.caldav.server.CaldavReportMethod.getNodes(CaldavReportMe thod.java:641) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:615) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:572) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:552) at org.bedework.caldav.server.CaldavReportMethod.process(CaldavReportMet hod.java:388) at org.bedework.caldav.server.CaldavReportMethod.processResp(CaldavRepor tMethod.java:370) at org.bedework.caldav.server.CaldavReportMethod.process(CaldavReportMet hod.java:123) at edu.rpi.cct.webdav.servlet.common.ReportMethod.doMethod(ReportMethod. java:114) at edu.rpi.cct.webdav.servlet.common.WebdavServlet.service(WebdavServlet .java:149) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi lter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:235) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit yAssociationValve.java:190) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica torBase.java:525) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv e.java:92) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce ss(SecurityContextEstablishmentValve.java:126) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok e(SecurityContextEstablishmentValve.java:70) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC onnectionValve.java:158) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: 567) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav a:330) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :829) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ss(Http11Protocol.java:598) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44 7) at java.lang.Thread.run(Thread.java:662) 17:27:10,423 DEBUG [CalintfImpl] Enter rollback 17:27:10,423 DEBUG [CaldavBWServlet] setStatus(500) message=null 17:27:10,423 DEBUG [CalintfImpl] End transaction for 2012-08-10 17:27:10.314 17:27:10,423 DEBUG [CalintfImpl] Enter rollback 17:27:10,423 DEBUG [CalintfImpl] Close for 2012-08-10 17:27:10.314 17:27:10,423 DEBUG [CaldavBWServlet] ------------------------ Dump of response - ------------------ 17:27:10,423 DEBUG [CaldavBWServlet] <?xml version="1.0" encoding="UTF-8" ?> <DAV:multistatus xmlns:DAV="DAV:" xmlns="urn:ietf:params:xml:ns:caldav" xmlns:ical="http://www.w3.org/2002/12/cal/ical#"> 17:27:10,423 DEBUG [CaldavBWServlet] ---------------------- End dump of response ----------------- 17:27:10,423 DEBUG [CaldavBWServlet] contentLength=191 17:27:10,423 INFO [SessionListener] SESSION-END:B7A39E8D53AE9B75B14A87466349C89 F:?:0:142:130M:594M 17:27:10,423 INFO [[/ucaldav]] ========= Session destroyed(?): 0 active. vm(use d, max)=(130M, 594M)

    Apereo Issues | 4 years ago | Matej Spiller-Muys
    org.hibernate.QueryException: could not resolve property: valu e of: org.bedework.calfacade.BwCategory [select distinct ev from org.bedework.ca lfacade.BwEventObj ev left outer join ev.categories as joined_categories where ev.tombstoned=false and (((ev.entityType=:fq__0) and ((select count(*) from ev. categories categories_x where lower(categories_x.value) like :fq__1) > 0) and (e v.colPath=:fq__2)))]
  2. 0

    1. CalDav is return everything is OK even when there is exception on the server. There is some bad exception handling eating the error away. 2. request <?xml version="1.0"?> <C:calendar-query xmlns:C="urn:ietf:params:xml:ns:caldav"> <D:prop xmlns:D="DAV:"> <D:getetag/> <D:allprop/> <C:calendar-data> <C:comp name="VCALENDAR"/> </C:calendar-data> </D:prop> <C:filter> <C:comp-filter name="VCALENDAR"> <C:comp-filter name="VEVENT"> <C:prop-filter name="CATEGORIES"> <C:text-match caseless="yes" collation="i;ascii-casemap">TEST</C:text-match> </C:prop-filter> </C:comp-filter> </C:comp-filter> </C:filter> </C:calendar-query> 3. server log 17:27:10,283 DEBUG [CaldavBWServlet] entry: REPORT 17:27:10,283 DEBUG [CaldavBWServlet] Request headers 17:27:10,283 DEBUG [CaldavBWServlet] authorization = "Basic **********" 17:27:10,283 DEBUG [CaldavBWServlet] user-agent = "Jakarta Commons-HttpClient/ 3.1" 17:27:10,283 DEBUG [CaldavBWServlet] host = "d014:8080" 17:27:10,283 DEBUG [CaldavBWServlet] content-length = "625" 17:27:10,283 DEBUG [CaldavBWServlet] depth = "1" 17:27:10,283 DEBUG [CaldavBWServlet] content-type = "text/xml" 17:27:10,283 DEBUG [CaldavBWServlet] Request parameters - global info and uris 17:27:10,283 DEBUG [CaldavBWServlet] getRemoteAddr = 10.17.22.28 17:27:10,283 DEBUG [CaldavBWServlet] getRequestURI = /ucaldav/user/eVpisnik/cale ndar/ 17:27:10,283 DEBUG [CaldavBWServlet] getRemoteUser = eVpisnik 17:27:10,283 DEBUG [CaldavBWServlet] getRequestedSessionId = null 17:27:10,283 DEBUG [CaldavBWServlet] HttpUtils.getRequestURL(req) = http://d014: 8080/ucaldav/user/eVpisnik/calendar/ 17:27:10,283 DEBUG [CaldavBWServlet] contextPath=/ucaldav 17:27:10,283 DEBUG [CaldavBWServlet] query=null 17:27:10,298 DEBUG [CaldavBWServlet] contentlen=625 17:27:10,298 DEBUG [CaldavBWServlet] request=org.apache.catalina.connector.Reque stFacade@870b6e 17:27:10,298 DEBUG [CaldavBWServlet] parameters: 17:27:10,298 DEBUG [CaldavBWServlet] Request parameters 17:27:10,298 INFO [SessionListener] SESSION-START:B7A39E8D53AE9B75B14A87466349C 89F:?:1:142:139M:594M 17:27:10,298 INFO [[/ucaldav]] ========= New session(?): 1 active, 142 total. v m(used, max)=(139M, 594M) 17:27:10,298 DEBUG [CalintfImpl] New hibernate session for null 17:27:10,298 DEBUG [CalintfImpl] Open session for null 17:27:10,298 DEBUG [CalintfImpl] Begin transaction for null 17:27:10,298 DEBUG [CalSvc] Authenticated user eVpisnik logged on 17:27:10,298 DEBUG [UserGroupsLdapImpl] Logged into LDAP server, javax.naming.ld ap.InitialLdapContext@a3c486 17:27:10,298 DEBUG [UserGroupsLdapImpl] Logged into LDAP server, javax.naming.ld ap.InitialLdapContext@87c2e2 17:27:10,314 DEBUG [CalintfImpl] End transaction for 2012-08-10 17:27:10.314 17:27:10,314 DEBUG [CalintfImpl] Close for 2012-08-10 17:27:10.314 17:27:10,314 DEBUG [CalintfImpl] New hibernate session for 2012-08-10 17:27:10.3 14 17:27:10,314 DEBUG [MessageProcessor] Event USER_LOGIN 17:27:10,314 DEBUG [CalintfImpl] Open session for 2012-08-10 17:27:10.314 17:27:10,314 DEBUG [CalintfImpl] Begin transaction for 2012-08-10 17:27:10.314 17:27:10,330 DEBUG [CalintfImpl] End transaction for 2012-08-10 17:27:10.314 17:27:10,330 DEBUG [CalintfImpl] Close for 2012-08-10 17:27:10.314 17:27:10,330 DEBUG [CalintfImpl] New hibernate session for 2012-08-10 17:27:10.3 14 17:27:10,330 DEBUG [MessageProcessor] Event USER_SVCINIT 17:27:10,330 DEBUG [CalintfImpl] Open session for 2012-08-10 17:27:10.314 17:27:10,330 DEBUG [CalintfImpl] Begin transaction for 2012-08-10 17:27:10.314 17:27:10,330 DEBUG [CaldavBWServlet] No charset specified in request; forced to UTF-8 17:27:10,330 DEBUG [CaldavReportMethod] ReportMethod: doMethod 17:27:10,330 DEBUG [CaldavBWIntf] [142] <?xml version="1.0"?> <C:calendar-query xmlns:C="urn:ietf:params:xml:ns:caldav"> <D:prop xmlns:D="DAV:"> <D:getetag/> <D:allprop/> <C:calendar-data> <C:comp name="VCALENDAR"/> </C:calendar-data> </D:prop> <C:filter> <C:comp-filter name="VCALENDAR"> <C:comp-filter name="VEVENT"> <C:prop-filter name="CATEGORIES"> <C:text-match caseless="yes" collation="i;ascii-casemap">TES T</C:text-match> </C:prop-filter> </C:comp-filter> </C:comp-filter> </C:filter> </C:calendar-query> 17:27:10,330 DEBUG [CaldavReportMethod] ReportMethod: depth=1 17:27:10,330 DEBUG [CaldavBWIntf] [142] prop: {DAV:}getetag 17:27:10,330 DEBUG [CaldavBWIntf] [142] prop: {DAV:}allprop 17:27:10,330 DEBUG [CalData] calendar-data node type: 1 name:C:comp 17:27:10,330 DEBUG [CalData] <calendar-data content-type="text/calendar"> 17:27:10,330 DEBUG [CalData] <comp name=VCALENDAR> 17:27:10,330 DEBUG [CalData] </comp> 17:27:10,330 DEBUG [CalData] </calendar-data> 17:27:10,330 DEBUG [CaldavBWIntf] [142] prop: {urn:ietf:params:xml:ns:caldav}cal endar-data 17:27:10,408 DEBUG [CaldavReportMethod] REPORT: query 17:27:10,408 DEBUG [CaldavReportMethod] <filter> 17:27:10,408 DEBUG [CaldavReportMethod] <comp-filter name="VCALENDAR"> 17:27:10,408 DEBUG [CaldavReportMethod] <comp-filter name="VEVENT"> 17:27:10,408 DEBUG [CaldavReportMethod] <prop-filter name="CATEGORIES"> 17:27:10,408 DEBUG [CaldavReportMethod] <text-match collation=i;ascii-ca semap negate-condition=no> 17:27:10,408 DEBUG [CaldavReportMethod] TEST 17:27:10,408 DEBUG [CaldavReportMethod] </text-match> 17:27:10,408 DEBUG [CaldavReportMethod] </prop-filter> 17:27:10,408 DEBUG [CaldavReportMethod] </comp-filter> 17:27:10,408 DEBUG [CaldavReportMethod] </comp-filter> 17:27:10,408 DEBUG [CaldavReportMethod] </filter> 17:27:10,408 DEBUG [CaldavBWServlet] setStatus(207) 17:27:10,408 DEBUG [CaldavBWServlet] getWriter called 17:27:10,408 DEBUG [CaldavReportMethod] resourceUri: /user/eVpisnik/calendar/ 17:27:10,408 DEBUG [CaldavBWIntf] [142] About to get node for /user/eVpisnik/cal endar/ 17:27:10,408 DEBUG [CaldavBWIntf] [142] Normalized uri=/user/eVpisnik/calendar 17:27:10,408 DEBUG [CaldavBWIntf] [142] search for collection uri "/user/eVpisni k/calendar" 17:27:10,408 DEBUG [CaldavBWIntf] [142] create collection uri - cal="/user/eVpis nik/calendar" 17:27:10,408 DEBUG [CaldavReportMethod] REPORT: preq not null 17:27:10,408 DEBUG [CaldavReportMethod] doNodeAndChildren: curDepth=0 maxDepth=1 uri=/user/eVpisnik/calendar 17:27:10,408 DEBUG [CaldavReportMethod] getNodes: /user/eVpisnik/calendar 17:27:10,408 DEBUG [CoreEvents] getEvents for start=null end=null 17:27:10,408 DEBUG [CoreEvents] select distinct ev from org.bedework.calfacade.B wEventObj ev left outer join ev.categories as joined_categories where ev.tombst oned=false and (((ev.entityType=:fq__0) and ((select count(*) from ev.categorie s categories_x where lower(categories_x.value) like :fq__1) > 0) and (ev.colPath =:fq__2))) 17:27:10,423 DEBUG [CalintfImpl] handleException called 17:27:10,423 ERROR [CalintfImpl] org.bedework.calcore.hibernate.HibSessionImpl@1 0d731b org.hibernate.QueryException: could not resolve property: value of: org.bedework .calfacade.BwCategory [select distinct ev from org.bedework.calfacade.BwEventObj ev left outer join ev.categories as joined_categories where ev.tombstoned=fals e and (((ev.entityType=:fq__0) and ((select count(*) from ev.categories categor ies_x where lower(categories_x.value) like :fq__1) > 0) and (ev.colPath=:fq__2)) )] at org.hibernate.persister.entity.AbstractPropertyMapping.propertyExcept ion(AbstractPropertyMapping.java:81) at org.hibernate.persister.entity.AbstractPropertyMapping.toType(Abstrac tPropertyMapping.java:75) at org.hibernate.persister.entity.AbstractEntityPersister.toType(Abstrac tEntityPersister.java:1465) at org.hibernate.persister.collection.AbstractCollectionPersister.toType (AbstractCollectionPersister.java:1495) at org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElemen tType.java:315) at org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.ja va:487) at org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:611) at org.hibernate.hql.ast.tree.DotNode.prepareLhs(DotNode.java:263) at org.hibernate.hql.ast.tree.DotNode.resolveInFunctionCall(DotNode.java :185) at org.hibernate.hql.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:877) at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1 330) at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWal ker.java:4471) at org.hibernate.hql.antlr.HqlSqlBaseWalker.functionCall(HqlSqlBaseWalke r.java:2583) at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1 404) at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWal ker.java:4471) at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWal ker.java:4088) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:2047) at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker .java:831) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java: 617) at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWal ker.java:4479) at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWal ker.java:4016) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:2047) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:1975) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:1972) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:1975) at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker .java:831) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java: 617) at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWa lker.java:301) at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.j ava:244) at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl .java:256) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorIm pl.java:187) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl .java:138) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCa che.java:124) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessio nImpl.java:156) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImp l.java:135) at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770) at org.bedework.calcore.hibernate.HibSessionImpl.createQuery(HibSessionI mpl.java:323) at org.bedework.calcore.hibernate.EventQueryBuilder.createQuery(EventQue ryBuilder.java:308) at org.bedework.calcore.hibernate.CoreEvents.eventsQuery(CoreEvents.java :2990) at org.bedework.calcore.hibernate.CoreEvents.getEvents(CoreEvents.java:4 87) at org.bedework.calcore.hibernate.CalintfImpl.getEvents(CalintfImpl.java :915) at org.bedework.calsvc.Events.getMatching(Events.java:812) at org.bedework.calsvc.Events.getEvents(Events.java:140) at org.bedework.caldav.bwserver.BwSysIntfImpl.getEvents(BwSysIntfImpl.ja va:777) at org.bedework.caldav.server.filter.FilterHandler.query(FilterHandler.j ava:181) at org.bedework.caldav.server.CaldavBWIntf.query(CaldavBWIntf.java:1689) at org.bedework.caldav.server.CaldavReportMethod.getNodes(CaldavReportMe thod.java:641) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:615) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:572) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:552) at org.bedework.caldav.server.CaldavReportMethod.process(CaldavReportMet hod.java:388) at org.bedework.caldav.server.CaldavReportMethod.processResp(CaldavRepor tMethod.java:370) at org.bedework.caldav.server.CaldavReportMethod.process(CaldavReportMet hod.java:123) at edu.rpi.cct.webdav.servlet.common.ReportMethod.doMethod(ReportMethod. java:114) at edu.rpi.cct.webdav.servlet.common.WebdavServlet.service(WebdavServlet .java:149) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi lter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:235) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit yAssociationValve.java:190) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica torBase.java:525) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv e.java:92) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce ss(SecurityContextEstablishmentValve.java:126) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok e(SecurityContextEstablishmentValve.java:70) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC onnectionValve.java:158) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: 567) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav a:330) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :829) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ss(Http11Protocol.java:598) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44 7) at java.lang.Thread.run(Thread.java:662) 17:27:10,423 ERROR [FilterHandler] org.bedework.caldav.server.filter.FilterHandl er@1f4a edu.rpi.cct.webdav.servlet.shared.WebdavException: org.bedework.calfacade.exc.Ca lFacadeException: org.hibernate.QueryException: could not resolve property: valu e of: org.bedework.calfacade.BwCategory [select distinct ev from org.bedework.ca lfacade.BwEventObj ev left outer join ev.categories as joined_categories where ev.tombstoned=false and (((ev.entityType=:fq__0) and ((select count(*) from ev. categories categories_x where lower(categories_x.value) like :fq__1) > 0) and (e v.colPath=:fq__2)))] at org.bedework.caldav.bwserver.BwSysIntfImpl.getEvents(BwSysIntfImpl.ja va:805) at org.bedework.caldav.server.filter.FilterHandler.query(FilterHandler.j ava:181) at org.bedework.caldav.server.CaldavBWIntf.query(CaldavBWIntf.java:1689) at org.bedework.caldav.server.CaldavReportMethod.getNodes(CaldavReportMe thod.java:641) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:615) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:572) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:552) at org.bedework.caldav.server.CaldavReportMethod.process(CaldavReportMet hod.java:388) at org.bedework.caldav.server.CaldavReportMethod.processResp(CaldavRepor tMethod.java:370) at org.bedework.caldav.server.CaldavReportMethod.process(CaldavReportMet hod.java:123) at edu.rpi.cct.webdav.servlet.common.ReportMethod.doMethod(ReportMethod. java:114) at edu.rpi.cct.webdav.servlet.common.WebdavServlet.service(WebdavServlet .java:149) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi lter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:235) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit yAssociationValve.java:190) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica torBase.java:525) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv e.java:92) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce ss(SecurityContextEstablishmentValve.java:126) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok e(SecurityContextEstablishmentValve.java:70) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC onnectionValve.java:158) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: 567) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav a:330) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :829) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ss(Http11Protocol.java:598) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44 7) at java.lang.Thread.run(Thread.java:662) Caused by: org.bedework.calfacade.exc.CalFacadeException: org.hibernate.QueryExc eption: could not resolve property: value of: org.bedework.calfacade.BwCategory [select distinct ev from org.bedework.calfacade.BwEventObj ev left outer join ev .categories as joined_categories where ev.tombstoned=false and (((ev.entityTyp e=:fq__0) and ((select count(*) from ev.categories categories_x where lower(cate gories_x.value) like :fq__1) > 0) and (ev.colPath=:fq__2)))] at org.bedework.calcore.hibernate.HibSessionImpl.handleException(HibSess ionImpl.java:1082) at org.bedework.calcore.hibernate.HibSessionImpl.handleException(HibSess ionImpl.java:1045) at org.bedework.calcore.hibernate.HibSessionImpl.createQuery(HibSessionI mpl.java:326) at org.bedework.calcore.hibernate.EventQueryBuilder.createQuery(EventQue ryBuilder.java:308) at org.bedework.calcore.hibernate.CoreEvents.eventsQuery(CoreEvents.java :2990) at org.bedework.calcore.hibernate.CoreEvents.getEvents(CoreEvents.java:4 87) at org.bedework.calcore.hibernate.CalintfImpl.getEvents(CalintfImpl.java :915) at org.bedework.calsvc.Events.getMatching(Events.java:812) at org.bedework.calsvc.Events.getEvents(Events.java:140) at org.bedework.caldav.bwserver.BwSysIntfImpl.getEvents(BwSysIntfImpl.ja va:777) ... 34 more Caused by: org.hibernate.QueryException: could not resolve property: value of: o rg.bedework.calfacade.BwCategory [select distinct ev from org.bedework.calfacade .BwEventObj ev left outer join ev.categories as joined_categories where ev.tomb stoned=false and (((ev.entityType=:fq__0) and ((select count(*) from ev.categor ies categories_x where lower(categories_x.value) like :fq__1) > 0) and (ev.colPa th=:fq__2)))] at org.hibernate.persister.entity.AbstractPropertyMapping.propertyExcept ion(AbstractPropertyMapping.java:81) at org.hibernate.persister.entity.AbstractPropertyMapping.toType(Abstrac tPropertyMapping.java:75) at org.hibernate.persister.entity.AbstractEntityPersister.toType(Abstrac tEntityPersister.java:1465) at org.hibernate.persister.collection.AbstractCollectionPersister.toType (AbstractCollectionPersister.java:1495) at org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElemen tType.java:315) at org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.ja va:487) at org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:611) at org.hibernate.hql.ast.tree.DotNode.prepareLhs(DotNode.java:263) at org.hibernate.hql.ast.tree.DotNode.resolveInFunctionCall(DotNode.java :185) at org.hibernate.hql.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:877) at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1 330) at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWal ker.java:4471) at org.hibernate.hql.antlr.HqlSqlBaseWalker.functionCall(HqlSqlBaseWalke r.java:2583) at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1 404) at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWal ker.java:4471) at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWal ker.java:4088) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:2047) at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker .java:831) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java: 617) at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWal ker.java:4479) at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWal ker.java:4016) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:2047) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:1975) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:1972) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker .java:1975) at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker .java:831) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java: 617) at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWa lker.java:301) at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.j ava:244) at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl .java:256) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorIm pl.java:187) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl .java:138) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCa che.java:124) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessio nImpl.java:156) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImp l.java:135) at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770) at org.bedework.calcore.hibernate.HibSessionImpl.createQuery(HibSessionI mpl.java:323) ... 41 more 17:27:10,423 ERROR [CaldavBWServlet] org.bedework.caldav.server.CaldavBWServlet@ 1e25c3 edu.rpi.cct.webdav.servlet.shared.WebdavException at org.bedework.caldav.server.filter.FilterHandler.query(FilterHandler.j ava:195) at org.bedework.caldav.server.CaldavBWIntf.query(CaldavBWIntf.java:1689) at org.bedework.caldav.server.CaldavReportMethod.getNodes(CaldavReportMe thod.java:641) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:615) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:572) at org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(Calda vReportMethod.java:552) at org.bedework.caldav.server.CaldavReportMethod.process(CaldavReportMet hod.java:388) at org.bedework.caldav.server.CaldavReportMethod.processResp(CaldavRepor tMethod.java:370) at org.bedework.caldav.server.CaldavReportMethod.process(CaldavReportMet hod.java:123) at edu.rpi.cct.webdav.servlet.common.ReportMethod.doMethod(ReportMethod. java:114) at edu.rpi.cct.webdav.servlet.common.WebdavServlet.service(WebdavServlet .java:149) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi lter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:235) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit yAssociationValve.java:190) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica torBase.java:525) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv e.java:92) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce ss(SecurityContextEstablishmentValve.java:126) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok e(SecurityContextEstablishmentValve.java:70) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC onnectionValve.java:158) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: 567) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav a:330) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :829) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ss(Http11Protocol.java:598) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44 7) at java.lang.Thread.run(Thread.java:662) 17:27:10,423 DEBUG [CalintfImpl] Enter rollback 17:27:10,423 DEBUG [CaldavBWServlet] setStatus(500) message=null 17:27:10,423 DEBUG [CalintfImpl] End transaction for 2012-08-10 17:27:10.314 17:27:10,423 DEBUG [CalintfImpl] Enter rollback 17:27:10,423 DEBUG [CalintfImpl] Close for 2012-08-10 17:27:10.314 17:27:10,423 DEBUG [CaldavBWServlet] ------------------------ Dump of response - ------------------ 17:27:10,423 DEBUG [CaldavBWServlet] <?xml version="1.0" encoding="UTF-8" ?> <DAV:multistatus xmlns:DAV="DAV:" xmlns="urn:ietf:params:xml:ns:caldav" xmlns:ical="http://www.w3.org/2002/12/cal/ical#"> 17:27:10,423 DEBUG [CaldavBWServlet] ---------------------- End dump of response ----------------- 17:27:10,423 DEBUG [CaldavBWServlet] contentLength=191 17:27:10,423 INFO [SessionListener] SESSION-END:B7A39E8D53AE9B75B14A87466349C89 F:?:0:142:130M:594M 17:27:10,423 INFO [[/ucaldav]] ========= Session destroyed(?): 0 active. vm(use d, max)=(130M, 594M)

    Apereo Issues | 4 years ago | Matej Spiller-Muys
    org.hibernate.QueryException: could not resolve property: value of: org.bedework .calfacade.BwCategory [select distinct ev from org.bedework.calfacade.BwEventObj ev left outer join ev.categories as joined_categories where ev.tombstoned=fals e and (((ev.entityType=:fq__0) and ((select count(*) from ev.categories categor ies_x where lower(categories_x.value) like :fq__1) > 0) and (ev.colPath=:fq__2)) )]
  3. 0

    Hibernate many-to-many data retrival, via query

    Stack Overflow | 3 years ago | Harbir
    org.hibernate.QueryException: could not resolve property: userID of: com.smallworks.model.Contact [select contact from com.smallworks.model.Contact contact join contact.userSet u where u.userID=:userID]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    While migrating from hib 3.0.5 to 3.1 this error appear: id is a composite key containing accessphonenumbers 10 janv. 11:49:00:ERROR (ErrorCounter.reportError) - illegal syntax near collection: id 10 janv. 11:49:00:ERROR (ErrorCounter.reportError) - illegal syntax near collection: id 10 janv. 11:49:00:ERROR (ErrorCounter.reportError) - illegal syntax near collection: id 10 janv. 11:49:00:ERROR (ErrorCounter.reportError) - illegal syntax near collection: id 10 janv. 11:49:00:ERROR (SessionFactoryImpl.<init>) - Error in named query: get.free.groupedphone.by_groupid org.hibernate.QueryException: could not resolve property: accessphonenumbers of: com.x.y.common.db.hib.vo.fulfilment.Groupedphonenumbers [ select groups.groupid,phones from com.x.y.common.db.hib.vo.fulfilment.Accessnumbergroups as groups inner join groups.groupedphonenumbersSet.id.accessphonenumbers as phones where phones.bridges=:bridge_id and phones.accesstypes=:accesstype_id and groups.groupid=:group_id ] at org.hibernate.persister.entity.AbstractPropertyMapping.throwPropertyException(AbstractPropertyMapping.java:43) at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:37) at org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1265) at org.hibernate.persister.collection.AbstractCollectionPersister.toType(AbstractCollectionPersister.java:1255) at org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElementType.java:278) at org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.java:372) at org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:528) at org.hibernate.hql.ast.tree.DotNode.prepareLhs(DotNode.java:221) at org.hibernate.hql.ast.tree.DotNode.resolve(DotNode.java:172) at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:94) at org.hibernate.hql.ast.HqlSqlWalker.createFromJoinElement(HqlSqlWalker.java:313) at org.hibernate.hql.antlr.HqlSqlBaseWalker.joinElement(HqlSqlBaseWalker.java:3258) at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3050) at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2928) at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:686) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:542) at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:279) at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:227) at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:218) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:158) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:105) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:74) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:53) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71) at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:363) at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:327) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1154) at com.genesys.frameworks.db.hibernate_classic.GenStartup.buildHibernateSession(GenStartup.java:151) at com.genesys.hermes.common.util.MainHibernateStartup.startHibernate(MainHibernateStartup.java:57) at com.genesys.hermes.common.util.MainHibernateStartup.main(MainHibernateStartup.java:17) 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:324) at weblogic.j2ee.AppLifecycleListenerInternal.invokeMain(AppLifecycleListenerInternal.java:61) at weblogic.j2ee.AppLifecycleListenerInternal.preStart(AppLifecycleListenerInternal.java:34) at weblogic.j2ee.ListenerInvocationAction.run(ListenerInvocationAction.java:50) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118) at weblogic.j2ee.J2EEApplicationContainer.notifySecureListener(J2EEApplicationContainer.java:4721) at weblogic.j2ee.J2EEApplicationContainer.notify(J2EEApplicationContainer.java:4683) at weblogic.j2ee.J2EEApplicationContainer.prepare(J2EEApplicationContainer.java:1005) at weblogic.management.deploy.slave.SlaveDeployer$ComponentActivateTask.prepareContainer(SlaveDeployer.java:2444) at weblogic.management.deploy.slave.SlaveDeployer$ActivateTask.createContainer(SlaveDeployer.java:2394) at weblogic.management.deploy.slave.SlaveDeployer$ActivateTask.prepare(SlaveDeployer.java:2310) at weblogic.management.deploy.slave.SlaveDeployer.processPrepareTask(SlaveDeployer.java:866) at weblogic.management.deploy.slave.SlaveDeployer.prepareDelta(SlaveDeployer.java:594) at weblogic.management.deploy.slave.SlaveDeployer.prepareUpdate(SlaveDeployer.java:508) at weblogic.drs.internal.SlaveCallbackHandler$1.execute(SlaveCallbackHandler.java:25) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)

    Hibernate JIRA | 1 decade ago | Kermitt
    org.hibernate.QueryException: could not resolve property: accessphonenumbers of: com.x.y.common.db.hib.vo.fulfilment.Groupedphonenumbers [ select groups.groupid,phones from com.x.y.common.db.hib.vo.fulfilment.Accessnumbergroups as groups inner join groups.groupedphonenumbersSet.id.accessphonenumbers as phones where phones.bridges=:bridge_id and phones.accesstypes=:accesstype_id and groups.groupid=:group_id ]
  6. 0

    Caused by: org.springframework.orm.hibernate3.HibernateQueryException:

    verydemo.com | 11 months ago
    org.hibernate.QueryException: could not resolve property: reportId of: com.adr.report.reportmanage.bean.AdrMedDetail [select count(*) from com.adr.report.reportmanage.bean.AdrReport a, com.adr.report.reportmanage.bean.AdrMedDetail b where a.currentareacode like ? and a.id=b.reportId and b.approach!=? and a.flag=1 group by b.approach]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.hibernate.QueryException

      could not resolve property: value of: o rg.bedework.calfacade.BwCategory [select distinct ev from org.bedework.calfacade .BwEventObj ev left outer join ev.categories as joined_categories where ev.tomb stoned=false and (((ev.entityType=:fq__0) and ((select count(*) from ev.categor ies categories_x where lower(categories_x.value) like :fq__1) > 0) and (ev.colPa th=:fq__2)))]

      at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException()
    2. Hibernate
      AbstractCollectionPersister.toType
      1. org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:81)
      2. org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:75)
      3. org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1465)
      4. org.hibernate.persister.collection.AbstractCollectionPersister.toType(AbstractCollectionPersister.java:1495)
      4 frames
    3. Hibernate HQL/JP-QL Parser
      HqlSqlWalker.resolve
      1. org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElementType.java:315)
      2. org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.java:487)
      3. org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:611)
      4. org.hibernate.hql.ast.tree.DotNode.prepareLhs(DotNode.java:263)
      5. org.hibernate.hql.ast.tree.DotNode.resolveInFunctionCall(DotNode.java:185)
      6. org.hibernate.hql.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:877)
      6 frames
    4. Hibernate
      HqlSqlBaseWalker.statement
      1. org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1330)
      2. org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4471)
      3. org.hibernate.hql.antlr.HqlSqlBaseWalker.functionCall(HqlSqlBaseWalker.java:2583)
      4. org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1404)
      5. org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4471)
      6. org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4088)
      7. org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2047)
      8. org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:831)
      9. org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:617)
      10. org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4479)
      11. org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4016)
      12. org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2047)
      13. org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1975)
      14. org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1972)
      15. org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1975)
      16. org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:831)
      17. org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:617)
      18. org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
      19. org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:244)
      19 frames
    5. Hibernate HQL/JP-QL Parser
      QueryTranslatorImpl.compile
      1. org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:256)
      2. org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:187)
      3. org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:138)
      3 frames
    6. Hibernate
      SessionImpl.createQuery
      1. org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
      2. org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
      3. org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
      4. org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
      5. org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
      6. org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
      6 frames
    7. org.bedework.calcore
      CalintfImpl.getEvents
      1. org.bedework.calcore.hibernate.HibSessionImpl.createQuery(HibSessionImpl.java:323)
      2. org.bedework.calcore.hibernate.EventQueryBuilder.createQuery(EventQueryBuilder.java:308)
      3. org.bedework.calcore.hibernate.CoreEvents.eventsQuery(CoreEvents.java:2990)
      4. org.bedework.calcore.hibernate.CoreEvents.getEvents(CoreEvents.java:487)
      5. org.bedework.calcore.hibernate.CalintfImpl.getEvents(CalintfImpl.java:915)
      5 frames
    8. org.bedework.calsvc
      Events.getEvents
      1. org.bedework.calsvc.Events.getMatching(Events.java:812)
      2. org.bedework.calsvc.Events.getEvents(Events.java:140)
      2 frames
    9. org.bedework.caldav
      CaldavReportMethod.process
      1. org.bedework.caldav.bwserver.BwSysIntfImpl.getEvents(BwSysIntfImpl.java:777)
      2. org.bedework.caldav.server.filter.FilterHandler.query(FilterHandler.java:181)
      3. org.bedework.caldav.server.CaldavBWIntf.query(CaldavBWIntf.java:1689)
      4. org.bedework.caldav.server.CaldavReportMethod.getNodes(CaldavReportMethod.java:641)
      5. org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(CaldavReportMethod.java:615)
      6. org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(CaldavReportMethod.java:572)
      7. org.bedework.caldav.server.CaldavReportMethod.doNodeAndChildren(CaldavReportMethod.java:552)
      8. org.bedework.caldav.server.CaldavReportMethod.process(CaldavReportMethod.java:388)
      9. org.bedework.caldav.server.CaldavReportMethod.processResp(CaldavReportMethod.java:370)
      10. org.bedework.caldav.server.CaldavReportMethod.process(CaldavReportMethod.java:123)
      10 frames
    10. edu.rpi.cct
      WebdavServlet.service
      1. edu.rpi.cct.webdav.servlet.common.ReportMethod.doMethod(ReportMethod.java:114)
      2. edu.rpi.cct.webdav.servlet.common.WebdavServlet.service(WebdavServlet.java:149)
      2 frames
    11. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      1 frame
    12. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    13. JBoss Application Server Tomcat
      ReplyHeaderFilter.doFilter
      1. org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      1 frame
    14. Glassfish Core
      StandardContextValve.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      4 frames
    15. JBoss Application Server Tomcat
      SecurityAssociationValve.invoke
      1. org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
      1 frame
    16. Glassfish Core
      AuthenticatorBase.invoke
      1. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
      1 frame
    17. JBoss Application Server Tomcat
      SecurityContextEstablishmentValve.invoke
      1. org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
      2. org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
      3. org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
      3 frames
    18. Glassfish Core
      ErrorReportValve.invoke
      1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      2 frames
    19. JBoss Application Server Tomcat
      CachedConnectionValve.invoke
      1. org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
      1 frame
    20. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567)
      2. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      3. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
      3 frames
    21. Grizzly HTTP
      JIoEndpoint$Worker.run
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
      3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      3 frames
    22. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame