Project

General

Profile

Actions

bug #10079

open

Fix timezone problems after upgrading jadira.usertype, hibernate and/or mysql drivers

Added by Andreas Müller almost 2 years ago. Updated almost 2 years ago.

Status:
In Progress
Priority:
New
Assignee:
Category:
cdm-dataportal
Target version:
Start date:
Due date:
% Done:

60%

Estimated time:
Severity:
critical
Found in Version:
Tags:

Description

With #9359 and #10067 we upgraded hibernate and joda-time/jadira-usertype versions. Maybe also upgrading mysql-connector or some json library was relevant.

However, the final result was, that the registration date is now not shown correctly anymore on the dataportals.

The reason for this seems to be that in the former version registrationDate was handled like this in the outgoing webservices:

registrationDate    "2022-06-21T10:35:25.000Z"

from https://api.phycobank.org/phycobank/registrationDTO.json?identifier=http://phycobank.org/103170

while in the current version it includes timezone

registrationDate    "2022-01-26T11:01:10.000+01:00"

from https://test.e-taxonomy.eu/cdmserver/phycobank/registrationDTO.json?identifier=http://phycobank.org/100495

So in the new Version the registrationDate brings its timezone (though it is not yet 100% clear if this timezone is taken from the database or from the operating system the CDM Server runs on. This needs further investigation, however, mostoften these 2 will use the same timezones if correctly configured and used in the same institution).

So the dataportal needs to correctly interpretate the new formatting. Currently it seems to leave out the timezone information and therefore leads to incorrect results.


Related issues

Related to EDIT - task #9359: Update cdmlib, taxeditor, cdmserver etc. dependenciesClosedAndreas Müller

Actions
Related to EDIT - task #10067: Update to hibernate 5.4 (or higher) and hibernate search 5.11 and lucene 5.5ClosedAndreas Müller05/23/202206/01/2022

Actions
Related to EDIT - bug #8343: potential timezone problem in application stackClosedAndreas Müller

Actions
Related to EDIT - task #10055: Updates, upgrades and cleanup 2023NewAndreas Müller

Actions
Actions

Also available in: Atom PDF