TopLink DB Web Service Mixes Request/Response results in JDeveloper 12c
Last updated on JUNE 21, 2018
Applies to:Oracle TopLink - Version 188.8.131.52.0 to 184.108.40.206.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 220.127.116.11.0/18.104.22.168.0.
JDeveloper Studio Edition 22.214.171.124.0 (Build JDEVADF_12.2.1.PATCHSETS_GENERIC_170820.0914.S).
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