Maximum length of line in CSV is only 5480, otherwise csvjdbc doesn't work

[Robin-Christopher Meyer]

Hello,

I get an exception when the no of caracters in one line in the CSV file extends 5480:
java.sql.SQLException: Expected separator at line and position: 10 5480

What can I do.

Greetings
Robin

[Simon Chenery]

There is no limit on line lengths in CsvJdbc.

This error message occurs because a line in the CSV file cannot be parsed correctly, probably because the quoting of fields is wrong, as in the entry for ID=2 below:

ID,Description,Price
1,"Chair",65
2,"Wrong,77
3,"Table",70

The error message from CsvJdbc tells you the line number and character position where the problem occurred in the CSV file.