TomCat return Temp-table with clob - Forum - OpenEdge Development - Progress Community

TomCat return Temp-table with clob

 Forum

TomCat return Temp-table with clob

This question is not answered
Hi, I have an application and it's connecting to the appserver via Tomcat port 8080 and AIA. I have a temp-table: DEFINE TEMP-TABLE tt-sysfiletransfer NO-UNDO FIELD blobfile AS BLOB. On the appserver: DEFINE OUTPUT PARAMETER TABLE FOR tt-sysfiletransfer. The client crashes when there's more then 1 Mb in the temp-table, So I thought that it had something to do with Tomcat maximum size. Doing the same thing on port 80, IIS -> Tomcat -> AIA, then it workes. In the 'application routing request' of IIS, you need to set the size. I've added: maxPostSize="-1" in the tomcat conf/server.xml, but that doesn't solves my problem. So my question is, is there some parameter in Tomcat that needs to be set so I can transfer more than 1Mb ? Kind regards Bart S.
All Replies
  • where is your tomcat running? on appserver machine or any other machine.

    have you tried with HTTP_BUFFER_SIZE setting at system level ? if not, try it by setting on system level.

    knowledgebase.progress.com/.../how-to-set-the-environment-variable-http-buffer-size-for-webclient-application

  • Hi,

    Tomcat is running on the same machine as the appserver.

    I've tried setting HTTP_BUFFER_SIZE in progress.ini file and also as a system_variable, but both didn't help...

  • First thought was that it had something to do with the clob-records, but meanwhile, I found out that if it's a temp-table with a lot of records, then the client also crashes.

    So:

    WebClient -> TomCat (8080) -> AIA -> Appserver: Client crash

    WebClient -> ISS(80) -> TomCat(8080) -> AIA -> Appserver: OK

  • Instead of using webclient try with simple ABL client and set the HTTP_BUFFER_SIZE at system level at client side. Let me know after doing this if you got same issue.

  • Hi,

    What I have done:

    Add HTTP_BUFFER_SIZE at system-level, environment variables (Windows 10).

    Rebooted my computer.

    Opened AppBuilder > procedure editor

    Run a little program that connects to the appserver on port 8080 (testclient.p)

    Little program is just running a .p on the appserver, that .p creates some records in a temp-table.

    At that point my client crashes....

    Doing exact the same thing, on port 80, it just works.

    If it's any help, I can send you the testclient.p offline.

    Kind regards

  • Hi,

    What I have done:

    Add HTTP_BUFFER_SIZE at system-level, environment variables (Windows 10).

    Rebooted my computer.

    Opened AppBuilder > procedure editor

    Run a little program that connects to the appserver on port 8080 (testclient.p)

    Little program is just running a .p on the appserver, that .p creates some records in a temp-table.

    At that point my client crashes....

    Doing exact the same thing, on port 80, it just works.

    If it's any help, I can send you the testclient.p offline.

    Kind regards