Tag: squirrel sql

Squirrel SQL: Maximum column length of 100,000 exceeded

Phillip2 Comments

While trying to import a large dataset into my database using Squirrel I encountered the following error.

[Dataimport Executor Thread] ERROR net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor - Error while reading file
java.io.IOException: Maximum column length of 100,000 exceeded in column 3 in record 519,064. Set the SafetySwitch property to false if you're expecting column lengths greater than 100,000 characters to avoid this error.
 at com.csvreader.CsvReader.readRecord(CsvReader.java:841)
 at net.sourceforge.squirrel_sql.plugins.dataimport.importer.csv.CSVFileImporter.next(CSVFileImporter.java:123)
 at net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor._execute(ImportDataIntoTableExecutor.java:160)
 at net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor.access$000(ImportDataIntoTableExecutor.java:51)
 at net.sourceforge.squirrel_sql.plugins.dataimport.ImportDataIntoTableExecutor$1.run(ImportDataIntoTableExecutor.java:108)

Continue reading “Squirrel SQL: Maximum column length of 100,000 exceeded” →