topic Re: Talend Context Variable error in Talend Studio

Talend Context Variable error

Sree4 — Sat, 16 Nov 2024 01:09:29 GMT

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:

Component Configuration

Runs in "default" environment

Errors out in "QA" environment

Re: Talend Context Variable error

manodwhb — Mon, 09 Nov 2020 02:02:14 GMT

@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

Re: Talend Context Variable error

Anonymous — Tue, 10 Nov 2020 09:29:02 GMT

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