Cannot write to SQL Server and also cannot install external jar

jimbo20814 — Sat, 16 Nov 2024 03:17:55 GMT

Hello, via a referenced project SQL Server metadata connection, I'm trying to write some records (about 5100 records) from Kafka to a SQL table. But I get the below errors. I read in some other related posts people complaining about the Talend SQL Server jdbc driver and to use the Microsoft driver instead. Then when I try to use the MS driver Talend then says to install external jar but the button is grayed out to download/install. So it it really a driver issue? If so how the heck can I install the MS jdbc driver, it won't let me.

I/O Error: Connection reset by peer: socket write error
[ERROR]: lenses.lenses_timeslots_0_1.Lenses_TimeSlots - tDBOutput_1 - I/O Error: Connection reset by peer: socket write error
[FATAL]: lenses.lenses_timeslots_0_1.Lenses_TimeSlots - tDBOutput_1 Invalid state, the Connection object is closed.

Re: Cannot write to SQL Server and also cannot install external jar

jimbo20814 — Tue, 11 Feb 2020 23:02:57 GMT

Realized how to install external jar, my bad. Switched to MS jdbc driver but still having issues. What's weird is I'm able to read from table. I just can't write to table. What's up with that!

I/O Error: Connection reset
[ERROR]: lenses.msdrivertest_0_1.MSDriverTest - tDBOutput_1 - I/O Error: Connection reset
[FATAL]: lenses.msdrivertest_0_1.MSDriverTest - tDBOutput_1 Invalid state, the Connection object is closed.

topic Cannot write to SQL Server and also cannot install external jar in Talend Studio

Cannot write to SQL Server and also cannot install external jar

Re: Cannot write to SQL Server and also cannot install external jar