Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-34561 Auto-submit parent issue
  3. SAK-34582

Auto-submit job depends on database server timezone instead of Java timezone

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2
    • Fix Version/s: 10.3
    • Component/s: Tests & Quizzes (Samigo)
    • Labels:
      None

      Description

      The auto-submit job depends on current_timestamp() which is not converted into the Java date. Instead it is sent directly to the MySQL server to interpret.

      This code should be changed to pass the Java date over so there is not a mis-match between the JVM date and the MySQL date.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

              is related to

              Sub-task - The sub-task of the issue SAK-35141 Auto submit job doesn't handle extended due dates

              • Blocker - Blocks development and/or testing work, production could not run without this feature working correctly.
              • Verified

              Bug - A problem which impairs or prevents functionality of the product. SAK-36925 AutoSubmit regression with java.util.Date as the retract param

              • Major - Major loss of function or need for functionality in production in the near future.
              • Verified

                Activity

                  People

                  Assignee:
                  ern Earle R Nietzel
                  Reporter:
                  ottenhoff Sam Ottenhoff
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration