when I insert 0 record, error occurred.

Four Stars

when I insert 0 record, error occurred.

hello.

 

I make a job. select data and insert to table.

when i select 0 record, error occurred.

I think it is a reason.

there is no record to commit.

what is the solution for 0 record to insert?

 

Thank you.

output_2.jpg

Fifteen Stars TRF
Fifteen Stars

Re: when I insert 0 record, error occurred.

Hi,

What's the error mesage?


TRF
Four Stars

Re: when I insert 0 record, error occurred.

I got a korean error message. so i translated it.

 

error message. 

 

failed to close the connection in tDB2Output_1 : [jcc][t4][10251][10308][4.19.26] 

 

java.sql.Connection.close() is called when trasaction  is running.

 

can't close connection because, transaction is running. ERRORCODE = -4471, SQLSTATE=null

 

thank you.

 

Fifteen Stars TRF
Fifteen Stars

Re: when I insert 0 record, error occurred.

Thank's for the translation Smiley Wink

I don't think the problem is due to the number of rows.

Can you share the whole job design?


TRF
Four Stars

Re: when I insert 0 record, error occurred.

 

 

 

IMG_20171103_172239HD.jpg

 

it is my job desing.

 

thank you.

Four Stars

Re: when I insert 0 record, error occurred.

test.png

Fifteen Stars TRF
Fifteen Stars

Re: when I insert 0 record, error occurred.

Nothing to sy about the job design.
Maybe a problem with the tDB2Output component.
To my knowledge, this doesn't occur with components like tSalesforceOutput or tOracleOutput (but it does with tSalesforceOutputBulkExec for example).

TRF
Four Stars

Re: when I insert 0 record, error occurred.

thank you.

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

Watch

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch