FlatFileParseException解析错误-Spring批处理

2022-02-28 00:00:00 spring java spring-boot spring-batch

我遵循此tutorial,但收到FlatFileParseException错误:

org.springframework.batch.item.file.FlatFileParseException:解析 资源=[类路径资源[Country.csv]]中的第1行出错, INPUT=[AA,阿鲁巴]

country.csv

AA,Aruba
BB,Baruba

这里是我的ItemReader方法

@Bean
    public ItemReader<Country> reader() {
        FlatFileItemReader<Country> reader = new FlatFileItemReader<Country>();
        reader.setResource(new ClassPathResource("country.csv"));
        reader.setLineMapper(new DefaultLineMapper<Country>() {{
            setLineTokenizer(new DelimitedLineTokenizer() {{
                setNames(new String[] { "countryCode", "countryName" });
            }});
            setFieldSetMapper(new BeanWrapperFieldSetMapper<Country>() {{
                setTargetType(Country.class);
            }});
        }});
        return reader;
    }

Country.java

@Entity
@Table(name="Country")
public class Country  {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id", nullable = false, updatable = false)
    Long id;

    @Column(name = "countryCode", nullable = false, updatable = false)
    String countryCode;

    @Column(name = "countryName", nullable = false, updatable = false)
    String countryName;

    public Country(String countryCode, String countryName) {
        this.countryCode = countryCode;
        this.countryName = countryName;

    }

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getCountryCode() {
        return countryCode;
    }

    public void setCountryCode(String countryCode) {
        this.countryCode = countryCode;
    }

    public String getCountryName() {
        return countryName;
    }

    public void setCountryName(String countryName) {
        this.countryName = countryName;
    }

    @Override
    public String toString() {
        return "countryCode: " + countryCode + ", countryName: " + countryName;
    }
}

解决方案

此处的问题是您的Country类中缺少默认的无参数构造函数。

您正在使用BeanWrapperFieldSetMapperFieldSet映射到对象。引用setTargetType(type)Javadoc:

每次调用mapFieldSet(FieldSet)时,将从其默认构造函数创建此类型的对象。

因此,您需要添加默认构造函数并为属性提供相应的getter/setter。

相关文章