topic java.sql.SQLException: No operations allowed after statement closed in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 05:12:31 GMT

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

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

Anonymous — Mon, 22 Jul 2019 15:02:53 GMT

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 🙂

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

Anonymous — Tue, 23 Jul 2019 08:09:17 GMT

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

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

Anonymous — Tue, 23 Jul 2019 21:12:47 GMT

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 🙂

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

Anonymous — Fri, 26 Jul 2019 08:55:27 GMT

yes, thanks