Query errors for ObjectIds when using MongoDB driver on ORDS23.1 with Oracle 21c
After setting up ORDS 23.1 with my Oracle 21c database, I am unable to perform queries via the ORDS mongodb driver which utilize an ObjectID on any field other than _id.
Setup: Oracle 21c Database, ORDS 23.1
Reproduction steps:
- Setup an user with a new SODA/MongoDB schema
- Connect up to the collection via any MongoDB client (e.g. Compass)
- Create a new collection
- Create a new document
- Add a new field to the document with the type ObjectId (e.g. { _id: ObjectId(...), uid: ObjectId(...) })
- Run a query which uses a ObjectId as the query value (e.g db.myCollection.find({ uid: ObjectId("64a79d9016399b2c9fedf141") })
0