TransactionIsolation

Transaction isolation level.

Each value maps to the standard JDBC isolation level via jdbcLevel. Levels are defined as local Int constants matching the JDBC specification (1, 2, 4, 8) to avoid a java.sql dependency in the shared (JS) build. This keeps sql/shared free of java.sql — the JVM side interprets jdbcLevel via Connection.setTransactionIsolation — mirroring the convention in DbCodec.scala:101 where shared sources keep java.sql constants local.

SQLite semantics: SQLite natively supports only SERIALIZABLE (its default). Other levels are accepted by the driver and documented here but may be treated as SERIALIZABLE by the SQLite engine — the implementation still applies the requested level via Connection.setTransactionIsolation so behaviour is uniform across dialects, with the caveat that on SQLite the isolation guarantee remains serializable regardless of the requested level.