Oracle 10.3.6.9 Bug Report - EclipseLink Issue With Lazy Loaded Lob Fields. (Doc ID 2025009.1)

Last updated on MARCH 04, 2024

Applies to:

Symptoms

Problem appears In Oracle WLS 10.3.6

A persistent unit is defined with 2 entities:

• LazyLobEntity – This entity defines a simple String field named ‘string’ mapped with default settings and a String field named ‘lazyLob’ which is mapped as a lazy-loaded Lob field.
• UnrelatedEntity – This is a simple entity that has no relation whatsoever to the LazyLobEntity.

The steps to reproduce the issue are as follows:

Transaction 1:

1.Create a single LazyLobEntity with content in both the ‘string’ and ‘lazyLob’ fields.
2.Clear the underlying L2 cache. This simulates a timeout of the cached data or the scenario in which the cache is full.

Transaction 2:

1.Delete the UnrelatedEntity entities using a DELETE query.
2.Load and modify the LazyLobEntity but do not access it’s ‘lazyLob’ field.

Transaction 3:

1.Load the LazyLobEntity
2.Read the ‘lazyLob’ field.

  
In Transaction 3.2, the content of the ‘lazyLob’ field is returned as ‘null’. This is wrong. It should contain the value set in the ‘lazyLob’ field in Transaction 1. Checking in the database reveals that the value of the ‘lazyLob’ field has been set correctly.

Cause

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