topic Re: [resolved] tMSSqlInput conncetion issue in Talend Studio

[resolved] tMSSqlInput conncetion issue

Raghunath — Sat, 16 Nov 2024 11:29:42 GMT

I am using Talend BigData 5.5.0 open source. I doesn't have any issue until yesterday. Today when I try to a run job which is being in use from 20 days has thrown below mentioned error.
Exception in component tMSSqlInput_1
java.sql.SQLException: The BUFFERDIR connection property is invalid.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.unpackProperties(ConnectionJDBC2.java:1241)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:269)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
Talend BigData 5.5.0 open source.
OS : Windows Server 2008 R2.
please help me to resolve.
Thanks in advance,
L Raghunath.

Re: [resolved] tMSSqlInput conncetion issue

Anonymous — Tue, 23 Sep 2014 04:29:29 GMT

Hi,
Have you checked article http://stackoverflow.com/questions/10329250/cannotgetjdbcconnectionexception-the-bufferdir-connection-property-is-invalid to see if it is working for your situation?
Best regards
Sabrina

Re: [resolved] tMSSqlInput conncetion issue

Raghunath — Tue, 30 Sep 2014 10:09:39 GMT

I checked article provided by you, in article it is not mentioned how to resolve issue.

Re: [resolved] tMSSqlInput conncetion issue

Anonymous — Tue, 30 Sep 2014 11:02:08 GMT

What is your job? are you using JDBC? any changes to the system or java updates?
Vaibhav

Re: [resolved] tMSSqlInput conncetion issue

Raghunath — Tue, 30 Sep 2014 12:09:10 GMT

My job is
when i run above job i am getting error as
connecting to socket on port 3700
connected
Exception in component tMSSqlInput_1
java.sql.SQLException: The BUFFERDIR connection property is invalid.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.unpackProperties(ConnectionJDBC2.java:1241)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:269)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at bdhdfs.tgt_fiscal_0_1.TGT_FISCAL.tMSSqlInput_1Process(TGT_FISCAL.java:658)
at bdhdfs.tgt_fiscal_0_1.TGT_FISCAL.runJobInTOS(TGT_FISCAL.java:1273)
at bdhdfs.tgt_fiscal_0_1.TGT_FISCAL.main(TGT_FISCAL.java:1132)
disconnected
I used to run jobs with same settings before 10 days
Let me know if you need more information

Re: [resolved] tMSSqlInput conncetion issue

Raghunath — Tue, 30 Sep 2014 13:04:05 GMT

-- Mentioned in post how can we modify value for temp directory

Re: [resolved] tMSSqlInput conncetion issue

Anonymous — Wed, 08 Oct 2014 10:05:22 GMT

Hi,
It's a helpful feedback. Thanks for sharing the solution with us.
Best regards
Sabrina