topic Re: when I insert 0 record, error occurred. in Talend Studio

when I insert 0 record, error occurred.

Anonymous — Fri, 03 Nov 2017 07:41:53 GMT

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.

Re: when I insert 0 record, error occurred.

TRF — Fri, 03 Nov 2017 07:50:48 GMT

Hi,

What's the error mesage?

Re: when I insert 0 record, error occurred.

Anonymous — Fri, 03 Nov 2017 08:07:27 GMT

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.

Re: when I insert 0 record, error occurred.

TRF — Fri, 03 Nov 2017 08:12:07 GMT

Thank's for the translation

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

Can you share the whole job design?

Re: when I insert 0 record, error occurred.

Anonymous — Fri, 03 Nov 2017 08:41:05 GMT

it is my job desing.

thank you.

Re: when I insert 0 record, error occurred.

Anonymous — Fri, 03 Nov 2017 08:43:44 GMT

Re: when I insert 0 record, error occurred.

TRF — Fri, 03 Nov 2017 10:44:04 GMT

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

Re: when I insert 0 record, error occurred.

Anonymous — Tue, 07 Nov 2017 00:36:22 GMT

thank you.