MySQL date field coming back as Unix time

[danray0424]

This is probably an easy one, but I can't find any docs about it.

I'm getting dates out of my MySQL database as Unix timestamps. Formatting controls on my field definition don't seem to help.

    @Column(name = "recovery_date", columnDefinition = "DATETIME")
    @Temporal(TemporalType.TIMESTAMP)
    @DateTimeFormat(style = "M")
    private Date recoveryDate;

Yet that field comes out (in the output of the REST/JSON view that Roo built for me) as "1321385595"


EDIT: Sigh. 47 views, 0 replies. Guess it's NOT an easy one?

[danray0424]

For future reference (and because nobody seems to answer any questions around here), the answer is to specify the date format in the JSON serializer configuration. Push-in the "toJson" method from Roo's json controller, and change it to say:

public String toJson() {
    return new JSONSerializer().exclude("*.class")
    		.transform(new DateTransformer("yyyy-MM-dd"), Date.class)
       		.serialize(this);
}

That .transform call specifies the format for all Date objects in the thing being serialized.