cancel
Showing results for 
Search instead for 
Did you mean: 

Connection timeout setting on sender JDBC channel for MSSQL server

0 Kudos

HI SAp gurus,

Can any one please provide the timeout setting parameters for MSSQL server for sender channel in advanced mode.

I have tried following the instructions in the note 1586058 and didnt find any setting.

Please let me know what values to update in advance tab for this

Regards,

Kalyan

0 Kudos

HI Manoj,

I wanted to set the connection timeout parameter setting for sender jdbc channel for MSSQL in advance mode.

I could find some articles about how to set timeout parameter for Oracle or DB2 on XI JDBC channel's in advance mode. But it seems there's nothing about SqlServer, or just I couldn't find one..

So could you please help here.

Regards,

Kalyan

Accepted Solutions (0)

Answers (2)

Answers (2)

anupam_ghosh2
Active Contributor
0 Kudos

Hi kalyan.kumar19,

In communication channel parameters -> advanced mode try this setting according to your requirement.

taskTimeout => time in seconds for timeout.

regards

Anupam

manoj_khavatkopp
Active Contributor
0 Kudos

Hi Kalyan ,

Can you try to pass parameter in connection url instead in advance mode :

jdbc:sqlserver://<host>:<port>;DatabaseName=<dbname>;queryTimeout=5

or

jdbc:sqlserver://<host>:<port>;DatabaseName=<dbname>;socketTimeout=5

Thanks,

Manoj

0 Kudos

HI Manoj..

tried..but no luck..not working