Problem

CockroachDB 24.1+ supports using Read Committed transaction level. However, Prisma doesn't recognize that as a valid level either on a client or on a transaction level. Only Serializable is a valid option as of 5.16.1.

Suggested solution

• Adjust TransactionIsolationLevel enum for CockroachDB to include ReadCommitted
• Adjust SQL generation logic to work correctly with ReadCommitted, if necessary.

Alternatives

• Support passing any transaction isolation level, and only throw an error if DB itself throws an error

Additional context

https://www.cockroachlabs.com/docs/stable/read-committed