ref #6589 finalize update script for

[cdmlib.git] / cdmlib-persistence / src / main / java / eu / etaxonomy / cdm / persistence / dao / hibernate / name / TaxonNameDaoHibernateImpl.java

diff --git a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/name/TaxonNameDaoHibernateImpl.java b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/name/TaxonNameDaoHibernateImpl.java
index 3e111a7801a6397b10b65cb98a5822bbf7fe00c9..ff1245af80eabd8685308c493d79bebf953792ff 100644 (file)
--- a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/name/TaxonNameDaoHibernateImpl.java
+++ b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/name/TaxonNameDaoHibernateImpl.java
@@ -907,13 +907,13 @@ public class TaxonNameDaoHibernateImpl extends IdentifiableDaoBase<TaxonName> im
                        + " inRef.seriespart as inRefSeries, inRef.datepublished_start inRefPublishedStart, inRef.datepublished_end inRefPublishedEnd, inRef.volume as inRefVolume"
                        + " FROM TaxonBase tb"
                        + " LEFT OUTER JOIN TaxonName tnb ON tb.name_id = tnb.id"
-                       + "     LEFT OUTER JOIN OriginalSourceBase nosb ON tnb.nomenclaturalSource_id = nosb.id"
+                       + "     LEFT OUTER JOIN OriginalSourceBase nosb ON tnb.id = nosb.sourcedName_id"
                        + " LEFT OUTER JOIN Reference r ON nosb.citation_id = r.id"
                 + "    LEFT OUTER JOIN TaxonNode tn ON tn.taxon_id = tb.id"
                        + "     LEFT OUTER JOIN TaxonName_TypeDesignationBase typeMN ON typeMN.TaxonName_id = tnb.id"
                        + " LEFT OUTER JOIN TypeDesignationBase tdb ON tdb.id = typeMN.typedesignations_id"
                        + "     LEFT OUTER JOIN TaxonName nameType ON tdb.typename_id = nameType.id"
-                       + " LEFT OUTER JOIN OriginalSourceBase nameTypeOsb ON nameType.nomenclaturalSource_id = nameTypeOsb.id"
+                       + " LEFT OUTER JOIN OriginalSourceBase nameTypeOsb ON nameType.id = nameTypeOsb.sourcedName_id"
                        + "     LEFT OUTER JOIN Reference nameTypeRef ON nameTypeOsb.citation_id = nameTypeRef.id"
                 + "            LEFT OUTER JOIN Reference inRef ON inRef.id = r.inreference_id"
                        + "     LEFT OUTER JOIN TaxonBase accT ON accT.id = tb.acceptedTaxon_id"