Start a new topic

Import Errors

[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

[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