cancel
Showing results for 
Search instead for 
Did you mean: 

How can I set a connection timeout on JDBC channel for SqlServer2005?

Former Member
0 Kudos

Hello,

I could find some articles about how to set timeout parameter for Oracle or DB2 on XI JDBC channel's advence mode.

But it seems there's nothing about SqlServer, or just I couldn't find one, whatever......Is there's some way to set timeout for SqlServer 2005?

Regards,

Hwang

Accepted Solutions (1)

Accepted Solutions (1)

prateek
Active Contributor
0 Kudos

See SAP Note 791379. This is not SQL Server specific although.

From visual admin check out xiadapter.inbound.timeout.default within the SAP XI Adapter: XI J2EE service

Regards,

Prateek

Former Member
0 Kudos

Thanks, but I want to set this timeout limit individualy for each target system

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

In your communication channel, advanced mode :

name --> taskTimeout

value --> your timeout in secs.

Regards,

Carme

Former Member
0 Kudos

Thank you very much!

Now I need to think how can I test this parameter without stop systems

Former Member
0 Kudos

Thank you very much!

Now I need to think how can I test this parameter without stop systems

Edited by: Mr.Hwang on Mar 18, 2010 10:46 AM

Former Member
0 Kudos

Why you need to test ? It's a standard functionality ...

But, if you want, you can execute a stored procedure with a large time of response...

Regards,

Carme

Former Member
0 Kudos

Hi Mr. Hwang,

These timeouts are more specific to corresponding JDBC Drivers. So for this information, please contact your DB vendor to provide the correct timeouts which will act similar to that of the driver timeouts of Oracle or DB2 database. Or you can do a google search for the same. I have googled it and find this link. Hope this will help you. Please check once.

http://www.inetsoftware.de/documentation/jdbc-driver/ms-sql/manual.html#Properties

Regards,

Achari