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.
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:
|
READ_COMMITTED_SNAPSHOT isolation level | This isolation level is an implementation of
the Read committed isolation level. ![]() ![]()
|
|
DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server | SNAPSHOT isolation level | ![]() ![]() Configure the ALLOW_SNAPSHOT_ISOLATION
setting on the database, and then set the isolation level in one of
two ways:
|
READ_COMMITTED_SNAPSHOT isolation level | This isolation level is an implementation of
the Read committed isolation level. ![]() ![]()
|
com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
sqljdbc4.jar (or sqljdbc.jar if using version 1.2 of the driver)
com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelperThe JDBC provider requires a valid authentication alias.
com.microsoft.sqlserver.jdbc.SQLServerXADataSource
sqljdbc4.jar (or sqljdbc.jar if using version 1.2 of the driver)
com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelperThe JDBC provider requires a valid authentication alias.
DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server is a Type 4 JDBC driver that provides JDBC access to the Microsoft SQL Server 2005 and Microsoft SQL Server 2000 databases. This provider is for use only with the Connect JDBC driver purchased from DataDirect Technologies.
com.ddtek.jdbcx.sqlserver.SQLServerDataSource
sqlserver.jar, base.jar and util.jar(The spy.jar file is optional. You need this file to enable spy logging. The spy.jar file is not in the same directory as the other three jar files. Instead, it is located in the ../spy/ directory.)
com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper
Requires a valid authentication alias.
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 2005 and Microsoft SQL Server 2000 databases. This provider is for use only with the Connect JDBC driver purchased from DataDirect Technologies.
com.ddtek.jdbcx.sqlserver.SQLServerDataSource.
sqlserver.jar, base.jar and util.jar.(The spy.jar file is optional. You need this file to enable spy logging. The spy.jar file is not in the same directory as the other three jar files. Instead, it is located in the ../spy/ directory.)
com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper
Requires a valid authentication alias.