DB2 output component error

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

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch