My Oracle Support Banner

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

Last updated on DECEMBER 01, 2021

Applies to:

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


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 

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

Eclipselink 2.6.5.v20170607-b3d05bd


To view full details, sign in with your My Oracle Support account.

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

In this Document

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