topic Re: Invalid state, the Connection object is closed. in Talend Studio

Invalid state, the Connection object is closed.

somersst — Fri, 24 Aug 2018 14:56:23 GMT

I have a simple Job, which reads information from a csv (40 columns) and tries to send it to an Azure SQL database.

But I get always the message : "Invalid state, the Connection object is closed."

I already tried to remove some columns, and then sometimes it works and sometimes it doesn't work. I don't have any clue anymore where I need to look for the solution. Has anyone some ways to troubleshoot this further.

Re: Invalid state, the Connection object is closed.

Anonymous — Fri, 24 Aug 2018 15:55:20 GMT

Hi Somersst,

“Invalid State, the connection object is closed” – this issue occurs due to database connections being closed. It can happen because of the connection timeout between servers or database unavailable(might be restarted or down).

There is also a community posting on this :

https://community.talend.com/t5/Design-and-Development/resolved-Errors-when-loading-large-data-sets-to-from-Microsoft/m-p/79148#M39441

Thanks,

RekhaSree

Re: Invalid state, the Connection object is closed.

Anonymous — Thu, 30 Aug 2018 03:41:06 GMT

Hello,

Have you tried to reduce batch size in the Advanced settings of the component(Batch size as 50 or 100) to see if it works?

Best regards

Sabrina

Re: Invalid state, the Connection object is closed.

Anonymous — Thu, 14 Nov 2019 11:03:18 GMT

I have faced this issue and found a solution. Use the microsoft driver instead of the jtds driver for large inserts.

Let us know if it works for you.

Thomas