Menu

#84 throw exceptions for invalid column values

open
nobody
None
5
2014-07-20
2014-07-20
No

Add throwing an exception when a column value in a CSV file is invalid or damaged.

For example, if I read a CSV file containing Integer and Date values, then an exception should be thrown when the invalid column value is encountered in the second line:

props.put("columnTypes", "Integer,Date");

ID,START_DATE
1,2012-06-06
2,????-??-??
?,2013-01-01
4,2014-07-04

However, it should be possible to continue fetching from the ResultSet after catching the exception.

Requested by Florian Hartl by e-mail.

Discussion