TopLink DB Web Service Mixes Request/Response results in JDeveloper 12c (Doc ID 2410796.1)

Last updated on DECEMBER 01, 2021

Applies to:

Symptoms

An application is developed using JDeveloper 12c "TopLink DB Web Service Provider" and "Generate PLSQL Web Service Provider" capabilities in order to create a web service that will call a database function.
When the application is deployed to the JDeveloper integrated Weblogic server, the web service works as expected when it is called a few times (e.g. from the HTTP Analyzer or SOAPUI).

It is noticed that when the web service is stressed with many concurrent calls, responses are mixed for a few calls. For example, for a majority of calls, if the request passes number "n1", the response returns "n1". However there are a few calls that, while the request passes "n1",  the response returns "n2" where n2 is NOT equal to "n1".

For example 5 DBMS jobs on the database with 5000 concurrent calls, the issue reproduces on a windows OS single JVM. Of 25000 web service calls, 71 returned incorrect responses.
Note that in this case,although a database client is making the calls it also occurs on the mid tier for a java client application.

This occurs for JDeveloper 12.2.1.2.0/12.2.1.3.0. 

JDeveloper Studio Edition 12.2.1.3.0 (Build JDEVADF_12.2.1.PATCHSETS_GENERIC_170820.0914.S).

Eclipselink 2.6.5.v20170607-b3d05bd

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.