We're updating the issue view to help you get more done. 

Improve support for Clob, Blob, and Nationalized Variants when doing Audit-based queries

Description

While working on HHH-12834, it has become clear that the support for Clob, Blob, NClob, and NBlob types in can be problematic, particularly when an element-collection is in play such as

1 2 3 4 @ElementCollection @Lob @Nationalized private Map<String, String> values;

From the Envers perspective, mappers and initializors tend to build queries using properties regardless of their data types. This leads to issues for data types such as clob and blob where certain database platforms only support a limited subset of predicates against those column types.

For example, Sybase only allows LIKE and IS [NOT] NULL predicates on clob columns. This in particular leads to issues with the QueryGenerator implementions interating with mappers to initialize lazy collections, etc.

A great example is StringMapNationalizedLobTest which was highlighted as a problem in HHH-12834. We temporarily disabled the test because the underlying problem goes deeper than dealing with the translation of CLOB to UNITEXT for Sybase.

Environment

None

Status

Assignee

Chris Cranford

Reporter

Chris Cranford

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Priority

Major