Data source minimum required settings for Microsoft SQL Server

These properties vary according to the database vendor requirements for 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.

Supported configurations: [may2010] You can use Microsoft SQL Server 2008 and 2005 with Version 6.0 of the product to the extent that they are forward compatible from Microsoft SQL Server 2000. Microsoft SQL Server 2000 is the release that was originally tested with Version 6.0 of the product. [may2010]
may2010
sptcfg
[may2010] The application server also supports two options for setting isolation level in Microsoft SQL Server 2008 and 2005: SNAPSHOT and READ_COMMITTED_SNAPSHOT. [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 [may2010] Set the isolation level constant by invoking the setTransactionIsolation method with one of the following attributes: [may2010]
may2010
  • [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 2008 and 2005. [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.
Transact-SQL enhancements, including: new functions, additional data types, and the ability to create recursive queries Do not use these features with the application server.
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 2008 and 2005 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 2008 and 2005. [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.
Transact-SQL enhancements, including: new functions, additional data types, and the ability to create recursive queries Do not use these features with the application server.
[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 2008 or 2005. [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 Java Management Extensions API
Related reference
FTP site for IBM WebSphere embedded ConnectJDBC updates
Reference topic    

Terms of Use | Feedback

Last updated: Aug 29, 2010 10:43:27 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=v602web&product=was-nd-mp&topic=rdat_minreqmssql
File name: rdat_minreqmssql.html