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

Possible duplicate use of oracle sequence in sitestats.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 11.0
    • Fix Version/s: 11.0
    • Component/s: Sitestats
    • Labels:

      Description

      The new entity added in SAK-29546, SST_PRESENCE_TOTALS is using the same oracle sequence used by SST_PRESENCES. The sequence is declared in hbm file as SST_PRESENCE_ID in both entities (possible copy & paste issue).

      https://github.com/sakaiproject/sakai/blob/master/sitestats/sitestats-impl-hib/src/java/org/sakaiproject/sitestats/impl/hbm/SitePresenceImpl.hbm.xml#L11

      https://github.com/sakaiproject/sakai/blob/master/sitestats/sitestats-impl-hib/src/java/org/sakaiproject/sitestats/impl/hbm/SitePresenceTotalImpl.hbm.xml#L11

      In mysql the use of auto_increment let you use a different sequence on both entities, but in oracle this will use the same sequence that I think is not the intention here.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  jjmerono@um.es Juan José Meroño Sánchez
                  Reporter:
                  jjmerono@um.es Juan José Meroño Sánchez
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration