Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-44443

Lessons Remove AssignmentEntity Cache

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 21.0 [Tentative], 22.0 [Tentative]
    • Component/s: Lessons
    • Labels:
      None
    • 21 Status:
      Resolved
    • Test Plan:
      Hide
      1. Add some assignments
      2. Add content to a lessons page by linking to the some assignments
      3. Next you will need to enable hibernate logging
      4. The following query is sent to the database (see below)
      5. Notice on subsequent reloads of that page that the query is not present in the log like on the first access
      Hibernate: select assignment0_.ASSIGNMENT_ID as ASSIGNME1_2_0_, assignment0_.ALLOW_ATTACHMENTS as ALLOW_AT2_2_0_, assignment0_.ALLOW_PEER_ASSESSMENT as ALLOW_PE3_2_0_, assignment0_.AUTHOR as AUTHOR4_2_0_, assignment0_.CLOSE_DATE as CLOSE_DA5_2_0_, assignment0_.CONTENT_ID as CONTENT_6_2_0_, assignment0_.CONTENT_LAUNCH_NEW_WINDOW as CONTENT_7_2_0_, assignment0_.CONTENT_REVIEW as CONTENT_8_2_0_, assignment0_.CONTEXT as CONTEXT9_2_0_, assignment0_.CREATED_DATE as CREATED10_2_0_, assignment0_.MODIFIED_DATE as MODIFIE11_2_0_, assignment0_.DELETED as DELETED12_2_0_, assignment0_.DRAFT as DRAFT13_2_0_, assignment0_.DROP_DEAD_DATE as DROP_DE14_2_0_, assignment0_.DUE_DATE as DUE_DAT15_2_0_, assignment0_.HIDE_DUE_DATE as HIDE_DU16_2_0_, assignment0_.HONOR_PLEDGE as HONOR_P17_2_0_, assignment0_.INDIVIDUALLY_GRADED as INDIVID18_2_0_, assignment0_.INSTRUCTIONS as INSTRUC19_2_0_, assignment0_.IS_GROUP as IS_GROU20_2_0_, assignment0_.MAX_GRADE_POINT as MAX_GRA21_2_0_, assignment0_.MODIFIER as MODIFIE22_2_0_, assignment0_.OPEN_DATE as OPEN_DA23_2_0_, assignment0_.PEER_ASSESSMENT_ANON_EVAL as PEER_AS24_2_0_, assignment0_.PEER_ASSESSMENT_INSTRUCTIONS as PEER_AS25_2_0_, assignment0_.PEER_ASSESSMENT_NUMBER_REVIEW as PEER_AS26_2_0_, assignment0_.PEER_ASSESSMENT_PERIOD_DATE as PEER_AS27_2_0_, assignment0_.PEER_ASSESSMENT_STUDENT_REVIEW as PEER_AS28_2_0_, assignment0_.POSITION as POSITIO29_2_0_, assignment0_.RELEASE_GRADES as RELEASE30_2_0_, assignment0_.SCALE_FACTOR as SCALE_F31_2_0_, assignment0_.SECTION as SECTION32_2_0_, assignment0_.TITLE as TITLE33_2_0_, assignment0_.ACCESS_TYPE as ACCESS_34_2_0_, assignment0_.GRADE_TYPE as GRADE_T35_2_0_, assignment0_.SUBMISSION_TYPE as SUBMISS36_2_0_, assignment0_.VISIBLE_DATE as VISIBLE37_2_0_ from ASN_ASSIGNMENT assignment0_ where assignment0_.ASSIGNMENT_ID=?
      
      Show
      Add some assignments Add content to a lessons page by linking to the some assignments Next you will need to enable hibernate logging The following query is sent to the database (see below) Notice on subsequent reloads of that page that the query is not present in the log like on the first access Hibernate: select assignment0_.ASSIGNMENT_ID as ASSIGNME1_2_0_, assignment0_.ALLOW_ATTACHMENTS as ALLOW_AT2_2_0_, assignment0_.ALLOW_PEER_ASSESSMENT as ALLOW_PE3_2_0_, assignment0_.AUTHOR as AUTHOR4_2_0_, assignment0_.CLOSE_DATE as CLOSE_DA5_2_0_, assignment0_.CONTENT_ID as CONTENT_6_2_0_, assignment0_.CONTENT_LAUNCH_NEW_WINDOW as CONTENT_7_2_0_, assignment0_.CONTENT_REVIEW as CONTENT_8_2_0_, assignment0_.CONTEXT as CONTEXT9_2_0_, assignment0_.CREATED_DATE as CREATED10_2_0_, assignment0_.MODIFIED_DATE as MODIFIE11_2_0_, assignment0_.DELETED as DELETED12_2_0_, assignment0_.DRAFT as DRAFT13_2_0_, assignment0_.DROP_DEAD_DATE as DROP_DE14_2_0_, assignment0_.DUE_DATE as DUE_DAT15_2_0_, assignment0_.HIDE_DUE_DATE as HIDE_DU16_2_0_, assignment0_.HONOR_PLEDGE as HONOR_P17_2_0_, assignment0_.INDIVIDUALLY_GRADED as INDIVID18_2_0_, assignment0_.INSTRUCTIONS as INSTRUC19_2_0_, assignment0_.IS_GROUP as IS_GROU20_2_0_, assignment0_.MAX_GRADE_POINT as MAX_GRA21_2_0_, assignment0_.MODIFIER as MODIFIE22_2_0_, assignment0_.OPEN_DATE as OPEN_DA23_2_0_, assignment0_.PEER_ASSESSMENT_ANON_EVAL as PEER_AS24_2_0_, assignment0_.PEER_ASSESSMENT_INSTRUCTIONS as PEER_AS25_2_0_, assignment0_.PEER_ASSESSMENT_NUMBER_REVIEW as PEER_AS26_2_0_, assignment0_.PEER_ASSESSMENT_PERIOD_DATE as PEER_AS27_2_0_, assignment0_.PEER_ASSESSMENT_STUDENT_REVIEW as PEER_AS28_2_0_, assignment0_.POSITION as POSITIO29_2_0_, assignment0_.RELEASE_GRADES as RELEASE30_2_0_, assignment0_.SCALE_FACTOR as SCALE_F31_2_0_, assignment0_.SECTION as SECTION32_2_0_, assignment0_.TITLE as TITLE33_2_0_, assignment0_.ACCESS_TYPE as ACCESS_34_2_0_, assignment0_.GRADE_TYPE as GRADE_T35_2_0_, assignment0_.SUBMISSION_TYPE as SUBMISS36_2_0_, assignment0_.VISIBLE_DATE as VISIBLE37_2_0_ from ASN_ASSIGNMENT assignment0_ where assignment0_.ASSIGNMENT_ID=?

      Description

      As a result of the transition of Assignments to use Hibernate which now caches Assignment entities the AssignmentEntity Cache is no longer needed and is needlessly caching entities that are already cached.

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                Assignee:
                ern Earle R Nietzel
                Reporter:
                ern Earle R Nietzel
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Git Integration