The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Hello, I am testing SQL Anywhere 12.0.1.4104 and 16.0.0.1948 web client procedure. When the length of the parameters exceeds 8191 bytes the following error appears "SQLSTATE=WW052 Error Message : HTTP request failed. Status code '403 Forbidden'" SQL Anywhere 9 version works with parameters length over 1MB. Using HEADER clause to set the Content-Length I can reduse below 8192 bytes but not above. Perhaps this limitation is set in the database and I wonder whether it can be increased.

create or replace procedure "DBA"."test_post"(in "filename" char(256),in "filedata" long varchar) url 'HTTP://www.domain.com/test/test.php' type 'HTTP:POST';

test.php <? $filename = $_POST['filename']; echo "FileName : $filename"; ?>

asked 26 Oct '14, 15:48

Veselin%20Ivanov's gravatar image

Veselin Ivanov
44357
accept rate: 0%

There is no limitation on the length of a parameter... What is your web service definition?

(26 Oct '14, 16:26) Mark Culp

Veselin, did the answer below help you?

(31 Oct '14, 11:59) Vlad

Try the MaxRequestSize protocol parameter: -xs HTTP(port=<port#>;MaxRequestSize=<size>

permanent link

answered 27 Oct '14, 08:10

PaulTonizzo%20%20SA%20tools's gravatar image

PaulTonizzo ...
516310
accept rate: 31%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×186
×20
×18

question asked: 26 Oct '14, 15:48

question was seen: 871 times

last updated: 31 Oct '14, 15:23