int lastBegunParentSiteNodeId = -1;

    while (results.hasMore())

    {

     

     

      List<SiteNodeVO> siteNodeChildrenVOList = (List<SiteNodeVO>)CacheController.getCachedObjectFromAdvancedCache("childSiteNodesCache", key);

         if(siteNodeChildrenVOList == null)

      {

           siteNodeChildrenVOList = new ArrayList<SiteNodeVO>();

      }

         boolean contains = false;

         for(SiteNodeVO existingSiteNodeVO : siteNodeChildrenVOList)

         {

           {

             contains = true;

             break;

           }

         }

         if(!contains)

         {

         }

    }

    logger.info("Clearing last node as we are probably not done with all it's children");

    CacheController.clearCacheForGroup("childSiteNodesCache", CacheController.getPooledString(3, lastBegunParentSiteNodeId));

    beginTransaction(db);

    try

    {

      childrenVOList = SiteNodeController.toVOList(children);

         

      //If any of the validations or setMethods reported an error, we throw them up now before create.

      ceb.throwIfNotEmpty();

           

    QueryResults results = oql.execute(Database.READONLY);

    while (results.hasMore())

    {

      if(CmsPropertyHandler.getAllowLocalizedSortAndVisibilityProperties())

      { 

        //logger.info("Name:" + siteNode.getName() + ":" + siteNode.getValueObject().getStateId() + ":" + siteNode.getValueObject().getIsProtected() + ":" + siteNode.getValueObject().getIsProtected());

        if(latestVersionVO == null)

        {

          //LanguageVO masterLanguageVO = LanguageController.getController().getMasterLanguage(siteNode.getValueObject().getRepositoryId(), db);

          //latestVersionVO = ContentVersionController.getContentVersionController().getLatestActiveContentVersionVO(siteNode.getMetaInfoContentId(), masterLanguageVO.getLanguageId(), db);

        }

        if(latestVersionVO != null)

        {

          String localizedIsHidden = ContentVersionController.getContentVersionController().getAttributeValue(latestVersionVO, "HideInNavigation", false);

          String localizedSortOrder = ContentVersionController.getContentVersionController().getAttributeValue(latestVersionVO, "SortOrder", false);

   

          //System.out.println("localizedIsHidden:" + localizedIsHidden);

          //System.out.println("localizedSortOrder:" + localizedSortOrder);

          if(localizedIsHidden != null/* && !localizedIsHidden.equals("")*/)

          {

            if(localizedIsHidden.equals("true"))

            else

          }

         

          if(localizedSortOrder != null && !localizedSortOrder.equals(""))

          {

          }

          else

        }

        else

      }

     

    }

   

    results.close();

    oql.close();

       

   

    QueryResults results = oql.execute(Database.READONLY);

    if (results.hasMore())

    {

    }

    results.close();

    oql.close();

   */

         

  public SiteNode getRootSiteNode(Integer repositoryId, Database db) throws ConstraintException, SystemException, Exception

  {

   

    OQLQuery oql = db.getOQLQuery( "SELECT s FROM org.infoglue.cms.entities.structure.impl.simple.SiteNodeImpl s WHERE is_undefined(s.parentSiteNode) AND s.repository.repositoryId = $1");

    oql.bind(repositoryId);

   

    QueryResults results = oql.execute();

  {

    Database db = CastorDatabaseService.getDatabase();

    ConstraintExceptionBuffer ceb = new ConstraintExceptionBuffer();

   

    Map<String,String> pageUrls = new HashMap<String, String>();

    beginTransaction(db);

    try

    {

      //Validation that checks the entire object

      siteNodeVO.validate();

      if(newParentSiteNodeId == null)

      {

        logger.warn("You must specify the new parent-siteNode......");

        throw new ConstraintException("SiteNode.parentSiteNodeId", "3403");

      }

      if(siteNodeVO.getId().intValue() == newParentSiteNodeId.intValue())

      {

        logger.warn("You cannot have the siteNode as it's own parent......");

        throw new ConstraintException("SiteNode.parentSiteNodeId", "3401");

      }

     

      siteNode          = getSiteNodeWithId(siteNodeVO.getSiteNodeId(), db);

      oldParentSiteNode = siteNode.getParentSiteNode();

      newParentSiteNode = getSiteNodeWithId(newParentSiteNodeId, db);

      {

        logger.warn("You cannot specify the same node as it originally was located in......");

        throw new ConstraintException("SiteNode.parentSiteNodeId", "3404");

      }

      while(tempSiteNode != null)

      {

        {

          logger.warn("You cannot move the node to a child under it......");

          throw new ConstraintException("SiteNode.parentSiteNodeId", "3402");

        }

      }

      pageUrls = RedirectController.getController().getNiceURIMapBeforeMove(db, siteNodeVO.getRepositoryId(), siteNodeVO.getSiteNodeId(), principal);

      logger.info("Setting the new Parent siteNode:" + siteNode.getSiteNodeId() + " " + newParentSiteNode.getSiteNodeId());

          siteNode.setRepository((RepositoryImpl)newRepository);

        Iterator ChildSiteNodesIterator = siteNode.getChildSiteNodes().iterator();

        while(ChildSiteNodesIterator.hasNext())

        {

            changeRepositoryRecursive(childSiteNode, newRepository, principal, db);

        }

      }

  }

      QueryResults results = oql.execute();

   

    while(results.hasMore())

        {

          siteNodes.add(siteNode);

        }

   

    results.close();

    oql.close();

      QueryResults results = oql.execute(Database.READONLY);

   

    while(results.hasMore())

        {

          siteNodes.add(siteNode);

        }

   

    results.close();

    oql.close();

    }      

    public void setMetaInfoContentId(Integer siteNodeId, Integer metaInfoContentId, Database db) throws ConstraintException, SystemException

    {

    }