Project

General

Profile

Actions
Copy link

bug #7756

open

org.hibernate.QueryException in portal/taxon/{uuid}/subtree/media.json webservice related to relation direction param in prepareTaxonRelationshipQuery()

Added by Andreas Kohlbecker over 5 years ago. Updated over 5 years ago.

Status:
Feedback
Priority:
Highest
Assignee:
Andreas Müller
Category:
cdmlib
Target version:
Release 5.3
Start date:
Due date:
% Done:

80%

Estimated time:
Severity:
normal
Found in Version:

Description

http://api.cybertaxonomy.org/corvidae/portal/taxon/147cb0d4-0f0e-4ba4-a234-e0b55d51677a/subtree/media.json?type=ImageFile&relationships=831fcd88-e5c9-49e0-b06e-bbb67d1c05c9&relationshipsInvers=&includeTaxonDescriptions=1&includeOccurrences=1&includeTaxonNameDescriptions=

throws the exception:

...
Caused by: org.hibernate.QueryException: could not resolve property: null of: eu.etaxonomy.cdm.model.taxon.TaxonRelationship [SELECT  rel  FROM eu.etaxonomy.cdm.model.taxon.TaxonRelationship rel  WHERE rel.null = :relatedTaxon]
    at org.hibernate.QueryException.generateQueryException(QueryException.java:120)
    at org.hibernate.QueryException.wrapWithQueryString(QueryException.java:103)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:218)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:142)
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:115)
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:76)
    at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:150)
    at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:302)
    at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:240)
    at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1894)
    at eu.etaxonomy.cdm.persistence.dao.hibernate.taxon.TaxonDaoHibernateImpl.getTaxonRelationships(TaxonDaoHibernateImpl.java:1045)
    at eu.etaxonomy.cdm.api.service.TaxonServiceImpl.collectRelatedTaxa(TaxonServiceImpl.java:572)
    at eu.etaxonomy.cdm.api.service.TaxonServiceImpl.listRelatedTaxa(TaxonServiceImpl.java:538)
    at eu.etaxonomy.cdm.api.service.TaxonServiceImpl.listMedia(TaxonServiceImpl.java:769)
    at sun.reflect.GeneratedMethodAccessor25044.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
    at com.sun.proxy.$Proxy4291.listMedia(Unknown Source)
    at eu.etaxonomy.cdm.remote.controller.TaxonPortalController.getMediaForTaxon(TaxonPortalController.java:635)
    at eu.etaxonomy.cdm.remote.controller.TaxonPortalController.doGetSubtreeMedia(TaxonPortalController.java:587)
    at sun.reflect.GeneratedMethodAccessor25041.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:222)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:814)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:737)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:969)
    ... 61 more
...

Related issues

Related to EDIT - task #3560: Withheld unpublished taxa from webservice used in E+M dataportalResolvedAndreas Müller

Actions
Actions
Copy link

Also available in: Atom PDF