Webservice Updates to CLOB Return NULL in WLS Clustered Environment
Last updated on MARCH 08, 2017
Applies to:Web Services - Version 22.214.171.124.0 to 126.96.36.199.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.
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