Data source minimum required settings for Microsoft SQL Server

These properties vary according to the database vendor requirements for Java Database Connectivity (JDBC) driver implementations. You must set the appropriate properties on every data source that you configure. These settings are for Microsoft® SQL Server data sources.

[Fix Pack 7 or later] Supported configurations: Microsoft SQL Server 2008 is supported by the product with this service release and later.sptcfg
[may2010] The application server also supports two options for setting isolation level in Microsoft SQL Server: SNAPSHOT and READ_COMMITTED_SNAPSHOT. [may2010]
may2010
Table 1. [may2010] Isolation levels in Microsoft SQL Server [may2010]
may2010
. 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 three attributes:
  • [may2010] conn.setTransactionIsolation (com.microsoft.sqlserver.jdbc.SQLServerConnection.TRANSACTION_SNAPSHOT) [may2010]
    may2010
  • conn.setTransactionIsolation(value_of_constant)
READ_COMMITTED_SNAPSHOT isolation level This isolation level is an implementation of the Read committed isolation level. [may2010] The policy enforces optimistic locking for read operations with Microsoft SQL Server. [may2010]
may2010
  1. Configure the isolation level on the database
  2. 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 [may2010] This isolation level implements optimistic locking for transactions in which Microsoft SQL Server serializes the data. [may2010]
may2010
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 three new attributes:
    • conn.setTransactionIsolation (com.ibm.websphere.jdbc.extensions. ExtConstants.TRANSACTION_SNAPSHOT)
    • 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. [may2010] The policy enforces optimistic locking for read operations with Microsoft SQL Server. [may2010]
may2010
  1. Configure the isolation level on the database
  2. Invoke the setTransactionIsolation method with the conn.setTransactionIsolation (java.sql.Connection.TRANSACTION_READ_COMMITTED) attribute.
[may2010] 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. [may2010]
may2010
You can configure the following types of providers:



Related tasks
Configuring a JDBC provider and data source
Configuring a JDBC provider using the administrative console
Configuring a data source using the administrative console
Creating and configuring a JDBC provider and data source using the JMX API
Reference topic    

Terms of Use | Feedback

Last updated: Oct 21, 2010 1:44:59 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=compass&product=was-express-dist&topic=rdat_minreqmssql
File name: rdat_minreqmssql.html