No way to insert data in the field
I have done the following test:
StringHandling.LEN(row1.ARCTLIB01)<29?row1.ARCTLIB01:row1.ARCTLIB01.substring(0,20)
I have still:
Exception in component tFirebirdOutput_1
java.sql.DataTruncation: Data truncation
at org.firebirdsql.jdbc.field.FBWorkaroundStringField.setString(FBWorkaroundStringField.java:97)
at org.firebirdsql.jdbc.AbstractPreparedStatement.setString(AbstractPreparedStatement.java:384)
at pmi.insertarticles_0_1.InsertArticles.tFirebirdInput_1Process(InsertArticles.java:8964)
at pmi.insertarticles_0_1.InsertArticles.runJobInTOS(InsertArticles.java:11658)
at pmi.insertarticles_0_1.InsertArticles.main(InsertArticles.java:11476)
I have tried to increase the size of the target field. Same error!
I don't know what to do !!