prisma: Support Amazon DocumentDB (Cannot create any record with Prisma, `ConnectorError`)

Bug description

Currently we’ve been trying to set up a mongo with a document DB cluster in AWS to use with Prisma, however we couldn’t even make a simple CRUD work.

Any time prisma tries to execute a query that inserts data on the mongo cluster, it crashes with the following message: ConnectorError(ConnectorError { user_facing_error: None, kind: RawDatabaseError { code: "unknown", message: "Command failed (): Feature not supported)" } })

I have no clue on what the problem is, we’ve followed the instructions in the docs to set up the application configuration.

Note that, prisma can read the data normally, the problem only occurs when inserting data.

We know that the database is correclty configured because we tried two other ORMs everything worked.

Maybe Prisma does not support AWS Document Db? wich is weird since it uses Mongo under the hood, right?

How to reproduce

1- Configure a Document Db on AWS 2 - Set up the schema.prisma 3 - Try to insert any data using prisma.model.create() I’m sorry I can’t provide any more details to reproduce, it was our infrastructure team that setted the databases up for us devs to work with, we requested a mongoDb configured with a replica set to use with Prisma and they gave us back the credentials 😛

Expected behavior

The client should be able to connect to a mongoDb cluster on AWS and perform all available operations within PrismaClient

Prisma information

// schema.prisma
generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "mongodb"
  url      = env("DATABASE_URL")
}

model Users {
  id        String @id @default(auto()) @map("_id") @db.ObjectId
  name      String
}

// .env 
DATABASE_URL=mongodb://user:password@host:port/database?authSource=admin&readPreference=primary&directConnection=true&ssl=false&retrywrites=false

Environment & setup

• OS: Windows–>
• Database: MongoDb–>
• Node.js version: 16.1–>

Prisma Version

prisma                  : 3.13.0
@prisma/client          : 3.13.0
Current platform        : windows
Query Engine (Node-API) : libquery-engine efdf9b1183dddfd4258cd181a72125755215ab7b (at node_modules\@prisma\engines\query_engine-windows.dll.node)
Migration Engine        : migration-engine-cli efdf9b1183dddfd4258cd181a72125755215ab7b (at node_modules\@prisma\engines\migration-engine-windows.exe)
Introspection Engine    : introspection-core efdf9b1183dddfd4258cd181a72125755215ab7b (at node_modules\@prisma\engines\introspection-engine-windows.exe)
Format Binary           : prisma-fmt efdf9b1183dddfd4258cd181a72125755215ab7b (at node_modules\@prisma\engines\prisma-fmt-windows.exe)
Default Engines Hash    : efdf9b1183dddfd4258cd181a72125755215ab7b
Studio                  : 0.459.0