Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-1266 DocumentStore implementation for relational databases
  3. OAK-3645

RDBDocumentStore: server time detection for DB2 fails due to timezone/dst differences

    XMLWordPrintableJSON

    Details

    • Type: Technical task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.24, 1.2.8, 1.3.10
    • Fix Version/s: 1.0.26, 1.2.10, 1.3.14, 1.4
    • Component/s: rdbmk
    • Labels:
      None

      Description

      We use CURRENT_TIMESTAMP(4) to ask the DB for it's system time.

      Apparently, at least with DB2, this might return a value that is off by a multiple of one hour (3600 * 1000ms) depending on whether the OAK instance and the DB run in different timezones.

      Known to work: both on the same machine.

      Known to fail: OAK in CET, DB2 in UTC, in which case we're getting a timestamp one hour in the past.

      At this time it's not clear whether the same problem occurs for other databases.

        Attachments

        1. OAK-3645-jr.patch
          9 kB
          Julian Reschke
        2. OAK-3645.patch
          7 kB
          Tomek Rękawek

          Activity

            People

            • Assignee:
              reschke Julian Reschke
              Reporter:
              reschke Julian Reschke
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: