PubSubPersistenceManager.purgeItems incompatibility with Oracle

Description

From the forums;

This is related to .

It looks like the SQL used in the batch to select from OFPUBSUBITEM has a ‘LIMIT’ which is not supported by both Oracle DB and DB2. This makes the purging of OFPUBSUBITEM constantly fail.
Found in 3.9.3, but as far as I can see, it is present in newer versions as well.

Environment

None

Activity

Fixed

Details

Assignee

Reporter

Ignite Forum URL

Components

Fix versions

Affects versions

Priority

Created September 3, 2020 at 9:49 AM
Updated October 28, 2020 at 1:26 PM
Resolved September 3, 2020 at 9:52 AM