The driver supports snapshot isolation level.

Note: Snapshot isolation level is not supported for Microsoft Azure Synapse Analytics or Microsoft Analytics Platform System.

You can use snapshot isolation level in either of the following ways:

  • Setting the SnapshotSerializable property changes the behavior of the Serializable isolation level to use the Snapshot isolation level. This allows an application to use the Snapshot isolation level with no or minimum code changes. See SnapshotSerializable for more information.
  • Importing the ExtConstants class allows you to specify the TRANSACTION_SNAPSHOT or TRANSACTION_SERIALIZABLE isolation levels for an individual statement in the same application. The ExtConstants class in the com.ddtek.jdbc.extensions package defines the TRANSACTION_SNAPSHOT constant. For example, the following code imports the ExtConstants class and sets the TRANSACTION_SNAPSHOT isolation level.
    import com.ddtek.jdbc.extensions.ExtConstants;
Connection.setTransactionIsolation(
   ExtConstants.TRANSACTION_SNAPSHOT)