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

            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

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.