Project

General

Profile

Actions

bug #9457

closed

Distribution editor: Taxon filter broken due to invalid HQL in TaxonNodeServiceImpl.getUuidAndTitleCache()

Added by Andreas Kohlbecker about 3 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
Highest
Category:
cdmlib
Target version:
Start date:
Due date:
% Done:

100%

Estimated time:
Severity:
normal
Found in Version:

Description

to reproduce:

10:25:27.241 [flora-cuba] [qtp527446182-11880] ERROR c.vaadin.server.DefaultErrorHandler -
org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: cls near line 1, column 367 [SELECT new eu.etaxonomy.cdm.persistence.dto.SortableTaxon
NodeQueryResult( tn.uuid, tn.id, t.titleCache, rank )  FROM eu.etaxonomy.cdm.model.taxon.TaxonNode tn    INNER JOIN tn.taxon AS t    INNER JOIN tn.classifica
tion AS cls    INNER JOIN t.name AS name    LEFT OUTER JOIN name.rank AS rank WHERE t.titleCache LIKE :pattern OR t.titleCache LIKE :doubtfulPatternAND cls.u
uid = :classificationUuid]
        at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:74)
        at org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:91)
        at org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:287)
        at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:186)
        at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:141)
        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:1907)
        at eu.etaxonomy.cdm.persistence.dao.hibernate.taxon.TaxonNodeDaoHibernateImpl.getUuidAndTitleCache(TaxonNodeDaoHibernateImpl.java:222)
        at eu.etaxonomy.cdm.api.service.TaxonNodeServiceImpl.getUuidAndTitleCache(TaxonNodeServiceImpl.java:196)

Related issues

Related to EDIT - bug #9461: Filter in vaadin distribution editor does not workResolvedAndreas Müller

Actions
Has duplicate EDIT - bug #7254: Filter in vaadin distribution editor throws exceptionWorksformeAndreas Müller

Actions
Actions

Also available in: Atom PDF