Firebird & data truncation

Anonymous — Tue, 08 Mar 2016 13:02:16 GMT

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

Re: Firebird & data truncation

Anonymous — Wed, 09 Mar 2016 07:37:49 GMT

Hi,
Have you tried to change the field size in talend?
Here is KB document about: TalendHelpCenter:Exception Data truncation Data too long for column.
Best regards
Sabrina

topic Re: Firebird & data truncation in Talend Studio

Firebird & data truncation

Re: Firebird & data truncation