DB2 output component error

One Star

DB2 output component error

I tried to write a simply update in db2 by using db2 output component.
But I got the following error:
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)
Do you know what this means?

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).

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach


Definitive Guide to Data Quality

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



Introduction to Talend Open Studio for Data Integration.