I’ve tried to load data from a table that has 50 columns.
It’s imposible to create the metadata with the wizard. Some kind of error has ocurred and hasn’t been reported.
After editing the metadata file without the wizard, i’ve tried to launch the graph and reports mistaken errors,
i.e. GRAVE: Node DB_INPUT_TABLE0 finished with fatal error: java.lang.RuntimeException : java.sql.SQLException:Incompatible Clover & JDBC field types - field CLI_DefRefractiu Clover type: string
java.lang.InterruptedException
when CLI_DefRefractiu is string in fact.
Hi !
Clover is not limited in number of columns, but if your data record gets wide it can exceed the default limit of 8KB of data.
I can’t really tell whether this is the problem - looks like not - but you may try to increase the default records size in /org/jetel/data/defaultProperties file - Record.MAX_RECORD_SIZE = 8192
You may try to set it to 16384 or so.
In case this does not help, try to open it as bug and attach the Clover metadata plus the DDL for the DB table please.
We will check the problem with the wizard too.
David.