Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ASA9 and remote connection timeout on web service call

3 posts in General Discussion Last posting was on 2006-04-27 14:40:01.0Z
JR Posted on 2006-04-25 15:16:46.0Z
From: "JR" <jr@jr.com>
Newsgroups: ianywhere.public.general
Subject: ASA9 and remote connection timeout on web service call
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: mail.micromd.com
X-Original-NNTP-Posting-Host: mail.micromd.com
Message-ID: <444e3d5e$1@forums-1-dub>
Date: 25 Apr 2006 08:16:46 -0700
X-Trace: forums-1-dub 1145978206 24.154.8.58 (25 Apr 2006 08:16:46 -0700)
X-Original-Trace: 25 Apr 2006 08:16:46 -0700, mail.micromd.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5300
Article PK: 1354

Hi,

I'm using ASA9 procedures to make web service calls:

ALTER PROCEDURE "DBA"."sp_http_send"(in url long varchar,in certfile long
varchar,in body long varchar)
result(Attribute long varchar,Value long binary)
on exception resume
url '!url' type 'HTTP:POST' certificate '!certfile'

It works just fine in most situations, but once in awhile I get a SQLCode
of -982 saying that the connection timed out.

Is there any way to set the connection time out in the DB to give a little
extra time for the return?

Thanks!

JR


Mark Culp Posted on 2006-04-26 20:13:33.0Z
Message-ID: <444FC39F.B372221F@iAnywhere.com>
From: Mark Culp <reply_to_newsgroups_only_please_nospam_mark.culp@iAnywhere.com>
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ASA9 and remote connection timeout on web service call
References: <444e3d5e$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: mculp-pc.sybase.com
X-Original-NNTP-Posting-Host: mculp-pc.sybase.com
Date: 26 Apr 2006 13:13:33 -0700
X-Trace: forums-1-dub 1146082413 10.25.107.117 (26 Apr 2006 13:13:33 -0700)
X-Original-Trace: 26 Apr 2006 13:13:33 -0700, mculp-pc.sybase.com
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5302
Article PK: 1356

You can set the REMOTE_IDLE_TIMEOUT option to the number of
seconds that you want remote RPC calls to wait before timing out.
The default is 15 seconds.

See the docs under:
SQL Anywhere Database Administration Guide
Database Options
Alphabetical list of options
remote_idle_timeout option [database]
for more information.
--
Mark Culp
SQLAnywhere Research and Development
-------------------------------------------------------------------------
** Whitepapers, TechDocs, bug fixes are all available through the **
** iAnywhere Developer Community at http://www.ianywhere.com/developer **
-------------------------------------------------------------------------

JR wrote:
>
> Hi,
>
> I'm using ASA9 procedures to make web service calls:
>
> ALTER PROCEDURE "DBA"."sp_http_send"(in url long varchar,in certfile long
> varchar,in body long varchar)
> result(Attribute long varchar,Value long binary)
> on exception resume
> url '!url' type 'HTTP:POST' certificate '!certfile'
>
> It works just fine in most situations, but once in awhile I get a SQLCode
> of -982 saying that the connection timed out.
>
> Is there any way to set the connection time out in the DB to give a little
> extra time for the return?
>
> Thanks!
>
> JR


JR Posted on 2006-04-27 14:40:01.0Z
From: "JR" <jr@jr.com>
Newsgroups: ianywhere.public.general
References: <444e3d5e$1@forums-1-dub> <444FC39F.B372221F@iAnywhere.com>
Subject: Re: ASA9 and remote connection timeout on web service call
Lines: 45
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: mail.micromd.com
Message-ID: <4450c6f7@forums-2-dub>
X-Original-Trace: 27 Apr 2006 06:28:23 -0700, mail.micromd.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 27 Apr 2006 06:28:23 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 27 Apr 2006 07:40:01 -0700
X-Trace: forums-1-dub 1146148801 10.22.108.75 (27 Apr 2006 07:40:01 -0700)
X-Original-Trace: 27 Apr 2006 07:40:01 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5303
Article PK: 1357

Thanks Mark. That is just the thing I was looking for.

"Mark Culp" <reply_to_newsgroups_only_please_nospam_mark.culp@iAnywhere.com>

wrote in message news:444FC39F.B372221F@iAnywhere.com...
> You can set the REMOTE_IDLE_TIMEOUT option to the number of
> seconds that you want remote RPC calls to wait before timing out.
> The default is 15 seconds.
>
> See the docs under:
> SQL Anywhere Database Administration Guide
> Database Options
> Alphabetical list of options
> remote_idle_timeout option [database]
> for more information.
> --
> Mark Culp
> SQLAnywhere Research and Development
> -------------------------------------------------------------------------
> ** Whitepapers, TechDocs, bug fixes are all available through the **
> ** iAnywhere Developer Community at http://www.ianywhere.com/developer **
> -------------------------------------------------------------------------
> JR wrote:
>>
>> Hi,
>>
>> I'm using ASA9 procedures to make web service calls:
>>
>> ALTER PROCEDURE "DBA"."sp_http_send"(in url long varchar,in certfile long
>> varchar,in body long varchar)
>> result(Attribute long varchar,Value long binary)
>> on exception resume
>> url '!url' type 'HTTP:POST' certificate '!certfile'
>>
>> It works just fine in most situations, but once in awhile I get a SQLCode
>> of -982 saying that the connection timed out.
>>
>> Is there any way to set the connection time out in the DB to give a
>> little
>> extra time for the return?
>>
>> Thanks!
>>
>> JR