在Jackson中尝试反序列化时获取“无法构造实例”

Question

我正在尝试从gson迁移到jackson。这很令人沮丧，jackson在序列化方面做得更好（gson会因为各种原因阻塞jackson序列化的类而没有抱怨）然而，gson更擅长反序列化。

无法构造组织的实例。javautil。果心csv。SqlCsvExporterJson（尽管至少存在一个创建者）：没有从字符串值反序列化的字符串参数构造函数/工厂方法。

我已经将其简化为一个简单的bean，我将其序列化，然后尝试反序列化。

该bean是使用http://www.jsonschema2pojo.org/

我的测试类：

package org.wank.core.csv;

import static org.junit.Assert.assertEquals;

import java.util.LinkedHashMap;

import org.junit.Test;

import com.fasterxml.jackson.annotation.JsonInclude.Include;
import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.DeserializationFeature;
import com.fasterxml.jackson.databind.ObjectMapper;

public class SqlCsvExporterJsonParserTest {


    @Test
    public void testJacksonTwo() throws JsonProcessingException {
        SqlCsvExporterJson exporter = new SqlCsvExporterJson();
        exporter.setExportDateFormatString("yyyy-MM-dd");
        exporter.setDateTimeFormatString("yyyy-MM-dd'T'HH:mm:ssXXX");
        exporter.setSql("select * from a order by nbr");

        ObjectMapper mapper = new ObjectMapper();
        mapper.setSerializationInclusion(Include.NON_NULL);
        mapper.enable(DeserializationFeature.ACCEPT_EMPTY_STRING_AS_NULL_OBJECT);

        String json =  mapper.writerWithDefaultPrettyPrinter().writeValueAsString(exporter);
        System.out.println(json);

        SqlCsvExporterJson parser = mapper.convertValue(json, SqlCsvExporterJson.class);
        assertEquals("yyyy-MM-dd",parser.getExportDateFormatString());

    }
}

bean类：

package org.wank.core.csv;

import java.util.HashMap;
import java.util.List;
import java.util.Map;
import com.fasterxml.jackson.annotation.JsonAnyGetter;
import com.fasterxml.jackson.annotation.JsonAnySetter;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.fasterxml.jackson.annotation.JsonInclude;
import com.fasterxml.jackson.annotation.JsonProperty;
import com.fasterxml.jackson.annotation.JsonPropertyOrder;
import org.apache.commons.lang.builder.ToStringBuilder;

@JsonInclude(JsonInclude.Include.NON_NULL)
@JsonPropertyOrder({
    "exportDateFormatString",
    "dateTimeFormatString",
    "sql",
    "databaseMetaData",
    "columnMeta"
})
public class SqlCsvExporterJson {

    @JsonProperty("exportDateFormatString")
    private String exportDateFormatString;
    @JsonProperty("dateTimeFormatString")
    private String dateTimeFormatString;
    @JsonProperty("sql")
    private String sql;
    @JsonProperty("databaseMetaData")
    private DatabaseMetaData databaseMetaData;
    @JsonProperty("columnMeta")
    private List<ColumnMetum> columnMeta = null;
    @JsonIgnore
    private Map<String, Object> additionalProperties = new HashMap<String, Object>();

    /**
     * No args constructor for use in serialization
     * 
     */
    public SqlCsvExporterJson() {
    }

    /**
     * 
     * @param exportDateFormatString
     * @param databaseMetaData
     * @param columnMeta
     * @param sql
     * @param dateTimeFormatString
     */
    public SqlCsvExporterJson(String exportDateFormatString, String dateTimeFormatString, String sql, DatabaseMetaData databaseMetaData, List<ColumnMetum> columnMeta) {
        super();
        this.exportDateFormatString = exportDateFormatString;
        this.dateTimeFormatString = dateTimeFormatString;
        this.sql = sql;
        this.databaseMetaData = databaseMetaData;
        this.columnMeta = columnMeta;
    }

    @JsonProperty("exportDateFormatString")
    public String getExportDateFormatString() {
        return exportDateFormatString;
    }

    @JsonProperty("exportDateFormatString")
    public void setExportDateFormatString(String exportDateFormatString) {
        this.exportDateFormatString = exportDateFormatString;
    }

    @JsonProperty("dateTimeFormatString")
    public String getDateTimeFormatString() {
        return dateTimeFormatString;
    }

    @JsonProperty("dateTimeFormatString")
    public void setDateTimeFormatString(String dateTimeFormatString) {
        this.dateTimeFormatString = dateTimeFormatString;
    }

    @JsonProperty("sql")
    public String getSql() {
        return sql;
    }

    @JsonProperty("sql")
    public void setSql(String sql) {
        this.sql = sql;
    }

    @JsonProperty("databaseMetaData")
    public DatabaseMetaData getDatabaseMetaData() {
        return databaseMetaData;
    }

    @JsonProperty("databaseMetaData")
    public void setDatabaseMetaData(DatabaseMetaData databaseMetaData) {
        this.databaseMetaData = databaseMetaData;
    }

    @JsonProperty("columnMeta")
    public List<ColumnMetum> getColumnMeta() {
        return columnMeta;
    }

    @JsonProperty("columnMeta")
    public void setColumnMeta(List<ColumnMetum> columnMeta) {
        this.columnMeta = columnMeta;
    }

    @JsonAnyGetter
    public Map<String, Object> getAdditionalProperties() {
        return this.additionalProperties;
    }

    @JsonAnySetter
    public void setAdditionalProperty(String name, Object value) {
        this.additionalProperties.put(name, value);
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this).append("exportDateFormatString", exportDateFormatString).append("dateTimeFormatString", dateTimeFormatString).append("sql", sql).append("databaseMetaData", databaseMetaData).append("columnMeta", columnMeta).append("additionalProperties", additionalProperties).toString();
    }

}

这个gson测试：

package org.wank.core.csv;

import static org.junit.Assert.assertEquals;

import org.javautil.core.gson.SqlCsvExporterJsonGson;
import org.junit.Test;

import com.fasterxml.jackson.core.JsonProcessingException;
import com.google.gson.Gson;
import com.google.gson.GsonBuilder;

public class SqlCsvExporterJsonParserGsonTest {

    @Test
    public void testJacksonTwo() throws JsonProcessingException {
        SqlCsvExporterJsonGson exporter = new SqlCsvExporterJsonGson();
        exporter.setExportDateFormatString("yyyy-MM-dd");
        exporter.setDateTimeFormatString("yyyy-MM-dd'T'HH:mm:ssXXX");
        exporter.setSql("select * from a order by nbr");

        Gson mapper = new GsonBuilder().setPrettyPrinting().create();
        String json = mapper.toJson(exporter);
        SqlCsvExporterJsonGson bean = mapper.fromJson(json, SqlCsvExporterJsonGson.class);
        System.out.println(json);
        assertEquals("yyyy-MM-dd",bean.getExportDateFormatString());

    }
}

在这个bean上：

package org.wank.core.gson;

import java.util.List;
import com.google.gson.annotations.Expose;
import com.google.gson.annotations.SerializedName;
import org.apache.commons.lang.builder.ToStringBuilder;

public class SqlCsvExporterJsonGson {

    @SerializedName("exportDateFormatString")
    @Expose
    private String exportDateFormatString;
    @SerializedName("dateTimeFormatString")
    @Expose
    private String dateTimeFormatString;
    @SerializedName("sql")
    @Expose
    private String sql;
    @SerializedName("databaseMetaData")
    @Expose
    private DatabaseMetaData databaseMetaData;
    @SerializedName("columnMeta")
    @Expose
    private List<ColumnMetum> columnMeta = null;

    /**
     * No args constructor for use in serialization
     * 
     */
    public SqlCsvExporterJsonGson() {
    }

    /**
     * 
     * @param exportDateFormatString
     * @param databaseMetaData
     * @param columnMeta
     * @param sql
     * @param dateTimeFormatString
     */
    public SqlCsvExporterJsonGson(String exportDateFormatString, String dateTimeFormatString, String sql, DatabaseMetaData databaseMetaData, List<ColumnMetum> columnMeta) {
        super();
        this.exportDateFormatString = exportDateFormatString;
        this.dateTimeFormatString = dateTimeFormatString;
        this.sql = sql;
        this.databaseMetaData = databaseMetaData;
        this.columnMeta = columnMeta;
    }

    public String getExportDateFormatString() {
        return exportDateFormatString;
    }

    public void setExportDateFormatString(String exportDateFormatString) {
        this.exportDateFormatString = exportDateFormatString;
    }

    public String getDateTimeFormatString() {
        return dateTimeFormatString;
    }

    public void setDateTimeFormatString(String dateTimeFormatString) {
        this.dateTimeFormatString = dateTimeFormatString;
    }

    public String getSql() {
        return sql;
    }

    public void setSql(String sql) {
        this.sql = sql;
    }

    public DatabaseMetaData getDatabaseMetaData() {
        return databaseMetaData;
    }

    public void setDatabaseMetaData(DatabaseMetaData databaseMetaData) {
        this.databaseMetaData = databaseMetaData;
    }

    public List<ColumnMetum> getColumnMeta() {
        return columnMeta;
    }

    public void setColumnMeta(List<ColumnMetum> columnMeta) {
        this.columnMeta = columnMeta;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this).append("exportDateFormatString", exportDateFormatString).append("dateTimeFormatString", dateTimeFormatString).append("sql", sql).append("databaseMetaData", databaseMetaData).append("columnMeta", columnMeta).toString();
    }

}

工作正常。

Answer 1

使用readValue方法而不是convertValue方法

SqlCsvExporterJson parser = mapper.readValue(json, SqlCsvExporterJson.class);

有关更多信息，请阅读以下内容：

1. 杰克逊简介