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!

java.io.IOException: An established connection was aborted by the software in your host machine

Pedro SalfatteJul 12 2017

Hello,
I have a mobile application that sends several photos to a rest service with ORDS, however fewer photos arrive and in the apache server log gives the error

java.io.IOException: An established connection was aborted by the software in your host machine

12-Jul-2017 20:22:04.380 SEVERE [http-nio-8081-exec-20] . Could not generate servlet response from: InternalServerException [statusCode=500, reasons=[An unexpected error with the following message occurred: java.io.IOException: An established connection was aborted by the software in your host machine]] because response was already committed

12-Jul-2017 20:22:04.380 SEVERE [http-nio-8081-exec-20] . org.apache.catalina.connector.ClientAbortException: java.io.IOException: An established connection was aborted by the software in your host machine

InternalServerException [statusCode=500, reasons=[An unexpected error with the following message occurred: java.io.IOException: An established connection was aborted by the software in your host machine]]

12-Jul-2017 20:20:59.655 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log ContextListener: contextInitialized()

12-Jul-2017 20:20:59.655 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log SessionListener: contextInitialized()

12-Jul-2017 20:22:04.380 SEVERE [http-nio-8081-exec-20] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [HttpEndPoint] in context with path [/ords] threw exception [InternalServerException [statusCode=500, reasons=[An unexpected error with the following message occurred: InternalServerException [statusCode=500, reasons=[An unexpected error with the following message occurred: java.io.IOException: An established connection was aborted by the software in your host machine]]]]] with root cause

java.io.IOException: An established connection was aborted by the software in your host machine

at sun.nio.ch.SocketDispatcher.write0(Native Method)

The configuration is:

APEX 5.0100

12-Jul-2017 20:20:59.234 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log INFO: Oracle REST Data Services initialized

Oracle REST Data Services version : 3.0.10.165.06.53

Oracle REST Data Services server info: Apache Tomcat/8.0.44

Server version:        Apache Tomcat/8.0.44

12-Jul-2017 20:20:53.774 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          May 10 2017 17:21:09 UTC

12-Jul-2017 20:20:53.774 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.0.44.0

12-Jul-2017 20:20:53.774 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Windows Server 2008 R2

12-Jul-2017 20:20:53.774 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            6.1

12-Jul-2017 20:20:53.774 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64

12-Jul-2017 20:20:53.774 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             C:\Program Files\Java\jdk1.8.0_131\jre

12-Jul-2017 20:20:53.774 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_131-b11

12-Jul-2017 20:20:53.774 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation

12-Jul-2017 20:20:53.774 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         D:\SOFTWARE\apache-tomcat-8.0.44

12-Jul-2017 20:20:53.774 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         D:\SOFTWARE\apache-tomcat-8.0.44

The parameter in default.xml

<comment>Saved on Wed Jul 12 19:54:55 CLT 2017</comment>

   <entry key="cache.caching">false</entry>

   <entry key="cache.directory">/tmp/apex/cache</entry>

   <entry key="cache.duration">days</entry>

   <entry key="cache.expiration">7</entry>

   <entry key="cache.maxEntries">500</entry>

   <entry key="cache.monitorInterval">60</entry>

   <entry key="cache.procedureNameList"/>

   <entry key="cache.type">lru</entry>

   <entry key="db.hostname">172.30.0.92</entry>

   <entry key="db.port">1522</entry>

   <entry key="db.servicename">orcl11g</entry>

   <entry key="debug.debugger">false</entry>

   <entry key="debug.printDebugToScreen">false</entry>

   <entry key="error.keepErrorMessages">true</entry>

   <entry key="error.maxEntries">50</entry>

   <entry key="jdbc.DriverType">thin</entry>

   <entry key="jdbc.InactivityTimeout">1800</entry>

   <entry key="jdbc.InitialLimit">100</entry>

   <entry key="jdbc.MaxConnectionReuseCount">1000</entry>

   <entry key="jdbc.MaxLimit">5000</entry>

   <entry key="jdbc.MaxStatementsLimit">10</entry>

   <entry key="jdbc.MinLimit">100</entry>

   <entry key="jdbc.statementTimeout">900</entry>

   <entry key="log.logging">false</entry>

   <entry key="log.maxEntries">50</entry>

   <entry key="misc.compress"/>

   <entry key="misc.defaultPage">apex</entry>

   <entry key="security.crypto.enc.password">V2KVOoxf8op7PxXhC8cSBw..</entry>

   <entry key="security.crypto.mac.password">_Rg4UQieWTB4ltLG-fWCGA..</entry>

   <entry key="security.disableDefaultExclusionList">false</entry>

   <entry key="security.maxEntries">2000</entry>

   <entry key="security.requestValidationFunction">wwv_flow_epg_include_modules.authorize</entry>

   <entry key="security.validationFunctionType">plsql</entry>

Please i need help.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2017
Added on Jul 12 2017
0 comments
5,305 views