[Building Sakai] Doubt in login module

[Aaron Zeckoski]

Alan,
This is the site caching again so make sure you link this ticket to the main
one on site caching.

-AZ


On Mon, Mar 7, 2011 at 3:01 AM, Berg, Alan <A.M.Berg at uva.nl> wrote:

>  Hi Rajesh,
>
> It looks like part of the Portal code.  Please can you write a Jira for
> this under the sakai project component portal. It may of been introduced
> during the introduction of parent sites functionality. Not sure so let the
> project lead decide.
>
>  Alan
>
> Alan Berg
> QA Director - The Sakai Foundation
>
> Senior Developer / Quality Assurance
> Group Education and Research Services
> Central Computer Services
> University of Amsterdam
>    ------------------------------
> *From:* sakai-dev-bounces at collab.sakaiproject.org [
> sakai-dev-bounces at collab.sakaiproject.org] on behalf of Rajesh Kumar K P [
> rajeshkumarkp at aims.amrita.edu]
> *Sent:* 07 March 2011 07:10
> *To:* sakai-dev at collab.sakaiproject.org
> *Subject:* [Building Sakai] Doubt in login module
>
>   Dear All
>
> While logging in sakai(we are using sakai 2.6.1), the following query is
> executed twice,
>
>  select
> SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHORT_DESC,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_SITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAKAI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CREATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON,SAKAI_SITE.CUSTOM_PAGE_ORDERED
> from SAKAI_SITE,SAKAI_SITE_USER where SAKAI_SITE.SITE_ID =
> SAKAI_SITE_USER.SITE_ID and SAKAI_SITE_USER.USER_ID = 'admin' and
> SAKAI_SITE.IS_USER = '0' and SAKAI_SITE.IS_SPECIAL = '0' and
> SAKAI_SITE_USER.PERMISSION <= SAKAI_SITE.PUBLISHED order by SAKAI_SITE.TITLE
> ASC
>
>  Upon looking at the source code, it is found that the following functions
> are generating this query.
>
>  SiteHelper.java
>
>
>
> 1)doSite() --> includeSiteNav() --> includeTabs() --> getSitesView() -->
> Constructor in
>
> DefaultSiteViewImpl --> Constructor in AbstractSiteViewImpl -->
> getSitesAtNode()
>
>
>
> 2)doSite() --> includeSubSites() --> getSitesView() --> Constructor in
> SubSiteViewImpl -->
>
> Constructor in AbstractSiteViewImpl --> getSitesAtNode()
>
>
>
> Ultimately both these functions are calling the same function
> getSitesAtNode() in
>
> AbstractSiteViewImpl.java.
>
>
>
> Do we need to call both these methods in doSite()
>
>
>
> With Regards
>
>
>
> Rajesh
>
>
>
>
>
>       -----------------------------------------
> Amrita Institute Of Medical Sciences & Research Centre, Cochin, India
>
> Amrita Institute of Medical Sciences & Research Center. Amrita Lane; AIMS
> Ponekkara P.O; Kochi-682041. Kerala, South India.
> Tel: +91 484 2801234,2851234,4001234 Fax: +91 484 2802020 Email:
> admin at aims.amrita.edu Web: www.aimshospital.org
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>



-- 
Aaron Zeckoski - Software Engineer - http://tinyurl.com/azprofile
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110307/b1743b7a/attachment.html