topic Re: java.sql.SQLException: The syntax of the connection URL jdbc:jtds:sqlserver://:1433;appName Invalid Error in Talend Studio

java.sql.SQLException: The syntax of the connection URL jdbc:jtds:sqlserver://:1433;appName Invalid Error

Anonymous — Sat, 16 Nov 2024 04:38:51 GMT

Dear Team,

I am performing a an ELT operations using tELTMSSqlInput, tELTMSSqlOutput and tELTMSsqlMap. I was able to connect the database and retrive the schemas through tELTMSSqlInput and tELTMSSqlOutput. But while running the job i am getting the error as follows,

Exception in component tELTMSSqlOutput_1 (Data_Push)
java.sql.SQLException: The syntax of the connection URL 'jdbc:jtds:sqlserver://:1433;appName=MS_SQL_TEST;' is invalid.
	at net.sourceforge.jtds.jdbc.Driver.setupConnectProperties(Driver.java:242)
	at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at ms_sql_test.mstrbi_data_push_0_1.Data_Push.tELTMSSqlMap_1Process(Data_Push.java:414)

Could you please guide how to resolve this, as i was able to connect those database, but while running the job i am getting this error. PFA screenshot of my job for reference.

Re: java.sql.SQLException: The syntax of the connection URL jdbc:jtds:sqlserver://:1433;appName Invalid Error

Anonymous — Wed, 25 Sep 2019 09:43:53 GMT

Hello,

Some errors like 'can not connect to DB' will be logged if you don't fill all the required info.

Best regards

Sabrina

Re: java.sql.SQLException: The syntax of the connection URL jdbc:jtds:sqlserver://:1433;appName Invalid Error

rmartin2 — Wed, 25 Sep 2019 16:56:56 GMT

Hi,

There's a bug with ELTComponent in JDBC it seems : you can't you a tELTConnection. It doesn't seems to initiate properly.

Try to put your connection info directly in the tELTMap.

The tELTMap is the one connecting to the Database not Input and Output.

Sincerely,