+

Search Tips   |   Advanced Search

Data source minimum required settings for Microsoft SQL Server

Set the appropriate properties on every data source configured. These settings are for Microsoft SQL Server data sources.

The application server also supports two options for setting isolation level in Microsoft SQL Server: SNAPSHOT and READ_COMMITTED_SNAPSHOT.

JDBC provider Isolation level Configuration consideration
Microsoft SQL Server JDBC Driver SNAPSHOT Set the isolation level constant by invoking the setTransactionIsolation method with one of the following attributes:

  • conn.setTransactionIsolation (com.microsoft.sqlserver.jdbc. SQLServerConnection. TRANSACTION_SNAPSHOT)
  • conn.setTransactionIsolation(value_of_constant)

READ_COMMITTED_SNAPSHOT Implements Read committed isolation level. The policy enforces optimistic locking for read operations with Microsoft SQL Server.

  1. Configure the isolation level on the database.

  2. Invoke the setTransactionIsolation method with the attribute...

      conn.setTransactionIsolation (java.sql.Connection. TRANSACTION_READ_COMMITTED)
DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server SNAPSHOT Implements optimistic locking for transactions in which Microsoft SQL Server serializes the data. Configure the ALLOW_SNAPSHOT_ISOLATION setting on the database, and then set the isolation level in one of two ways:

  • By isolation level constant. Invoke the setTransactionIsolation method with one of the following attributes:

    • conn.setTransactionIsolation (com.ddtek.jdbc.extensions. ExtConstants.TRANSACTION_SNAPSHOT)
    • conn.setTransactionIsolation(16)

  • By the custom data source property:

    • Set the data source custom property snapshotSerializable to true.

    • Invoke the setTransactionIsolation method with the attribute...

        conn.setTransactionIsolation (java.sql.Connection. TRANSACTION_SERIALIZABLE)

READ_COMMITTED_SNAPSHOT Implements of the Read committed isolation level. The policy enforces optimistic locking for read operations with Microsoft SQL Server.

  1. Configure the isolation level on the database.

  2. Invoke the setTransactionIsolation method with the attribute...

      conn.setTransactionIsolation (java.sql.Connection. TRANSACTION_READ_COMMITTED)

Consult the Backward Compatibility for Microsoft SQL Server components web page for a complete list of deprecated items, as well as backward compatibility provisions, for Microsoft SQL Server.


Provider types


Related tasks

Configure a JDBC provider and data source
  • Configure a JDBC provider using the administrative console
  • Configure a data source using the administrative console
  • Create a JDBC provider and data source using the JMX API