[mongodb] Upgrade MongoDB support from 4.x (max) to 6.0

[ulbi]

Currently the mongodb is only supported with version 4.4 and below.
This limits quite a lot of operations.
When using 6.0 you get the errors - e.g.:

2024-01-21 07:48:10.701 [ERROR] [b.internal.MongoDBPersistenceService] - Failed to connect to collection openhabdb: { "serverUsed" : "devmongodb:27017" , "ok" : 0.0 , "errmsg" : "Unsupported OP_QUERY command: createIndexes. The client driver may require an upgrade. For more details see https://dochub.mongodb.org/core/legacy-opcode-removal" , "code" : 352 , "codeName" : "UnsupportedOpQueryCommand" , "$clusterTime" : { "clusterTime" : { "$ts" : 1705819684 , "$inc" : 1} , "signature" : { "hash" : <Binary Data> , "keyId" : 7321830615794319362}} , "operationTime" : { "$ts" : 1705819684 , "$inc" : 1}}
com.mongodb.CommandFailureException: { "serverUsed" : "devmongodb:27017" , "ok" : 0.0 , "errmsg" : "Unsupported OP_QUERY command: createIndexes. The client driver may require an upgrade. For more details see https://dochub.mongodb.org/core/legacy-opcode-removal" , "code" : 352 , "codeName" : "UnsupportedOpQueryCommand" , "$clusterTime" : { "clusterTime" : { "$ts" : 1705819684 , "$inc" : 1} , "signature" : { "hash" : <Binary Data> , "keyId" : 7321830615794319362}} , "operationTime" : { "$ts" : 1705819684 , "$inc" : 1}}

Your Environment

• Version used: (e.g., openHAB and add-on versions) using the latests stable docker image from openhab
• Environment name and version (e.g. Chrome 76, Java 8, Node.js 12.9, ...):
• Operating System and version (desktop or mobile, Windows 10, Raspbian Buster, ...):

[openhab-bot]

This issue has been mentioned on openHAB Community. There might be relevant details there:

https://community.openhab.org/t/mongo-db-cannot-be-cast-to-class-java-lang-number/153019/2

[lsiepel]

Pr is merged