Six Stars

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

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.

3 REPLIES
Community Manager

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

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-S...
Let me know if you still get the error.

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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.

Moderator

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


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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.