DB2 output component error

Highlighted
One Star

DB2 output component error

Hi,
I tried to write a simply update in db2 by using db2 output component.
But I got the following error:
connected
Exception in component tDB2Output_1
com.ibm.db2.jcc.a.SqlException: Jdbc type 1111 not yet supported.
at com.ibm.db2.jcc.a.n.a(n.java:1003)
at com.ibm.db2.jcc.a.n.a(n.java:892)
at com.ibm.db2.jcc.a.n.a(n.java:873)
at com.ibm.db2.jcc.a.sf.b(sf.java:568)
at com.ibm.db2.jcc.a.sf.setNull(sf.java:558)
at advservice.millupdate_0_1.millupdate.tDB2Input_1Process(millupdate.java:1332)
at advservice.millupdate_0_1.millupdate.runJobInTOS(millupdate.java:1761)
at advservice.millupdate_0_1.millupdate.main(millupdate.java:1635)
disconnected
Do you know what this means?
Thanks.
Employee

Re: DB2 output component error

I know it's an old post but I just experience this problemby trying to insert a NULL data in a column that is configured in the data model to NOT NULL.
Look at all your data in your dataflow (Maybe if you use a tmap a join that is not managed in inner join type).

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.