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 126.96.36.199.0 to 188.8.131.52.0 [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 184.108.40.206.0/220.127.116.11.0.
JDeveloper Studio Edition 18.104.22.168.0 (Build JDEVADF_12.2.1.PATCHSETS_GENERIC_170820.0914.S).
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