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

Last updated on MARCH 08, 2017

Applies to:

Web Services - Version 11.1.1.0.0 to 11.1.1.5.0
Information in this document applies to any platform.

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.

Cause

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