PubSubPersistenceManager.purgeItems incompatibility with Oracle DB

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

Greg Thomas 
March 27, 2019 at 10:19 AM

Note: PR as submitted only support Oracle, closing this ticket, will create another for DB2 

Fixed

Details

Assignee

Reporter

Ignite Forum URL

Components

Fix versions

Affects versions

Priority

Created December 20, 2018 at 10:00 AM
Updated October 28, 2020 at 1:26 PM
Resolved March 27, 2019 at 10:19 AM