Purpose

Allows your application to use Snapshot Isolation for connections.

This property is useful for applications that have the Serializable isolation level set. Using the SnapshotSerializable property allows you to use Snapshot Isolation with no or minimum code changes. If you are developing a new application, you may find that using the constant TRANSACTION_SNAPSHOT is a better choice.

Valid values

true | false

Behavior

If set to true and your application has the transaction isolation level set to Serializable, the application uses Snapshot Isolation for connections.

If set to false and your application has the transaction isolation level set to Serializable, the application uses the Serializable isolation level.

Notes

To use Snapshot Isolation, your database also must be configured for Snapshot Isolation.

Data source method

public Boolean getSnapshotSerializable()

public void setSnapshotSerializable(Boolean)

Default

false

Data type

Boolean

See also