A
Awadhesh Verma
Guest
hi, following steps done. 1. created table with provide .df file. 2. populated table with 3 row. each row have same blob data (.r file you provided). 3. trim out client/server code for only temp-table as output. Below is the code: client code: DEFINE TEMP-TABLE tt-sysfiletransfer NO-UNDO FIELD sysfiletransfernaam AS CHARACTER LABEL 'Bestandsnaam' FORMAT 'x(40)' INITIAL '' FIELD sysfiletransferpad AS CHARACTER LABEL 'sysfiletransferpad' FORMAT 'x(80)' INITIAL '' FIELD typefile AS CHARACTER LABEL 'Type file' FORMAT 'x(8)' INITIAL '' FIELD blobfile AS BLOB FORMAT 'x(8)' FIELD timestamp AS DATETIME LABEL 'Timestamp' FORMAT '99/99/9999 HH:MM:SS.SSS' INDEX sysfiletransfernaam sysfiletransferpad. DEFINE VARIABLE hWS AS HANDLE NO-UNDO. DEFINE VAR picfile AS CHAR. CREATE SERVER hWS. IF hWS:CONNECT(" -URL localhost:8080/.../Aia THEN DO: message "connected" view-as alert-box. RUN "apchkusernet.p" ON hWS(OUTPUT TABLE tt-sysfiletransfer). END. FOR EACH tt-sysfiletransfer: picfile = tt-sysfiletransfer.sysfiletransfernaam + ".r". COPY-LOB tt-sysfiletransfer.blobfile TO FILE picfile. DISPLAY tt-sysfiletransfer.sysfiletransfernaam. END. server code: DEFINE TEMP-TABLE tt-sysfiletransfer NO-UNDO FIELD sysfiletransfernaam AS CHARACTER LABEL 'Bestandsnaam' FORMAT 'x(40)' INITIAL '' FIELD sysfiletransferpad AS CHARACTER LABEL 'sysfiletransferpad' FORMAT 'x(80)' INITIAL '' FIELD typefile AS CHARACTER LABEL 'Type file' FORMAT 'x(8)' INITIAL '' FIELD blobfile AS BLOB FORMAT 'x(8)' FIELD timestamp AS DATETIME LABEL 'Timestamp' FORMAT '99/99/9999 HH:MM:SS.SSS' INDEX sysfiletransfernaam sysfiletransferpad. DEFINE OUTPUT PARAMETER TABLE FOR tt-sysfiletransfer. FOR EACH sysfiletransfer: CREATE tt-sysfiletransfer. BUFFER-COPY sysfiletransfer TO tt-sysfiletransfer. END. RETURN. 4. started tomcat in box (version 7.0.3) having aia deployed. 5. started appserver. 6. run the client. RESULT: successfully received the temp-table. 7. download tomcat version 9.0.0.0 and deployed aia in it. 8. started tomcat and run client. RESULT: successfully received the temp-table. So, i could not get any error for both version of tomcat. Note: i did not do any change in server.xml file. Thanks, Awadhesh
Continue reading...
Continue reading...