Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

Firebird & data truncation

Highlighted
One Star

Firebird & data truncation

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
Highlighted
Moderator

Re: Firebird & data truncation

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog