java.sql.SQLException: No operations allowed after statement closed

[Anonymous]

Hello,

no data is inserted in my db, so I added a commit component, but then I get this error

I check the code, I dont understand what's wrong

is my flow correct ?

regards

[Anonymous]

Hi,

    Please verify whether you have selected close connection check box in your commit.

    Since you are processing data as iterations, the connection will be closed after first iteration if you select "Close Connection" checkbox.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi Nik,

thanks a lot, how could I missed this 🙂

but my other jobs dont need a tDBCommit to insert data, while this one does

what makes a job need a commit component ?

how can I fix this ?

regards

[Anonymous]

Hi,

    Please check whether you have enabled the auto commit in the advanced section of the DB connection component.

    It could be the reason. If you do not want to have separate commit command, you can enable the auto commit for this job too.

    I hope I answered your query 🙂 Could you please spare a second to mark the topic as resolved? Kudos will be a bonus!

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

yes, thanks