[This topic is migrated from our old forums. The original author name has been removed]
I receive the following when trying to import a CSV file on 30,000 rows:
09:13:09 [ Row: 29897, File lines: 29897-29897 ] Error setting value for column 1: java.lang.NumberFormatException: For input string: "108989557259462345374"
09:13:09 [ Row: 29898, File lines: 29898-29898 ] Error setting value for column 1: java.lang.NumberFormatException: For input string: "105003861085970538916"
1 Comment
Hans Bergsten
said
about 11 years ago
[This reply is migrated from our old forums.]
Re: Import Errors
Hi Kenneth,
DbVisualizer is trying to convert the value to a long internally and it is too large for a long.
What is the data type for the column in the database? Which database do you use?
Best Regards,
Hans
anonymous