Databases
StackOverflow2013
Postsdbo
POJersey + Jackson JSON date format serialization - how to change the format or use custom JacksonJsonProvider
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJersey + Jackson JSON date format serialization - how to change the format or use custom JacksonJsonProvider
    primarykey
    data
    text
    <p>I am using Jersey + Jackson to provide REST JSON services layer for my application. The problem I have is that the default Date serialization format looks like that:</p> <pre><code>"CreationDate":1292236718456 </code></pre> <p>At first I thought it is a UNIX timestamp... but it is too long for that. My client-side JS library has problems deserializing this format (it supports a bunch of different date formats but not this one I suppose). I want to change the format so that it can be consumable by my library (to ISO for example). How do I do that... I found a piece of code that could help but... where do I put it as I don't control the Jackson serializer instantiation (Jersey does)?</p> <pre><code>objectMapper.configure( SerializationConfig.Feature.WRITE_DATES_AS_TIMESTAMPS, false); </code></pre> <p>I also found this code for custom <code>JacksonJsonProvider</code> - the question is .. how do I make all my POJO classes use it?</p> <pre><code>@Provider public class MessageBodyWriterJSON extends JacksonJsonProvider { private static final String DF = "yyyy-MM-dd’T'HH:mm:ss.SSSZ"; @Override public boolean isWriteable(Class arg0, Type arg1, Annotation[] arg2, MediaType arg3) { return super.isWriteable(arg0, arg1, arg2, arg3); } @Override public void writeTo(Object target, Class arg1, Type arg2, Annotation[] arg3, MediaType arg4, MultivaluedMap arg5, OutputStream outputStream) throws IOException, WebApplicationException { SimpleDateFormat sdf=new SimpleDateFormat(DF); ObjectMapper om = new ObjectMapper(); om.getDeserializationConfig().setDateFormat(sdf); om.getSerializationConfig().setDateFormat(sdf); try { om.writeValue(outputStream, target); } catch (JsonGenerationException e) { throw e; } catch (JsonMappingException e) { throw e; } catch (IOException e) { throw e; } } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJJD
    1. USadrin
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POJersey + Jackson JSON date format serialization - how to change the format or use custom JacksonJsonProvider
      1. USMark
      1. VTFavorite
    2. VO
      singulars
      1. POJersey + Jackson JSON date format serialization - how to change the format or use custom JacksonJsonProvider
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POJersey + Jackson JSON date format serialization - how to change the format or use custom JacksonJsonProvider
      1. USGili
      1. VTFavorite
    1. COI found this to be a change between Jersey 1.1.5 and Jersey 1.6 - with Jersey 1.1.5, the JSON serialization looks like this: {"date":"2011-04-01T16:41:18.707+00:00"} - maybe there is a issue tracker item which gives background information
      singulars
      1. POJersey + Jackson JSON date format serialization - how to change the format or use custom JacksonJsonProvider
      1. USmjn
    2. COyes it is the plumbing and set up that is the most time-consuming part. I still haven't figured it out. I suggest just outputting dates as a string, and then letting your client deal with converting strings into dates. It's about substituting code for configuration. I would rather write code that is 'within my control' rather than configuration mysteries that I know I can control but as of now seem out of my control. Configs are tricky without explicit examples that so happen to use the same pieces of the java toolkit that you are using. Portability is a worthy goal but really hard.
      singulars
      1. POJersey + Jackson JSON date format serialization - how to change the format or use custom JacksonJsonProvider
      1. USuser798719
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload