I would like to implement the following job:
Read data from a table "Articles" and insert them in the same table (I just modify one data)
Currently I the following error:
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:8963)
at pmi.insertarticles_0_1.InsertArticles.runJobInTOS(InsertArticles.java:11657)
at pmi.insertarticles_0_1.InsertArticles.main(InsertArticles.java:11475)
the table is in firebird database with the characterset set to "None"
I cannot modify it!!
Because I insert the data in the same table, I think is due to the length of special characters
I have identified on which field I have the issue
Of course if I insert a part of the data I don't have anymore the problem but it was only a way to identify the field.
I can have the problem with data in other fields!!
Do you have an idea about the way to solve this issue?
Thanks
Didier
