[Building Sakai] course site session dropdown

Wed Sep 15 06:22:34 PDT 2010

2010-09-10_15:42:52-0400 Ron Peterson <rpeterso at mtholyoke.edu>:
> 2010-09-10_12:13:53-0400 Zhen Qian <zqian at umich.edu>:
> > 
> > Do you have your own implementation of CourseManagementService?
> 
> Nope.  I double checked that my codebase matches what you show below
> exactly, and it does.
> 
> This is the data in my table.  The only term that shows up when I create
> a new site is Spring 2010, even though the is_current field for that
> term is 0, and the date range does not include today's date.

This is still broken for me.

A clue, perhaps.  A later read of this same table shows that the value
of the IS_CURRENT field has reverted to the values present before my SQL
update - w/ a one for my Summer_2010 row, and zeroes elsewhere.

I have a test instance where I effected the same change, and it held,
and now my dropdown is properly updated.

I don't know Sakai internals well enough to say anything very
intelligent here, but it smells like the old values are being
cached/used, and even being rewritten to the database somehow.

-Ron-

> "ACADEMIC_SESSION_ID","VERSION","LAST_MODIFIED_BY","LAST_MODIFIED_DATE","CREATED_BY","CREATED_DATE","ENTERPRISE_ID","TITLE","DESCRIPTION","START_DATE","END_DATE","IS_CURRENT"
> "20061000","1","","","ELLA25","31-JUL-08","2006/FA","Fall_2006","Fall_2006","07-SEP-06","13-DEC-06","0"
> "20071001","1","","","ELLA25","31-JUL-08","2007/JA","JTerm_2007","JTerm_2007","03-JAN-07","23-JAN-07","0"
> "20071002","1","","","ELLA25","31-JUL-08","2007/SP","Spring_2007","Spring_2007","29-JAN-07","18-MAY-07","0"
> "20071003","1","","","ELLA25","31-JUL-08","2007/SU","Summer_2007","Summer_2007","01-JUN-07","31-AUG-07","0"
> "20071004","1","","","ELLA25","31-JUL-08","2007/FA","Fall_2007","Fall_2007","06-SEP-07","19-DEC-07","0"
> "20081005","1","","","ELLA25","31-JUL-08","2008/JA","JTerm_2008","JTerm_2008","03-JAN-08","23-JAN-08","0"
> "20081006","1","","","ELLA25","31-JUL-08","2008/SP","Spring_2008","Spring_2008","30-JAN-08","13-MAY-08","0"
> "20081007","1","","","ELLA25","31-JUL-08","2008/SU","Summer_2008","Summer_2008","01-JUN-08","31-AUG-08","0"
> "20081008","1","","","ELLA25","31-JUL-08","2008/FA","Fall_2008","Fall_2008","04-SEP-08","19-DEC-08","0"
> "20091009","1","","","ELLA25","31-JUL-08","2009/JA","JTerm_2009","JTerm_2009","05-JAN-09","23-JAN-09","0"
> "20091010","1","","","ELLA25","31-JUL-08","2009/SP","Spring_2009","Spring_2009","29-JAN-09","13-MAY-09","0"
> "20091011","1","","","ELLA25","31-JUL-08","2009/SU","Summer_2009","Summer_2009","01-JUN-09","31-AUG-09","0"
> "20091012","1","","","ELLA25","31-JUL-08","2009/FA","Fall_2009","Fall_2009","10-SEP-09","22-DEC-09","0"
> "20101013","1","","","ELLA25","31-JUL-08","2010/JA","JTerm_2010","JTerm_2010","04-JAN-10","22-JAN-10","0"
> "20101014","1","","","ELLA25","31-JUL-08","2010/SP","Spring_2010","Spring_2010","27-JAN-10","12-MAY-10","0"
> "20101015","1","","","ELLA25","31-JUL-08","2010/SU","Summer_2010","Summer_2010","01-JUN-10","31-AUG-10","0"
> "20101016","1","","","ELLA25","31-JUL-08","2010/FA","Fall_2010","Fall_2010","09-SEP-10","22-DEC-10","1"
> "20111017","1","","","ELLA25","31-JUL-08","2011/JA","JTerm_2011","JTerm_2011","03-JAN-11","20-JAN-11","1"
> "20111018","1","","","ELLA25","31-JUL-08","2011/SP","Spring_2011","Spring_2011","26-JAN-11","12-MAY-11","1"
> "20111019","1","","","ELLA25","31-JUL-08","2011/SU","Summer_2011","Summer_2011","01-JUN-11","31-AUG-11","1"
> "20111020","1","","","ELLA25","31-JUL-08","2011/FA","Fall_2011","Fall_2011","08-SEP-11","21-DEC-11","1"
> "20121021","1","","","ELLA25","31-JUL-08","2012/JA","JTerm_2012","JTerm_2012","05-JAN-12","24-JAN-12","1"
> "20121022","1","","","ELLA25","31-JUL-08","2012/SP","Spring_2012","Spring_2012","31-JAN-12","16-MAY-12","1"
> 
> Thanks for any insight.
> 
> -Ron-
> 
> > Otherwise, if you are running 2.6.2 and using the default hibernate-impl of
> > CourseManagementService [1], it should pick up the is_current table
> > setting:
> > 
> > >From [1]:
> > 	public List<AcademicSession> getCurrentAcademicSessions() {
> > 		return
> > getHibernateTemplate().findByNamedQuery("findCurrentAcademicSessions");
> > 	}
> > 
> > >From [2]:
> >     <query name="findCurrentAcademicSessions">
> >         <![CDATA[
> >         from AcademicSessionCmImpl as term where
> >         	term.current=true
> >         	order by term.startDate
> >         ]]>
> >     </query>
> > 
> > Thanks,
> > - Zhen
> > 
> > [1]
> > https://source.sakaiproject.org/svn/course-management/tags/sakai-2.6.2/cm-impl/hibernate-impl/impl/src/java/org/sakaiproject/coursemanagement/impl/CourseManagementServiceHibernateImpl.java
> > 
> > [2]
> > https://source.sakaiproject.org/svn/course-management/tags/sakai-2.6.2/cm-impl/hibernate-impl/hibernate/src/hibernate/org/sakaiproject/coursemanagement/impl/AcademicSessionCmImpl.hbm.xml
> > 
> > On Fri, 10 Sep 2010 15:51:53 +0000, "Maurer, Christopher Wayne"
> > <chmaurer at iupui.edu> wrote:
> > > Make sure that the session's start and end dates include the current date
> > > as I don't think they'll show otherwise.
> > > 
> > > Chris
> > > 
> > > On Sep 10, 2010, at 11:49 AM, Ron Peterson wrote:
> > > 
> > >> Hi,
> > >> 
> > >> Running Sakai 2.6.2.  I have a problem with the dropdown to select an
> > >> academic term when creating a new course site - it only shows a single
> > >> term, and not the term I want.
> > >> 
> > >> There appears to be a relevant discussion here:
> > >> 
> > >> http://jira.sakaiproject.org/browse/SAK-15531
> > >> 
> > >> ...which concludes with the advice to check out the following URL:
> > >> 
> > >> http://confluence.sakaiproject.org/confluence/x/WIAFAw
> > >> 
> > >> However, that URL is unavailable.
> > >> 
> > >> I've modified the IS_CURRENT column in my CM_ACADEMIC_SESSION_T table
> > >> to be true for the terms I'd like to see, but no luck.
> > >> 
> > >> ??
> > >> 
> > >> -Ron-
> > >> _______________________________________________
> > >> 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"
> > > 
> > > _______________________________________________
> > > 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"
> _______________________________________________
> 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"