How to add timeout in talend JDBC DB URL

[Rathesh]

Hello All,

I have created the job to load data from SQL Server 2012. Is there a way to pass the timeout in the JDBC URL?.

Thanks

[Anonymous · Accepted solution]

Hi

Please refer to the below links, add the parameter queryTimeout=X to the addtional JDBC parameter field in the advanced settings panel of tMSSQLInput component. eg:

"noDatetimeStringSync=true;queryTimeout=10"

https://github.com/Microsoft/mssql-jdbc/wiki/QueryTimeout

https://stackoverflow.com/questions/36553857/how-can-i-enforce-a-query-timeout-for-ms-sql-server-queries-run-via-the-ms-jdbc

Regards

Shong

[Rathesh]

May I know what is the default timeout in Talend for SQL Server connection

[Anonymous]

It might be different for different database version, you can google it on internet or look into the MS SQL documentation.