CODEWITHSUNDEEP
javajsonserializationjacksontimestamp
Kiril Mytsykov
Kiril Mytsykov

Reputation: 739

Jackson deserialize JSON with timestamp field

I have such string:

{
   "debug":"false", 
   "switchTime":"2017-04-12 17:04:42.896026"
}

I'm trying to get object in such approach:

new ObjectMapper().readValue(string, MyObject.class);

And MyObject class:

class MyObject {
    private Boolean debug;
    private Timestamp switchTime;
    //...getters, setters, constructors
}

I have such exception:

com.fasterxml.jackson.databind.exc.InvalidFormatException: 
Can not deserialize value of type java.sql.Timestamp from String
"2017-04-12 17:04:42.896026": not a valid representation (error:
Failed to parse Date value '2017-04-12 17:04:42.896026': 
Can not parse date "2017-04-12 17:04:42.896026Z": while it seems 
to fit format 'yyyy-MM-dd'T'HH:mm:ss.SSS'Z'', 
parsing fails (leniency? null))  at [Source:   
{"debug":"false", "switchTime":"2017-04-12 17:04:42.896026"};

I don't understand why...If i use in debug mode Timestamp.valueOf() with "2017-04-12 17:04:42.896026" - i have success

Upvotes: 20

Views: 32586

Answers (3)

firstpostcommenter
firstpostcommenter

Reputation: 2931

I faced the similar problem when I was using lombok in the POJO class which has @Builder and @Value annotations

I have also added the annotation AllArgsConstructor and then it is working fine with my custom deserializer code

Upvotes: 0

Justin Jose
Justin Jose

Reputation: 2171

I think you need to set the expected date/time format using @JsonFormat annotation as shown below.

class MyObject {
  private Boolean debug;
  @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss.SSS")
  private Timestamp switchTime;
  //...getters, setters, constructors
}

You can also set timezone as @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss.SSS",timezone="PST")

Upvotes: 37

adi
adi

Reputation: 304

The value that you see in debug mode is "toString()" version of actual value of timestamp, so don't rely on what you inspect in debug mode. You can use @JsonFormat annotation that helps you to convert your timestamp with specified format. You need to take care of timezones also while converting!

Upvotes: -1

Related Questions