Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Config Tomcat with ORDS to upload large size files and form max post size

ElenaLoApr 22 2020 — edited May 10 2020

I have installed ORDS 19.4 and Tomcat 9.0.31. I have tried to config attributs in Tomcat, config server.xml. But they don't work, I obtain allways the same error when try with large file uploads or large data in form post

500 Internal Server Error

2020-04-22T14:19:57.081Z | 7pvIao-S13Az9uIPFD0omw

InternalServerException [statusCode=500, reasons=[An unexpected error with the following message occurred: Stream ended unexpectedly]]

at oracle.dbtools.http.errors.ServletResponseExceptionMapper.mapError(ServletResponseExceptionMapper.java:89)

or

InternalServerException [statusCode=500, reasons=[]]

at oracle.dbtools.apex.ModApexContext.handleError(ModApexContext.java:288)

EXEC FAILED:ORA-06550: línea 2, columna 2:

PLS-00306: número o tipos de argumentos erróneos al llamar a 'ACTUALITZA'

ORA-06550: línea 2, columna 2:

My tomcat configuration server.xml is:

    <Connector

           protocol="org.apache.coyote.http11.Http11NioProtocol"

           port="443" maxThreads="150"

           connectionTimeout="30000" disableUploadTimeout="false" connectionUploadTimeout="300000"

           maxPostSize="-1" maxHeaderCount="-1" maxParameterCount="-1" maxSavePostSize="-1" maxHttpHeaderSize="20971520"

           socket.soTimeout="30000"

           scheme="https" secure="true" SSLEnabled="true"

           keystoreFile="mypath" keystorePass="mypass"

           clientAuth="false" sslProtocol="TLS" />

   

PLEASE HELP!!!!! I have done many test, anything works!

This post has been answered by ElenaLo on Apr 27 2020
Jump to Answer

Comments

ElenaLo
Answer

After hours researching I decided to upgrade the version Tomcat 9.0.34 and the problem was solved!

Marked as Answer by ElenaLo · Sep 27 2020
AndyH

The error message seems to say that something is calling the procedure ACTUALIZER with the wrong number of parameters or data types?

I'm surprised that a new version of Tomcat would fix this.

1 - 2

Post Details

Added on Apr 22 2020
2 comments
811 views