File storage backend update (MongoDB 4.4 EOL)

[xgo-work]

File storage using Jackrabbit Oak implementation of JCR uses a MongoDB as backend storage.

• In the current setup the supported version of MongoDB is 4.4 which has reached EOL in February 2024.
• Moreover MongoDB is disregarded for production use (ref ?).

Currently used https://jackrabbit.apache.org/oak/docs/nodestore/document/mongo-document-store.html

[xgo-work]

A possibility would be to use the RDB implementation https://jackrabbit.apache.org/oak/docs/nodestore/document/rdb-document-store.html Which supports many relation databases and has been tested with PSQL

This would harmonize the infrastructure having only postgres instances for the data.

The current implementation initiates the connection this way

DocumentNodeStore nodeStore = newMongoDocumentNodeStoreBuilder()
        .setLeaseCheckMode(LeaseCheckMode.DISABLED)
        .setMongoDB("mongodb://" + hostPort + "/?readConcernLevel=majority", dbName, 0)
        .build();

The new one would be very similar

DocumentNodeStore nodeStore = newRDBDocumentNodeStoreBuilder()
        .setLeaseCheckMode(LeaseCheckMode.DISABLED)
        .setRDBConnection(/* TODO figure out DataSource*/);// connexion info to DB
        .build();

Would be worth giving a try

[xgo-work]

DataSource might be obtained through PGSimpleDataSource in the psql package