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. Configure the isolation level on the database. 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. Configure the isolation level on the database. 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

• Microsoft SQL Server JDBC Driver

  Supports data source:

  com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource

  Requires the following JAR files:

  sqljdbc4.jar

  Requires the following DataStoreHelper class:

  com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelper

  The JDBC provider requires a valid authentication alias.

  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)

  Supports data source:

  com.microsoft.sqlserver.jdbc.SQLServerXADataSource

  Requires the following JAR files:

  sqljdbc4.jar

  Requires the following DataStoreHelper class:

  com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelper

  The JDBC provider requires a valid authentication alias.

  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

  For use only with the Connect JDBC driver purchased from DataDirect Technologies.

  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)

  This provider is for use only with the Connect JDBC driver purchased from DataDirect Technologies.

  Supports 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.

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