[CAUSEWAY-3105] Support for persisting Temporal Types with Zone/Offset Information

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0-M8
• Component/s: Persistence JDO, Persistence JPA
• Assignee: Andi Huber
• Reporter: Andi Huber
• Created: 02/Aug/22 08:08
• Updated: 02/Aug/22 17:26
• Resolved: 02/Aug/22 12:43

Description

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.