1

I need to serialize(generate Xml String from a Java DTO) and persist the DTO(Oracle DB) using an XSD that has a specific date_time pattern i.e .*(+|-)((0[0-9])|(1[0-3])):[0-5][0-9] which needs to support a date time with offset (2022-02-12T12:49:14+05:45). I am using maven-jaxb plugin to generate XML Java objects and some utility functions to convert the dateTime content. The generated class consists of XMLGregorianCalendar for the dateTime object and I am using OffsetDateTime to map and persist the content.

I can't update the pattern and I am only having issues when the XML date element contains a date like this 2022-02-12T12:49:14+00:00 (with zero offset) where both XMLGregorianCalendar/OffsetDateTime by default converts the offset to Z i.e 2022-02-12T12:49:14Z which is not valid for the pattern.

How can I keep the +00:00 offset while serializing and persisting the DTO? I am using Spring Data JPA to persist the DTO and another issue I am having while persisting the valid OffsetDateTime as the JPA persists the datetime value without offset. String type resolves this but I should not be using the String for datetime. What is the correct type for storing such values?

Here are my mapping functions:

  public static XMLGregorianCalendar toXMLGregorian(OffsetDateTime offsetDateTime) {
        return DATATYPE_FACTORY.newXMLGregorianCalendar(offsetDateTime.format(DateTimeFormatter.ISO_OFFSET_DATE_TIME));
    }

 public static OffsetDateTime toOffSetDateTime(XMLGregorianCalendar cal) {
        return cal.toGregorianCalendar().toZonedDateTime().toOffsetDateTime();
    }

I tried to override XMLGregorianCalendar.toXmlFormat() which works but the calendar object still contains the Z instead of +00:00 and serialization fails due to the pattern.

 @Override
    public String toXMLFormat() {
        String text = calendar.toXMLFormat();
        int pos = text.indexOf('Z');
        return pos < 0 ? text : text.substring(0, pos) + "+00:00";
    }
bFren_Sakar
  • 11
  • 4
  • Why not plain old string manipulation? `String#replace` such as `"2022-01-23T12:34:56Z".replace( "Z" , "+00:00" )`. – Basil Bourque Feb 12 '22 at 17:34
  • @BasilBourque that would solve issues if I was using String type to process the date-time value. I need an OffsetDateTime to persist and XmlGregorianCalendar to re-generate XML which should be abiding by xs:dateTime with the pattern. Manipulating them as String will give me the expected result but they will default to Z at the end. – bFren_Sakar Feb 13 '22 at 03:48
  • xs:dateTime accepts `Z`(or am I completely mistaken??) – Ole V.V. Feb 13 '22 at 06:26
  • Basic answer: you can’t. `OffsetDateTime` and `XMLGregorianCalendar` hold values, not formats. Also see [Convert JAXBElement to OffsetDateTime](https://stackoverflow.com/questions/57448018/convert-jaxbelementxmlgregoriancalendar-to-offsetdatetime) and [Format a XMLGregorianCalendar with Italian date format(dd/mm/yyyy) with no time \[duplicate\]](https://stackoverflow.com/questions/54294275/format-a-xmlgregoriancalendar-with-italian-date-formatdd-mm-yyyy-with-no-time). – Ole V.V. Feb 13 '22 at 06:32

0 Answers0