fixing bug in loadRankSpecificRootNodes

diff --git a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonomicTreeDaoHibernateImpl.java b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonomicTreeDaoHibernateImpl.java
index a56ccc474577a5e64b08e080e10092a1a6ab12c7..e90bf6b01523e9e69db079a096b322dd3261648c 100644 (file)
--- a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonomicTreeDaoHibernateImpl.java
+++ b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonomicTreeDaoHibernateImpl.java
@@ -43,8 +43,9 @@ public class TaxonomicTreeDaoHibernateImpl extends IdentifiableDaoBase<Taxonomic
                indexedClasses[0] = TaxonomicTree.class;\r
        }\r
        \r
+       @SuppressWarnings("unchecked")\r
        public List<TaxonNode> loadRankSpecificRootNodes(TaxonomicTree taxonomicTree, Rank rank, List<String> propertyPaths){\r
-               String hql = "SELECT tn FROM TaxonNode tn LEFT JOIN tn.childNodes as ctn" +\r
+               String hql = "SELECT DISTINCT tn FROM TaxonNode tn LEFT JOIN tn.childNodes as ctn" +\r
                                " WHERE tn.taxonomicTree = :tree  AND (" +\r
                                " tn.taxon.name.rank = :rank" +\r
                                " OR (tn.taxon.name.rank < :rank AND tn.parent = null)" +\r