topic Re: Where to put the mssql-jdbc jar for coonecting to SQL Server in Talend Studio

Where to put the mssql-jdbc jar for coonecting to SQL Server

Anonymous — Sat, 16 Nov 2024 09:36:55 GMT

Hi,

I have downloaded the mssql-jdbc jar file as per the requirement 'Talend Studio requires specific third-party Java libraries or database drivers (.jar files) to be installed to connect to sources and targets.' Now where should I put the JAR in order to get successfully connected to SQL server database?

Please suggest.

Re: Where to put the mssql-jdbc jar for coonecting to SQL Server

Anonymous — Tue, 20 Jun 2017 07:07:31 GMT

Hello
I have showed how to install external jars manually in this page:
https://community.talend.com/t5/Installing-and-Upgrading/Getting-error-to-connect-to-Microsoft-SQL-Server-Database/m-p/28323#M1065
Let me know if you still get the error.

Regards
Shong

Re: Where to put the mssql-jdbc jar for coonecting to SQL Server

Anonymous — Sat, 08 Jul 2017 06:10:59 GMT

Hi,

I am unable to load data to a table in MS-sql Server 2016.

I get the following error:

I/O Error: Software caused connection abort: recv failed
Exception in component tMSSqlOutput_1
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:481)
at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:767)
at net.sourceforge.jtds.jdbc.JtdsStatement.reset(JtdsStatement.java:722)
at net.sourceforge.jtds.jdbc.JtdsStatement.close(JtdsStatement.java:966)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.close(JtdsPreparedStatement.java:707)
at ing_ppg_performa.hive_0_1.Hive.tFileInputDelimited_1Process(Hive.java:3405)
at ing_ppg_performa.hive_0_1.Hive.tMSSqlInput_1Process(Hive.java:2293)
at ing_ppg_performa.hive_0_1.Hive.runJobInTOS(Hive.java:3877)
at ing_ppg_performa.hive_0_1.Hive.main(Hive.java:3543)
[ERROR]: ing_ppg_performa.hive_0_1.Hive - tMSSqlOutput_1 - I/O Error: Software caused connection abort: recv failed
[FATAL]: ing_ppg_performa.hive_0_1.Hive - tMSSqlOutput_1 Invalid state, the Connection object is closed.

I have made a Db Connection through Open Source JTDS, the connection works fine.

But my job does not work fine and I get the above error.

So, I tried to use Microsoft Db version drop down.

But, was not able to connect at all.

I have installed the jar and renamed to mssql-jdbc.jar, but was in vain.

Can someone please help me out on this.

Thanks in advance.

Re: Where to put the mssql-jdbc jar for coonecting to SQL Server

Anonymous — Mon, 10 Jul 2017 04:50:06 GMT

@Archu wrote:

Hi,

I am unable to load data to a table in MS-sql Server 2016.

I get the following error:

I/O Error: Software caused connection abort: recv failed
Exception in component tMSSqlOutput_1
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:481)
at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:767)
at net.sourceforge.jtds.jdbc.JtdsStatement.reset(JtdsStatement.java:722)
at net.sourceforge.jtds.jdbc.JtdsStatement.close(JtdsStatement.java:966)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.close(JtdsPreparedStatement.java:707)
at ing_ppg_performa.hive_0_1.Hive.tFileInputDelimited_1Process(Hive.java:3405)
at ing_ppg_performa.hive_0_1.Hive.tMSSqlInput_1Process(Hive.java:2293)
at ing_ppg_performa.hive_0_1.Hive.runJobInTOS(Hive.java:3877)
at ing_ppg_performa.hive_0_1.Hive.main(Hive.java:3543)
[ERROR]: ing_ppg_performa.hive_0_1.Hive - tMSSqlOutput_1 - I/O Error: Software caused connection abort: recv failed
[FATAL]: ing_ppg_performa.hive_0_1.Hive - tMSSqlOutput_1 Invalid state, the Connection object is closed.

Hi,

Could you please check it to see if it is network timeout issue?

Best regards

Sabrina