[Solved] jdbc-hsqldb exception for text table

by


As the OP found out, following these simple steps help find the problem in the CSV file:

  1. Look at the error message: bad TEXT table source file - line number: 1196 The line number is the line number of the CSV file. Using a text editor, go to that line. Lines are numbered from 1.
  2. ava.lang.NumberFormatException: For input string: "Body Connection-Banner-728x90-HEAMBA-S" note NumberFormatException indicates a number was expected, instead the reported string was found.
  3. Luckily, there is only one number (INT) column in the table, so it’s easy to see there is an extra comma in the CVS, which terminates the last VARCHAR string and causes the problem.
  4. The TEXT table definition includes all_quoted=true, which means if you use double quotes around the string that contains the comma, the whole string is treated as a field and the problem disappears.

solved jdbc-hsqldb exception for text table