Webservice Updates to CLOB Return NULL in WLS Clustered Environment (Doc ID 1344972.1)

Last updated on JULY 31, 2023

Applies to:

Symptoms

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.

Changes

Cause

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