TopLink DB Web Service Mixes Request/Response results in JDeveloper 12c

(Doc ID 2410796.1)

Last updated on JUNE 21, 2018

Applies to:

Oracle TopLink - Version 12.2.1.2.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

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

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms