topic Re: How to add timeout in talend JDBC DB URL in Talend Studio

How to add timeout in talend JDBC DB URL

Rathesh — Fri, 15 Nov 2024 23:35:25 GMT

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

Re: How to add timeout in talend JDBC DB URL

Anonymous — Wed, 27 Oct 2021 02:07:29 GMT

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

Re: How to add timeout in talend JDBC DB URL

Rathesh — Wed, 27 Oct 2021 05:31:22 GMT

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

Re: How to add timeout in talend JDBC DB URL

Anonymous — Wed, 27 Oct 2021 08:15:40 GMT

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