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

    • Technical task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.0.24, 1.2.8, 1.3.10
    • 1.0.26, 1.2.10, 1.3.14, 1.4
    • rdbmk
    • 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.patch
          7 kB
          Tomek Rękawek
        2. OAK-3645-jr.patch
          9 kB
          Julian Reschke

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: