Data source minimum required settings for Microsoft SQL Server

Network Deployment (Distributed operating systems), v8.0 > Reference > Sets

Data source minimum required settings for Microsoft SQL Server

These properties vary according to the database vendor requirements for JDBC driver implementations. We must set the appropriate properties on every data source that you configure. 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.

Isolation levels in Microsoft SQL Server. The following table describes these isolation levels and configuration considerations.

JDBC provider Microsoft SQL Server feature Configuration consideration
Microsoft SQL Server JDBC Driver SNAPSHOT isolation level 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 isolation level This isolation level is an implementation of the Read committed isolation level. The policy enforces optimistic locking for read operations with Microsoft SQL Server.

Configure the isolation level on the database.
Invoke the setTransactionIsolation method with the conn.setTransactionIsolation (java.sql.Connection. TRANSACTION_READ_COMMITTED) attribute.

DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server SNAPSHOT isolation level This isolation level 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 conn.setTransactionIsolation (java.sql.Connection. TRANSACTION_SERIALIZABLE) attribute:

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

Configure the isolation level on the database.
Invoke the setTransactionIsolation method with the conn.setTransactionIsolation (java.sql.Connection. TRANSACTION_READ_COMMITTED) attribute.

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.
We can configure the following types of providers:

Microsoft SQL Server JDBC Driver
Microsoft SQL Server JDBC Driver (XA)
DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server
DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server (XA)
Microsoft SQL Server JDBC Driver
The Microsoft SQL Server JDBC driver supports this data source:
com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
The JDBC provider requires the following JAR files:
sqljdbc4.jar
The JDBC provider requires the following DataStoreHelper class:
com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelper
The JDBC provider requires a valid authentication alias.
The JDBC driver requires the following properties:

serverName

Name of the server in which Microsoft SQL Server resides. Example: myserver.mydomain.com

portNumber

Specifies the TCP/IP port that Microsoft SQL Server uses for communication. Port 1433 is the default.

databaseName

Name of the database from which the data source obtains connections. Example: Sample.
Microsoft SQL Server JDBC Driver (XA)
This JDBC provider supports this data source:
com.microsoft.sqlserver.jdbc.SQLServerXADataSource
The JDBC provider requires the following JAR files:
sqljdbc4.jar
The JDBC provider requires the following DataStoreHelper class:
com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelper
The JDBC provider requires a valid authentication alias.
The JDBC driver requires the following properties:

serverName

Name of the server in which Microsoft SQL Server resides. Example: myserver.mydomain.com

portNumber

Specifies the TCP/IP port that Microsoft SQL Server uses for communication. Port 1433 is the default.

databaseName

Name of the database from which the data source obtains connections. Example: Sample.
DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server
DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server is a Type 4 JDBC driver that provides JDBC access to the Microsoft SQL Server databases. This provider is for use only with the Connect JDBC driver purchased from DataDirect Technologies.
This JDBC provider supports the following data source:
 com.ddtek.jdbcx.sqlserver.SQLServerDataSource
Requires JDBC driver files:
sqlserver.jar
Requires DataStoreHelper class:
com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper
Requires a valid authentication alias.
Requires properties:

serverName The name of the server in which Microsoft SQL Server resides. Example: myserver.mydomain.com
portNumber The TCP/IP port that Microsoft SQL Server uses for communication. Port 1433 is the default.
databaseName The name of the database from which the data source obtains connections. Example: Sample.
DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server (XA)
DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server (XA) is a Type 4 JDBC driver which provides XA-compliant JDBC access to the Microsoft SQL Server databases. This provider is for use only with the Connect JDBC driver purchased from DataDirect Technologies.
This JDBC provider supports this data source:
com.ddtek.jdbcx.sqlserver.SQLServerDataSource.
Requires JDBC driver files:
sqlserver.jar
Requires DataStoreHelper class:
com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper
Requires a valid authentication alias.
Requires properties:

serverName The name of the server in which Microsoft SQL Server resides. Example: myserver.mydomain.com
portNumber The TCP/IP port that Microsoft SQL Server uses for communication. Port 1433 is the default.
databaseName The name of the database from which the data source obtains connections. Example: Sample.
Configure a JDBC provider and data source
Configure a JDBC provider
Configure a data source
Configure a JDBC provider and data source using the JMX API

+
Search Tips | Advanced Search

JDBC provider	Microsoft SQL Server feature	Configuration consideration
Microsoft SQL Server JDBC Driver	SNAPSHOT isolation level	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 isolation level	This isolation level is an implementation of the Read committed isolation level. The policy enforces optimistic locking for read operations with Microsoft SQL Server. Configure the isolation level on the database. Invoke the setTransactionIsolation method with the conn.setTransactionIsolation (java.sql.Connection. TRANSACTION_READ_COMMITTED) attribute.
DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server	SNAPSHOT isolation level	This isolation level 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 conn.setTransactionIsolation (java.sql.Connection. TRANSACTION_SERIALIZABLE) attribute:
READ_COMMITTED_SNAPSHOT isolation level	This isolation level is an implementation of the Read committed isolation level. The policy enforces optimistic locking for read operations with Microsoft SQL Server. Configure the isolation level on the database. Invoke the setTransactionIsolation method with the conn.setTransactionIsolation (java.sql.Connection. TRANSACTION_READ_COMMITTED) attribute.