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

Voters

Watch issue

Watchers

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: New Feature
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 2.0.0-M8
Component/s: Persistence JDO, Persistence JPA
Labels:
None

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.

Attachments

Activity

Comment

This comment will be Viewable by All Users Viewable by All Users

Cancel

People

Assignee:: Andi Huber

Reporter:: Andi Huber

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 02/Aug/22 08:08

Updated:: 02/Aug/22 17:26

Resolved:: 02/Aug/22 12:43

Agile

View on Board

Support for persisting Temporal Types with Zone/Offset Information