Webservice Updates to CLOB Return NULL in WLS Clustered Environment
(Doc ID 1344972.1)
Last updated on NOVEMBER 14, 2022
Applies to:Web Services - Version 220.127.116.11.0 to 18.104.22.168.0
Information in this document applies to any platform.
This issue can occur for a JAX-WS web service or any J2EE application that utilizes EclipseLink JPA in clustered environment.
In this example, a Stateless EJB packaged as a JAX-WS web service using EJB 3 annotations and EclipseLink JPA is deployed in a WebLogic cluster. The web service invokes a business service to update the database with payloads. Some of these updates are for CLOB data fields. Upon completion of the database update the results are fetched. However for each server in the cluster, if the data field is a CLOB, only the payloads of that particular server are fetched while those of other servers are fetched as NULLs. However fetches of VARCHAR2 data fields, for example, do not exhibit this issue.
Executing the same code in a standalone environment does not encounter this issue and all data is fetched. Issue is only happening in a clustered environment.
When executing SQL statements for fetching records on the database, data is fetched perfectly every time.
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