Six Stars

[resolved] tMSSqlInput conncetion issue

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.
Raghunath Lingutla
1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: [resolved] tMSSqlInput conncetion issue


-- Mentioned in post how can we modify value for temp directory
Raghunath Lingutla
6 REPLIES
Moderator

Re: [resolved] tMSSqlInput conncetion issue

Hi,
Have you checked article http://stackoverflow.com/questions/10329250/cannotgetjdbcconnectionexception-the-bufferdir-connectio... to see if it is working for your situation?
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.
Six Stars

Re: [resolved] tMSSqlInput conncetion issue

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

Re: [resolved] tMSSqlInput conncetion issue

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

Re: [resolved] tMSSqlInput conncetion issue

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
Raghunath Lingutla
Six Stars

Re: [resolved] tMSSqlInput conncetion issue


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

Re: [resolved] tMSSqlInput conncetion issue

Hi,
It's a helpful feedback. Thanks for sharing the solution with us.
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.