Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-22691

Fix timestamp persisted with another timezone than the server one

    XMLWordPrintable

    Details

      Description

      This is a persistence issue, dates can't always be persisted with time zone on certain backends (H2, Oracle and SQL Server). Nuxeo assumes dates are persisted with the Nuxeo application server timezone. But they are not.

      The root cause is a bad specification of JDBC setTimestamp that's open to interpretation and is actually implemented differently by different databases. See https://bugs.openjdk.java.net/browse/JDK-4986236

        Attachments

          Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. NXP-16198 Fix CmisSuiteSession.testContentStream assertion failure

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. NXP-20260 Fix DBS Mem test for NXQL query using date case

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 days, 1 hour, 30 minutes
                  2d 1h 30m