Invalid state, the Connection object is closed.

[somersst]

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.

[Anonymous]

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

Thanks,

RekhaSree

[Anonymous]

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

[Anonymous]

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