skip to main content
Connection property descriptions : SnapshotSerializable
  

Try DataDirect Drivers Now

SnapshotSerializable

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

setSnapshotSerializable

Default

false

Data type

Boolean

See also

*Isolation levels
*Using the Snapshot isolation level
*Performance considerations