Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sree4
Contributor
Contributor

Talend Context Variable error

Hi , I have the error when using Context variable. I can run it in one environment but not the other.

I have the error as follows:

java.sql.SQLException: The syntax of the connection URL 'jdbc:jtds:sqlserver://null:null//null;appName=PROJECT1;' is invalid.

Including screen shots below.

I appreciate your help in advance.

Context variable screen shot:

0693p00000AH2nQAAT.png

Component Configuration

0693p00000AH2nfAAD.png

Runs in "default" environment

0693p00000AH2nkAAD.png

Errors out in "QA" environment

0693p00000AH2npAAD.png

Labels (3)
2 Replies
manodwhb
Champion II
Champion II

@Sreelatha Vishnubhatla​ , to figure out the issue use just tjava component to print the server url and see the problem that escape sequence character you need to add or not.

 

Thanks,

Manohar

Anonymous
Not applicable

Can you check if you did not add any space or RC invisible character around the strings ?

I'd suggest you first, you modify the Server IP , without any copy paste, just by fully typing it

 

And check if null hostname becomes the IP