You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@isis.apache.org by "Andi Huber (Jira)" <ji...@apache.org> on 2022/08/02 08:09:00 UTC

[jira] [Created] (ISIS-3105) Support for persisting Temporal Types with Zone/Offset Information

Andi Huber created ISIS-3105:
--------------------------------

             Summary: Support for persisting Temporal Types with Zone/Offset Information
                 Key: ISIS-3105
                 URL: https://issues.apache.org/jira/browse/ISIS-3105
             Project: Isis
          Issue Type: New Feature
          Components: Isis Persistence JDO, Isis Persistence JPA
            Reporter: Andi Huber
            Assignee: Andi Huber
             Fix For: 2.0.0-M8


What I've found regarding zone/offset information support:
* MariaDB ... no
* PostgreSQL ... no
* MySQL ... no
* Microsoft SQL Server ... yes
* Oracle DB ... yes
* H2 ... yes

The sensible thing to do is to provide a custom type mapping for JDO and JPA in support of zone/offset temporals, by adding a secondary column that holds the zone/offset information. Similar to what we do with Blob/Clob.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)